Application Insights sql dependency error on History_GetTaskStateById

Ask Question

Asked 5 years, 4 months ago

Modified 5 years, 4 months ago

Viewed 402 times

When looking into application insights a see most of the errors coming from:

SQL: [xdb_processing_tasks].[History_GetTaskStateById]

Returning error 50000 running Sitecore 9.0.2. The stored procedure only checks some records and I don't see any exceptions in the logs.

How can I solve this issue or should this dependency be excluded?

asked Aug 14, 2019 at 12:32

Luuk

3751 silver badge9 bronze badges

Is there a message with that error code? Maybe check the sysmessages table: SELECT * FROM sysmessages WHERE error = 50000 - with just the error code, its impossible to see what your issue might be.
– Richard Seal ♦
Commented Aug 14, 2019 at 14:27
Nothing in there, but if I run the stored procedure with an invalid guid, I'll get: Msg 50000, Level 16, State 1, Procedure xdb_processing_tasks.History_GetTaskStateById, Line 77 [Batch Start Line 0] A rebuild process with the specified unique identifier does not exist.
– Luuk
Commented Aug 22, 2019 at 12:06
@Luuk did you resolve this issue? I am seeing the same errors in my application insights logs.
– bmyers
Commented Jan 13, 2020 at 17:31
@bmyers I don't see them anymore, maybe because we've upgraded to the latest Application Insights.
– Luuk
Commented Jan 20, 2020 at 8:55

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

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