AppD Archive

Query Details (Database Monitoring) throw error for stored procedures

CommunityUser
Splunk Employee
Splunk Employee

I am monitoring Microsoft SQL Server trough AppDynamics database monitoring. In top queries dashboard, if I select a stored procedure and click on "view query details", an error is thrown. This works fine when query is a simple select/insert/update. But fails only for stored procedures.

I could see following error in server.log of controller for this action. Please help if you have faced such issue in past.

[#|2016-06-16T08:22:52.885+0000|WARNING|glassfish3.1.2|com.singularity.ee.controller.ui.services.dbMonitoring.queryhelper.QueryHelper|_ThreadID=84;_ThreadName=Thread-5;|End offset found is greater that query length for query: <My stored proc name>
The query length is: 21 and the end offSet is: 930.0|#]

[#|2016-06-16T08:22:52.886+0000|SEVERE|glassfish3.1.2|com.sun.jersey.spi.container.ContainerResponse|_ThreadID=84;_ThreadName=Thread-5;|The RuntimeException could not be mapped to a response, re-throwing to the HTTP container
java.lang.StringIndexOutOfBoundsException: String index out of range: -484

...

0 Karma
Get Updates on the Splunk Community!

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...