Troubleshooting errors on the dashboards

This topic helps you troubleshoot some errors that might appear on the dashboards.

Error: Data has no 'status field'. Check Query and Bar Data field configurations

Issue symptoms

In BMC Helix Dashboards, you can see errors on the dashboards and you cannot perform any operations.

Issue scope

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:

Resolution

Log in to BMC Helix Portal again, and cross launch to BMC Helix Dashboards.

Error 552: The SQL database Operation failed. Metric column must be of String data type

Issue symptoms

In BMC Helix Dashboards, you can see errors on the dashboards and you cannot perform any operations.

Issue scope

This issue occurs when the _metric_ clause is not added to a string data type field. 

The following image shows a sample error:

Resolution

In the SQL query, you must add _metric_ clause to a string data type field only.

Error 552: The SQL database Operation failed., No Column with name__time__found

Issue symptoms

In BMC Helix Dashboards, you can see errors on the dashboards and you cannot perform any operations.

Issue scope

This issue occurs when the Date column is missing the _time_ clause. 

The following image shows a sample error:

Resolution

In the SQL query, you must add _time_ clause the Date column.

For example, currentDate() AS _time_.