Proc_CMS_Document_UpdateDocumentNamePath: caused exception: Timeout expired.

Diane Cogswell asked on May 29, 2014 15:30

Trying to create a copy in en-GB culture from our en-US Culture. This document should have existed, but it's not in the Document Tree. I checked and it's not in the recycle bin and Destroy is disabled. When I try to create the copy, I get the following error (I'll bold the relevant part):

[Win32Exception (0x80004005): The wait operation timed out]

[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +392 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.get_MetaData() +138 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6738869 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6741487 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +180 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +21 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +325 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +420 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +278 CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +228

[Exception: [DataConnection.HandleError]: Query: Proc_CMS_Document_UpdateDocumentNamePath: caused exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.] CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, SqlException ex) +116 CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +369 CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) +257 CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) +475 CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, QueryDataParameters parameters) +44 CMS.DocumentEngine.TreeNode.UpdatePaths(String siteName, Int32 sourceNodeId, Boolean documentPath) +950 CMS.DocumentEngine.TreeNode.InsertAsNewCultureVersionInternal(String cultureCode) +5420 CMS.DocumentEngine.TreeNode.InsertAsNewCultureVersion(String cultureCode, Boolean useDocumentHelper) +275 CMS.DocumentEngine.DocumentHelper.InsertNewCultureVersion(NewCultureDocumentSettings settings) +266 CMSModules_Content_CMSDesk_New_NewCultureVersion.btnCreateDocument_Click(Object sender, EventArgs e) +539 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804

Recent Answers


Diane Cogswell answered on May 30, 2014 09:33

Increasing the timeout value in my DB connection string from default of 30 to 60 solved the issue. We're running a v7 install with over 25K pages across 20+ cultures. I'm guessing when creating a new document/page, it's taking longer to check previous records.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.