In the case where the Operator Console CABI Home page and/or other pages are loading slowly, here are instructions for enabling debug for the JasperServer to expose the backend SQL queries when the pages are trying to load.
- UIM 9.20 or higher
As a privileged user, browse to the web page http://<hostname>:8080/jasperserver-pro/log_settings.html
Go to Manage Server Settings > Log settings and change the ‘SQL query executor’ setting to DEBUG as shown below and then reproduce the slowness, for example by accessing the Home page via a fresh web page before anything is cached:
The resultant debug log file will be stored down path such as:
If you don't see any debug information in the jaspersoft.log, please refer to this article:
CABI (Jaspersoft) debug option for logging is not working
Alternatively, if you need to set it manually:
Depending on the version of JasperServer you are using, you should find this already appears in log4j.properties:
### JasperReports loggers
Uncomment it and you should be get what you need in the log.
Please note that this approach requires restarting the JasperReports Server.
Configuring System Logs