Information

This site will undergo a brief period of maintenance on Friday, 16 October at 2 AM Central/12:30 PM IST. During a 30 minute window, site availability will be intermittent.

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*

BMC Helix Dashboards 23.2