Notifications
Clear all

[Solved] How can I debug report SQL in my server log?

1 Posts
1 Users
1 Reactions
962 Views
0
Topic starter

I have a PickerReport and I need to see the underlying SQL that is called, including the bind variables that are used within the SQL. How can I retrieve this information?

1 Answer
1
Topic starter

This can be accomplished by turning the Report function to DEBUG within the JMX Console and then viewing the SQL within the server log.

Navigate to JMX conosle. For local instances, this is at http://localhost/jmx-console. Once there, click on “Logger=OneNetwork Logger Service”

image

 

Click “DEBUG” under the Reports Function

image

 

Navigate to and open the Report you need to view, in this instance the PickerReport you wish to view

image
image

 

View your Server log for report information. SQL Bind Variables are listed in Blue. The PickerReport SQL is listed in white.

image
image

 

With this data, you can set the bind variables as needed and then run in the database

image