I'm a long term Umbraco user but new to Courier, this is my second visit to the product after my previous attempts to make it work failed and this time it's not going great either.
I've just waited about 45 minutes for the package process to do it's thing in order to transfer a site from staging to live only then to be presented with a screen full of stack trace and nothing useful to indicate the problem.
error:Umbraco.Courier.Core.Exceptions.PackageException: Unable to package item 'Document Elevage alternatif Property Data' from provider 'PropertyData' into filename '3cb69913-f783-4a9b-8f1b-17bcbef4fbfb' ---> Umbraco.Courier.Core.Exceptions.RetrieveException: Error retrieving item [3cb69913-f783-4a9b-8f1b-17bcbef4fbfb] from provider [e0472594-e73b-11df-9492-0800200c9a66]. ---> NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT this_.id as id3191_1_, this_.createDate as createDate3191_1_, this_.level as level3191_1_, this_.nodeObjectType as nodeObje4_3191_1_, this_.path as path3191_1_, this_.sortOrder as sortOrder3191_1_, this_.text as text3191_1_, this_.trashed as trashed3191_1_, this_.uniqueID as uniqueID3191_1_, this_.nodeUser as nodeUser3191_1_, this_.parentID as parentID3191_1_, umbracouse2_.id as id3197_0_, umbracouse2_.defaultToLiveEditing as defaultT2_3197_0_, umbracouse2_.startMediaID as startMed3_3197_0_, umbracouse2_.startStructureID as startStr4_3197_0_, umbracouse2_.userDefaultPermissions as userDefa5_3197_0_, umbracouse2_.userDisabled as userDisa6_3197_0_, umbracouse2_.userEmail as userEmail3197_0_, umbracouse2_.userLanguage as userLang8_3197_0_, umbracouse2_.userLogin as userLogin3197_0_, umbracouse2_.userName as userName3197_0_, umbracouse2_.userNoConsole as userNoC11_3197_0_, umbracouse2_.userPassword as userPas12_3197_0_ FROM umbracoNode this_ left outer join umbracoUser umbracouse2_ on this_.nodeUser=umbracouse2_.id WHERE this_.uniqueID = @p0 ] Positional parameters: #0>3cb69913-f783-4a9b-8f1b-17bcbef4fbfb [SQL: SELECT this_.id as id3191_1_, this_.createDate as createDate3191_1_, this_.level as level3191_1_, this_.nodeObjectType as nodeObje4_3191_1_, this_.path as path3191_1_, this_.sortOrder as sortOrder3191_1_, this_.text as text3191_1_, this_.trashed as trashed3191_1_, this_.uniqueID as uniqueID3191_1_, this_.nodeUser as nodeUser3191_1_, this_.parentID as parentID3191_1_, umbracouse2_.id as id3197_0_, umbracouse2_.defaultToLiveEditing as defaultT2_3197_0_, umbracouse2_.startMediaID as startMed3_3197_0_, umbracouse2_.startStructureID as startStr4_3197_0_, umbracouse2_.userDefaultPermissions as userDefa5_3197_0_, umbracouse2_.userDisabled as userDisa6_3197_0_, umbracouse2_.userEmail as userEmail3197_0_, umbracouse2_.userLanguage as userLang8_3197_0_, umbracouse2_.userLogin as userLogin3197_0_, umbracouse2_.userName as userName3197_0_, umbracouse2_.userNoConsole as userNoC11_3197_0_, umbracouse2_.userPassword as userPas12_3197_0_ FROM umbracoNode this_ left outer join umbracoUser umbracouse2_ on this_.nodeUser=umbracouse2_.id WHERE this_.uniqueID = @p0] ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at Umbraco.Courier.Persistence.V4.NHibernate.Helpers.CmsNodeHelper.GetNode(Guid uniqueId, ISession session) in c:\Program Files (x86)\teamcity\buildAgent\work\650bafc4b83aa858\Core\Umbraco.Courier.Persistence.NHibernate\Helpers\CmsNodeHelper.cs:line 69 at Umbraco.Courier.Persistence.V4.NHibernate.Persisters.ContentPropertyDataItem.RetrieveItem[T](ItemIdentifier itemId) in c:\Program Files (x86)\teamcity\buildAgent\work\650bafc4b83aa858\Core\Umbraco.Courier.Persistence.NHibernate\Persisters\ContentPropertyData.cs:line 124 at Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier itemId) --- End of inner exception stack trace --- at Umbraco.Courier.Core.ItemCrudProvider.RetrieveItem[T](ItemIdentifier itemId) at Umbraco.Courier.ItemProviders.PropertyItemProvider.HandlePack(ItemIdentifier id) at Umbraco.Courier.Core.ItemProvider.Package(ItemIdentifier id) at Umbraco.Courier.RepositoryProviders.Local.Package(ItemIdentifier itemId) at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue) --- End of inner exception stack trace --- at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageItem(ItemIdentifier itemId, ItemProvider provider, QueuedItemIdentifier itemInQueue) at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.PackageBatch() at Umbraco.Courier.Core.Packaging.RevisionPackaging.Package() at Umbraco.Courier.Core.TaskManager.manageTask(IRevisionTask value) 3/28/2013 9:00:29 AM
For the benefit of others, I'm not getting this error after using the nightly version 2.7.5.1. The issue does however exist in the Courier_2.7.5.1.90.v4.zip download still.
See this thread for detail of what I suspect is related to the cause of the above error.
Unable to package item errors
I'm a long term Umbraco user but new to Courier, this is my second visit to the product after my previous attempts to make it work failed and this time it's not going great either.
I've just waited about 45 minutes for the package process to do it's thing in order to transfer a site from staging to live only then to be presented with a screen full of stack trace and nothing useful to indicate the problem.
Can anyone shed any light on the cause of this?
For the benefit of others, I'm not getting this error after using the nightly version 2.7.5.1. The issue does however exist in the Courier_2.7.5.1.90.v4.zip download still.
See this thread for detail of what I suspect is related to the cause of the above error.
http://our.umbraco.org/forum/umbraco-pro/courier/39509-Umbraco-v60-and-Courier-275-unable-to-courier-Media-images
is working on a reply...