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 |