3

14416 20:44:14 WARN Cursor with id d1470ede-fbb5-4983-85b8-03fe5cca89d2 (TaskId 00000000-0000-0000-0000-000000000000) has been concurrently modified. It means the task has been completed, canceled, failed, or expired concurrently. Please consider increasing ownership time for cursors.

Exception: Sitecore.Analytics.Core.Data.ConcurrentlyModifiedException Message: Routine caused exception: History_UpdateCursorProgress. Source: Sitecore.Analytics.Sql

Nested Exception

Exception: System.Data.SqlClient.SqlException Message: The interaction cursor has been concurrently modified. Source: .Net SqlClient Data Provider

14416 20:44:14 ERROR Exception when executing agent aggregation/historyWorker Exception: Sitecore.Analytics.Core.Data.ConcurrentlyModifiedException Message: Routine caused exception: History_UpdateCursorProgress. Source: Sitecore.Analytics.Sql

what wrong with it ? Did i miss any setting for configuring multiple processing server ?

I'm working on Sitecore 9.0 Update 1

Thanks!

  • You need to contact Sitecore Support regarding this unique problem and then post answer here for others. – Peter Procházka Jun 15 '18 at 17:32
0

If processing of a single batch is bigger than OwnershipTimeout, or processing was stopped and started after OwnershipTimeout is passed, all agents start to receive the task even if one is already working on it. Each time agent ask for a task the task is returned even if cursor split is already requested. but current agent is working on the task, and will split the cursor only after it processed the first batch. First agent takes the task, and star the work. The others receive tasks, and can't use the cursor as it is not splitable and in progress

You will need to increase the ownershipTimeoutMs parameter in the App_Config\Sitecore\Marketing.xDB\Sitecore.Analytics.Processing.Aggregation.config file to resolve the exception:

<param desc="ownershipTimeoutMs" type="Sitecore.Analytics.Core.ConfigurationHelper, Sitecore.Analytics.Core" factoryMethod="ToInt" arg0="180000" />

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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