Troubleshooting dashboard errors
This topic helps you troubleshoot some errors that might occur while working with dashboards.
Issue symptoms | Issue scope | Resolution |
|---|---|---|
| Configuration settings and definitions are not updated for BMC Helix Dashboards. | Updates from the AR servers are not correctly synced to BMC Helix Dashboards. To sync updates, a server restart is required, which is a time-consuming process. | Ensure that the Cache-Sync-Scheduler-Interval-In-Mins parameter is configured correctly. This parameter ensures that the updates are synced periodically from the AR server database to BMC Helix Dashboards. For information about this parameter and its configuration, see Configuration settings C-D. |
The following error is displayed: Failed to fetch | This issue occurs because of the browser session timeout. | Refresh the browser. |
The following error is displayed, and you cannot perform any operations on dashboards. Error: Data has no 'status field'. Check Query and Bar Data field configurations | This issue occurs when a BMC Helix Dashboards instance is open, and you sign out of any other BMC Helix applications, such as BMC Helix Portal or BMC Helix Operations Management. The following image shows a sample error:
| Log in to BMC Helix Portal again, and cross launch to BMC Helix Dashboards. |
The following error is displayed, and you cannot perform any operations on dashboards. Error 552: The SQL database Operation failed. Metric column must be of String data type | This issue occurs when the _metric_ clause is not added to a string data type field. The following image shows a sample error:
| In the SQL query, add the _metric_ clause to a string data type field only. |
The following error is displayed, and you cannot perform any operations on dashboards. | This issue occurs when the Date column misses the _time_ clause. The following image shows a sample error:
| In the SQL query, add the _time_ clause to the Date column. For example, currentDate() AS _time_. |
Unexpected error or timeout occurs for non-admin users.
|  | Verify whether this issue occurs only for non-admin users. Accordingly, optimize the panel or variable query that causes this issue. |
The following error related to the inner join occurs: arsqlquery API throws [ERROR (585): Failed to parse the SQL; Join type 'ALIAS' is not supported. | Verify whether the version of BMC Helix ITSM is compatible. | |
The following error is displayed: Error - 93 - Helix Dashboards - Reports are running out of time |
|
If a large result set is expected, set the Panel Header Timeout parameter value to 600 to avoid timeout issues. Alternatively, optimize the query or add additional filters to reduce the result size and make sure it loads within the time limit. |
