Application Insights sql dependency error on History_GetTaskStateById

Ask Question

Asked 4 years, 3 months ago

Modified 4 years, 3 months ago

Viewed 333 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 ♦
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
Aug 22, 2019 at 12:06
@Luuk did you resolve this issue? I am seeing the same errors in my application insights logs.
– bmyers
Jan 13, 2020 at 17:31
@bmyers I don't see them anymore, maybe because we've upgraded to the latest Application Insights.
– Luuk
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 that you have read and understand our privacy policy and code of conduct.