Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

Strange exception saving page

Vote:
 

I have a website where one specific page gives the following exception when trying to save:

Unexpected error when saving 2249_27006 System.Data.SqlClient.SqlException (0x80131904): 
A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable) 
at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) 
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) 
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) 
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) 
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable) 
at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass32_0.<ExecuteTransaction>b__0() 
at EPiServer.Data.Providers.Internal.SqlDatabaseExecutor.<>c__DisplayClass33_0`1.<ExecuteTransaction>b__0() 
at EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute[TResult](Func`1 method) 
at EPiServer.Core.Internal.DefaultContentProviderDatabase.UpdateSoftLinksIfPublishedAndModified(IContent content, StatusTransition statusTransition) 
at EPiServer.Core.Internal.DefaultContentProviderDatabase.Save(IContent content, SaveAction action, String currentUser) 
at EPiServer.Core.Internal.DefaultContentProvider.Save(IContent content, SaveAction action) 
at EPiServer.Core.Internal.DefaultContentRepository.Save(IContent content, SaveAction action, AccessLevel access) 
at EPiServer.Cms.Shell.Service.Internal.ContentService.Save(IContent content, SaveAction saveAction, AccessLevel accessLevel) 
at EPiServer.Cms.Shell.Workspace.Committers.Internal.ContentDataCommitter.Commit(EditContentData change, CommitArguments argument)
ClientConnectionId:846c94df-12c1-4217-b357-81587f247ac4 Error Number:-1,State:0,Class:20

and:

Failed to RollbackTransaction System.InvalidOperationException: 
This SqlTransaction has completed; it is no longer usable. 
at System.Data.SqlClient.SqlTransaction.ZombieCheck() 
at System.Data.SqlClient.SqlTransaction.Rollback() 
at EPiServer.Data.Providers.Internal.ConnectionContext.RollbackTransaction()

The page has quite a lot incoming (internal links) so I do not want to delete and recreate it.

The page has a contentarea with three blocks and one page added. I have noticed that if I remove 1 particular block and the page, I can save the page without errors.

If I add a additional newly created block, the same error comes back.

Any suggestions?

Episerver.CMS.Core 11.14.2
Episerver.CMS.UI 11.23.6

#227835
Edited, Sep 14, 2020 14:36
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.