...
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.
Enter Package name as “com.qmetry” 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 / QMetry Replication ends here).
After all steps are completed for reproducing the issue, stop marking the logs (e.g.: Replication ends here)
...