MSSQL Alerting - error if no data returned

Grafana Alerting
,
1

  • What Grafana version and what operating system are you using?
    Grafana v8.0.4

  • 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

  • What happened?
    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:

screen2
screen2707×254 11.6 KB

  • 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
    screen1
    screen1864×103 5.59 KB

I would appreciate any help.
Thanks a lot!

2

Version 8.1.3 solved it

3

This topic was automatically closed after 365 days. New replies are no longer allowed.