Application insights: SQL Dependency result code "-2"

Question

This is what I get in ~20 out of ~2M SQL dependency AI registrations.

Apparently this result code does not appear in sys.messages, since all message id's in there are positive.

Also I can't seem to find any stack trace information on this error. It seems to be a timeout or general transient error (handled by Polly from my side), but either way it's registered under dependencies and not exceptions.

Does anybody know what this error is and where I can find more information regarding all possible SQL dependency errors I might get?

Ivan Glasenberg · Accepted Answer · 2018-12-04 07:22:09Z

6

I have submitted this issue to app insights team here, and just get feedback:

 -2 means Timeout expired. The timeout period elapsed prior to completion of the 
operation or the server is not responding. (Microsoft SQL Server, Error: -2).

The Sql Exception number is here.

And if you have any concerns, please comment at that thread. Hope it helps.

answered Dec 4, 2018 at 7:22

Ivan Glasenberg

30.3k2 gold badges56 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

George Gkionis Over a year ago

Thank you very much Ivan for your help.

Collectives™ on Stack Overflow

Application insights: SQL Dependency result code "-2"

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related