We are using sitecore publishing service 2.0. For couple of days things seemed to be working fine, but we have added the:
<PromotionCoordinator> <Options> <RebuildDescendantsTable>true</RebuildDescendantsTable> </Options> </PromotionCoordinator>
to keep the descendants table up to date after publishes. The problem is that when I try to publish something, I have following error in the service logs:
2017-06-21 14:00:26.471 +02:00 [Information] Created manifest 690c673d-27bd-482a-8ce7-874e16272e5c, for target 8e080626-ddc3-4ef4-a1d1-f0be4a200254 2017-06-21 14:00:26.471 +02:00 [Information] Starting the manifest calculation for target : "web" (Id : 8e080626-ddc3-4ef4-a1d1-f0be4a200254) 2017-06-21 14:00:26.657 +02:00 [Information] Start building item index for target: 8e080626-ddc3-4ef4-a1d1-f0be4a200254 2017-06-21 14:01:26.177 +02:00 [Information] Item index built successfully for target: 8e080626-ddc3-4ef4-a1d1-f0be4a200254 2017-06-21 14:01:33.986 +02:00 [Information] Added 43 steps to manifest: 690c673d-27bd-482a-8ce7-874e16272e5c. 2017-06-21 14:01:33.986 +02:00 [Information] Starting to promote the manifests to all targets.. 2017-06-21 14:01:34.046 +02:00 [Information] Starting to promote Target : "web", Manifest : 690c673d-27bd-482a-8ce7-874e16272e5c. 2017-06-21 14:03:47.713 +02:00 [Information] New Job queued : 71399e26-2175-48fe-aaa7-bf4b86e1ecf3 - Targets: "web" 2017-06-21 14:03:51.727 +02:00 [Error] Item Descendants Promote from "Master" to "web" failed. - Error: "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." 2017-06-21 14:03:51.727 +02:00 [Warning] An error occured running an operation on Manifest 690c673d-27bd-482a-8ce7-874e16272e5c, _connection "web". - Error: "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." 2017-06-21 14:03:51.728 +02:00 [Information] Rolling back the transaction for the operation on Manifest 690c673d-27bd-482a-8ce7-874e16272e5c, sourceStore "web". 2017-06-21 14:03:51.970 +02:00 [Error] One or more targets were not succesfully promoted. System.AggregateException: One or more targets were not succesfully promoted. The failed target(s) are: Manifest=690c673d-27bd-482a-8ce7-874e16272e5c Target=8e080626-ddc3-4ef4-a1d1-f0be4a200254. See inner exceptions for details. ---> System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, String endMethod, Boolean isInternal) at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
Where should I increase the timeout, and what might be the optimal value here? Also, could changing the timeout have impact on other, publish related activities?