...
Navigate to Setting ->System -> Logging and Profiling tab
Enable SQL Loggings for SQL log & SQL dump logs
Scroll the same page below to go to the Default Loggers section and click on Configure link.
If QMetry interface is 4x then (Check the interface version from QMetry > About)
Enter Package name as “com.qmetry” and Logging level as “Debug”. Click on Add.
If your QMetry interface is 3.x then (Check the interface version from QMetry > About)
Enter Package name as “com.atlassian.qtm” and Logging level as “Debug”. Click on Add.
In Default Loggers search for the following Package Name and click on “Trace” for the below 3 packages:
net.java.ao.sql
net.java.ao.schema.SchemaGenerator
Enter Package name as “com.atlassian.jira.ofbiz” and set the log level to “Error”.
Once these settings are changed, reproduce the issue on your JIRA instance, so that traces are logged.
Start marking JIRA logs for troubleshooting purposes (e.g.: QMetry replication starts here).
After all steps are completed for reproducing the issue, stop marking the logs (e.g.: QMetry replication ends here).
...