0

I'm getting Execution Timeout Expired I tried below with no chance :

  1. increase the time out on the connection string.
  2. Set ping enabled to false.
  3. Set the Ping Maximum Response Time (seconds) to a large value.

note : Experience analytics data is empty. Do you know if there is any other setting I should apply to resolve this issue?

4264 13:44:18 ERROR Exception when executing agent aggregation/aggregator
Exception: Sitecore.Xdb.Processing.Queue.ProcessingPoolException
Message: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Source: Sitecore.Xdb.Processing.Queue.SqlServer
   at Sitecore.Xdb.Processing.Queue.SqlServer.SqlServerProcessingPool`2.<OnCheckOutAsync>d__41.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Sitecore.Xdb.Processing.Queue.ProcessingPool`1.<CheckOutAsync>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Sitecore.Analytics.Processing.AsyncPoolScheduler`2.<TryGetNextAsync>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Sitecore.Analytics.Aggregation.InteractionAggregationAgent.<ExecuteCoreAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Sitecore.Analytics.Core.Agent.<ExecuteAsync>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Sitecore.Analytics.Core.AsyncBackgroundService.<ExecuteAgentAsync>d__22.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Sitecore.Analytics.Core.AsyncBackgroundService.<RunAsync>d__26.MoveNext()

Nested Exception

Exception: System.Data.SqlClient.SqlException
Message: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Source: .Net SqlClient Data Provider
   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.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryCloseInternal(Boolean closeReader)
   at System.Data.SqlClient.SqlDataReader.Close()
   at System.Data.Common.DbDataReader.Dispose(Boolean disposing)
   at Sitecore.Xdb.Processing.Queue.SqlServer.SqlServerProcessingPool`2.<OnCheckOutAsync>d__41.MoveNext()

Nested Exception

Exception: System.ComponentModel.Win32Exception
Message: The wait operation timed out
4
  • Try scaling up your instance to get rid of such an issue, follow this blog - sitecorejourney.nileshthakkar.in/2019/01/… Dec 7, 2020 at 12:00
  • @GauravAgarwal it's already scaled separate cm/cd
    – marwen1
    Dec 7, 2020 at 12:22
  • Any errors in the xConnect logs?
    – Chris Auer
    Dec 7, 2020 at 20:04
  • specifically, it's your DB and Processing Role that needs scaling. In this case, queries are timing out, which would most likely mean it's the DB that's running out of resources. If processing hasn't run in a while, it will use a lot of resources
    – M.R.
    Dec 10, 2020 at 20:58

1 Answer 1

1

I also got same issue, my site is in sitecore 10.0. Previously my application was working fine but problem started as certificate got renewed. Make sure all your three sites should have proper license. Below given default license path details:

For Identity Server, its in \sitecoreruntime folder For xconnect site ,its in \App_Data and subfolders of App_Data\jobs\continuous

enter image description here

and for dev/public site, its in \App_Data

Once all sites have proper license it worked for me.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.