# MSSQL Alerting - error if no data returned

**URL:** <https://community.grafana.com/t/mssql-alerting-error-if-no-data-returned/50164>\
**Category:** Alerting\
**Tags:** mssql, alerting\
**Created:** [July 8, 2021, 12:45pm UTC](https://community.grafana.com/t/mssql-alerting-error-if-no-data-returned/50164 "2021-07-08T12:45:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nikolettahorvath](https://avatars.discourse-cdn.com/v4/letter/n/bb73d2/32.png) [@nikolettahorvath](https://community.grafana.com/u/nikolettahorvath)\
**Post date:** [July 8, 2021, 12:45pm UTC](https://community.grafana.com/t/mssql-alerting-error-if-no-data-returned/50164/1 "2021-07-08T12:45:27Z")

</div>

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

```auto
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](https://us1.discourse-cdn.com/grafana/original/3X/9/f/9f71d575153069c0ba2dcad0013ac329c4b3121c.png)

- 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](https://us1.discourse-cdn.com/grafana/original/3X/c/5/c54c1e396a0127aeb7fd6afa9dcd3e4900d96dc1.png)

I would appreciate any help.  
Thanks a lot!

---

<div class="post-metadata">

**Author:** ![nikolettahorvath](https://avatars.discourse-cdn.com/v4/letter/n/bb73d2/32.png) [@nikolettahorvath](https://community.grafana.com/u/nikolettahorvath)\
**Post date:** [September 13, 2021, 11:15am UTC](https://community.grafana.com/t/mssql-alerting-error-if-no-data-returned/50164/2 "2021-09-13T11:15:33Z")

</div>

Version 8.1.3 solved it

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/grafana/original/2X/e/ef5308cc58c9e5a13187b5012eb99f406928462f.png) [@system](https://community.grafana.com/u/system)\
**Post date:** [July 8, 2022, 12:46pm UTC](https://community.grafana.com/t/mssql-alerting-error-if-no-data-returned/50164/3 "2022-07-08T12:46:14Z")

</div>

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