Search code examples
azureazure-application-insightssqldependency

Application insights: SQL Dependency result code "-2"


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

Azure portal screenshot

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?


Solution

  • 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.