Server was unable to process request. ---> Transaction not connected, or was disconnected
I get the following error after I upgraded from 2.1 to 2.1.1, everything was (kinda) working fine before.
Can anyone help please?
Server was unable to process request. ---> Transaction not connected, or was disconnected
Error details
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Transaction not connected, or was disconnected at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.Rollback() in d:\TeamCity6\buildAgent\work\8233cfd3f736a0ca\Umbraco.Courier.RepositoryProviders\WebserviceProvider\CourierWebserviceRepositoryProvider.cs:line 372 at Umbraco.Courier.Core.ExtractionManager.ExtractRevisions() at Umbraco.Courier.UI.Dialogs.CommitItem.TransferAndExtractOnSelectedRepo(String repo) at Umbraco.Courier.UI.Dialogs.CommitItem.oneSteptransfer(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Have you upgraded both sites?? Are you using some kind of authentication on the target website so that Courier can't connect. Is the username you're logged in as in Umbraco the same as the username on the other server (and are the passwords equal as well)?
could not execute query [ SELECT this_.id as id32_0_, this_.createDate as createDate32_0_, this_.level as level32_0_, this_.nodeObjectType as nodeObje4_32_0_, this_.nodeUser as nodeUser32_0_, this_.path as path32_0_, this_.sortOrder as sortOrder32_0_, this_.text as text32_0_, this_.trashed as trashed32_0_, this_.uniqueID as uniqueID32_0_, this_.parentID as parentID32_0_ FROM [umbracoNode] this_ WHERE this_.parentID = @p0 and this_.nodeObjectType = @p1 ] Positional parameters: #0>-1 #1>c66ba18e-eaf3-4cff-8a22-41b16d66a972 [SQL: SELECT this_.id as id32_0_, this_.createDate as createDate32_0_, this_.level as level32_0_, this_.nodeObjectType as nodeObje4_32_0_, this_.nodeUser as nodeUser32_0_, this_.path as path32_0_, this_.sortOrder as sortOrder32_0_, this_.text as text32_0_, this_.trashed as trashed32_0_, this_.uniqueID as uniqueID32_0_, this_.parentID as parentID32_0_ FROM [umbracoNode] this_ WHERE this_.parentID = @p0 and this_.nodeObjectType = @p1]
Error details
NHibernate.ADOException: could not execute query [ SELECT this_.id as id32_0_, this_.createDate as createDate32_0_, this_.level as level32_0_, this_.nodeObjectType as nodeObje4_32_0_, this_.nodeUser as nodeUser32_0_, this_.path as path32_0_, this_.sortOrder as sortOrder32_0_, this_.text as text32_0_, this_.trashed as trashed32_0_, this_.uniqueID as uniqueID32_0_, this_.parentID as parentID32_0_ FROM [umbracoNode] this_ WHERE this_.parentID = @p0 and this_.nodeObjectType = @p1 ] Positional parameters: #0>-1 #1>c66ba18e-eaf3-4cff-8a22-41b16d66a972 [SQL: SELECT this_.id as id32_0_, this_.createDate as createDate32_0_, this_.level as level32_0_, this_.nodeObjectType as nodeObje4_32_0_, this_.nodeUser as nodeUser32_0_, this_.path as path32_0_, this_.sortOrder as sortOrder32_0_, this_.text as text32_0_, this_.trashed as trashed32_0_, this_.uniqueID as uniqueID32_0_, this_.parentID as parentID32_0_ FROM [umbracoNode] this_ WHERE this_.parentID = @p0 and this_.nodeObjectType = @p1] ---> System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed. at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, 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.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) 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.GetNodeChildren(Guid uniqueId, Guid nodeObjectType, ISession session) in d:\TeamCity6\buildAgent\work\8233cfd3f736a0ca\Umbraco.Courier.Persistence.NHibernate\Helpers\CmsNodeHelper.cs:line 90 at Umbraco.Courier.Persistence.V4.NHibernate.Persisters.DocumentItem.AvailableItems[T](ItemIdentifier itemId) in d:\TeamCity6\buildAgent\work\8233cfd3f736a0ca\Umbraco.Courier.Persistence.NHibernate\Persisters\Document.cs:line 23 at Umbraco.Courier.Core.ItemCrud.AvailableItems[T]() at Umbraco.Courier.Core.ItemCrudProvider.AvailableItems[T]() at Umbraco.Courier.ItemProviders.DocumentItemProvider.AvailableSystemItems() in d:\TeamCity6\buildAgent\work\8233cfd3f736a0ca\Umbraco.Courier.Providers\ItemProviders\ContentItemProvider.cs:line 36 at Umbraco.Courier.Core.ItemProvider.FindSystemItem(String id) at Umbraco.Courier.UI.Dialogs.CommitItem.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ExecuteReader requires an open and available Connection. The connection's current state is closed.
System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed. at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, 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,
thanks for the reply, yea everything worked fine before the upgrade bar long file names which is why I upgraded. Not sure what action is best, we were thinking of deleting the umbraco tables then reinstalling Umbraco and courier then trying another deploy.
Server was unable to process request. ---> Transaction not connected, or was disconnected
I get the following error after I upgraded from 2.1 to 2.1.1, everything was (kinda) working fine before.
Can anyone help please?
Server was unable to process request. ---> Transaction not connected, or was disconnected
Error details
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Transaction not connected, or was disconnectedat System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Umbraco.Courier.RepositoryProviders.CourierWebserviceRepositoryProvider.Rollback() in d:\TeamCity6\buildAgent\work\8233cfd3f736a0ca\Umbraco.Courier.RepositoryProviders\WebserviceProvider\CourierWebserviceRepositoryProvider.cs:line 372
at Umbraco.Courier.Core.ExtractionManager.ExtractRevisions()
at Umbraco.Courier.UI.Dialogs.CommitItem.TransferAndExtractOnSelectedRepo(String repo)
at Umbraco.Courier.UI.Dialogs.CommitItem.oneSteptransfer(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Have you upgraded both sites?? Are you using some kind of authentication on the target website so that Courier can't connect. Is the username you're logged in as in Umbraco the same as the username on the other server (and are the passwords equal as well)?
Here is an error I get on the server:
Application Error
could not execute query [ SELECT this_.id as id32_0_, this_.createDate as createDate32_0_, this_.level as level32_0_, this_.nodeObjectType as nodeObje4_32_0_, this_.nodeUser as nodeUser32_0_, this_.path as path32_0_, this_.sortOrder as sortOrder32_0_, this_.text as text32_0_, this_.trashed as trashed32_0_, this_.uniqueID as uniqueID32_0_, this_.parentID as parentID32_0_ FROM [umbracoNode] this_ WHERE this_.parentID = @p0 and this_.nodeObjectType = @p1 ] Positional parameters: #0>-1 #1>c66ba18e-eaf3-4cff-8a22-41b16d66a972 [SQL: SELECT this_.id as id32_0_, this_.createDate as createDate32_0_, this_.level as level32_0_, this_.nodeObjectType as nodeObje4_32_0_, this_.nodeUser as nodeUser32_0_, this_.path as path32_0_, this_.sortOrder as sortOrder32_0_, this_.text as text32_0_, this_.trashed as trashed32_0_, this_.uniqueID as uniqueID32_0_, this_.parentID as parentID32_0_ FROM [umbracoNode] this_ WHERE this_.parentID = @p0 and this_.nodeObjectType = @p1]
Error details
NHibernate.ADOException: could not execute query[ SELECT this_.id as id32_0_, this_.createDate as createDate32_0_, this_.level as level32_0_, this_.nodeObjectType as nodeObje4_32_0_, this_.nodeUser as nodeUser32_0_, this_.path as path32_0_, this_.sortOrder as sortOrder32_0_, this_.text as text32_0_, this_.trashed as trashed32_0_, this_.uniqueID as uniqueID32_0_, this_.parentID as parentID32_0_ FROM [umbracoNode] this_ WHERE this_.parentID = @p0 and this_.nodeObjectType = @p1 ]
Positional parameters: #0>-1 #1>c66ba18e-eaf3-4cff-8a22-41b16d66a972
[SQL: SELECT this_.id as id32_0_, this_.createDate as createDate32_0_, this_.level as level32_0_, this_.nodeObjectType as nodeObje4_32_0_, this_.nodeUser as nodeUser32_0_, this_.path as path32_0_, this_.sortOrder as sortOrder32_0_, this_.text as text32_0_, this_.trashed as trashed32_0_, this_.uniqueID as uniqueID32_0_, this_.parentID as parentID32_0_ FROM [umbracoNode] this_ WHERE this_.parentID = @p0 and this_.nodeObjectType = @p1] ---> System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, 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.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
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.GetNodeChildren(Guid uniqueId, Guid nodeObjectType, ISession session) in d:\TeamCity6\buildAgent\work\8233cfd3f736a0ca\Umbraco.Courier.Persistence.NHibernate\Helpers\CmsNodeHelper.cs:line 90
at Umbraco.Courier.Persistence.V4.NHibernate.Persisters.DocumentItem.AvailableItems[T](ItemIdentifier itemId) in d:\TeamCity6\buildAgent\work\8233cfd3f736a0ca\Umbraco.Courier.Persistence.NHibernate\Persisters\Document.cs:line 23
at Umbraco.Courier.Core.ItemCrud.AvailableItems[T]()
at Umbraco.Courier.Core.ItemCrudProvider.AvailableItems[T]()
at Umbraco.Courier.ItemProviders.DocumentItemProvider.AvailableSystemItems() in d:\TeamCity6\buildAgent\work\8233cfd3f736a0ca\Umbraco.Courier.Providers\ItemProviders\ContentItemProvider.cs:line 36
at Umbraco.Courier.Core.ItemProvider.FindSystemItem(String id)
at Umbraco.Courier.UI.Dialogs.CommitItem.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ExecuteReader requires an open and available Connection. The connection's current state is closed.
System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, 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,
Hi Seb,
thanks for the reply, yea everything worked fine before the upgrade bar long file names which is why I upgraded. Not sure what action is best, we were thinking of deleting the umbraco tables then reinstalling Umbraco and courier then trying another deploy.
Any ideas would be really helpful.
Thanks,
B
is working on a reply...