What Grafana version and what operating system are you using?
What are you trying to achieve?
Alerting based on MSSQL data
How are you trying to achieve it?
Same way as in version v7.0.3
Upgraded Grafana from version v7.0.3 to v.8.0.4.
After the upgrade our MSSQL based alerts returns the following exception if no data returned from SQL server:
error:“request handler failed to convert dataframe “results” to plugins.DataTimeSeriesSlice: input frame is not recognized as a time series”
What did you expect to happen?
Our existing panels should work in the same way as before. If no data returned from SQL it should show that.
Can you copy/paste the configuration(s) that you are having problems with?
This is the Query:
SELECT $__timeGroup(transactionDate, '10m', 0) as time, COUNT(*) as VALUE FROM xxxx.dbo.xxxxx A WHERE $__timeFilter(transactionDate) AND result <> 0 GROUP BY $__timeGroup(transactionDate, '10m') ORDER BY time asc
And this is the alert rule:
- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
in the UI\Alert Rules: Execution Error: request handler failed to convert dataframe “results” to plugins.DataTimeSeriesSlice: input frame is not recognized as a time series
I would appreciate any help.
Thanks a lot!