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!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...