CLI commands for troubleshooting

The following table provides a list of CLI commands to troubleshoot an empty chart in a report:

Command	Description
Check report running/pending status	diagnose report status {running | pending}
Debug sql query	diagnose debug enable diagnose debug application sqlplugind 4 -----errors only diagnose debug application sqlplugind 8
List current SQL process	diagnose sql process list
Configure global report automatic cache setting	config system report auto-cache
List report schedule/auto-cache status by ADOM	execute sql-report list-schedule <ADOM-name>
Diagnose report hcache working status	diagnose test application sqlrptcached 2
Check individual report hcache status	execute sql-report hcache-check <ADOM-name> <schedule-id>
Check report status during report running	diagnose debug enable diagnose sql status sqlreportd