Troubleshooting errors on the dashboards



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

Issue symptoms

Issue scope

Resolution

In 

BMC Helix Dashboards

, you can see errors on the dashboards and you cannot perform any operations.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_out_error.png

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

In 

BMC Helix Dashboards

, you can see errors on the dashboards and you cannot perform any operations.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:

Error552MetricQueryStringType.png

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

In 

BMC Helix Dashboards

, you can see errors on the dashboards and you cannot perform any operations.Error 552: The SQL database Operation failed., No Column with name__time__found

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

The following image shows a sample error:

Error552ColumnWithNameTime.png

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

For example, currentDate() AS _time_.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*