MSSQL Alerting - error if no data returned

[nikolettahorvath]

• 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:

• 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!

[nikolettahorvath]

Version 8.1.3 solved it