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!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...