# Transaction Groups: SQL server returned incomplete repsonse

**URL:** <https://forum.inductiveautomation.com/t/transaction-groups-sql-server-returned-incomplete-repsonse/16282>\
**Category:** Ignition\
**Created:** [December 11, 2017, 1:45pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-sql-server-returned-incomplete-repsonse/16282 "2017-12-11T13:45:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hazmat480](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\
**Post date:** [December 11, 2017, 1:45pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-sql-server-returned-incomplete-repsonse/16282/1 "2017-12-11T13:45:11Z")

</div>

I am using Ignition version 7.8.4. We had to shutdown the server for a power outage. When it came back up 5 of the 18 transaction groups are failing. The error I get is; Error forwarding data: SQL Server returned an incomplete response. The connection has been closed. I am connected to MS Sql Server 2008 R2 Standard. I have tried rebooting both the database server and the Ignition server as well as just the gateway. Every time I change something a different number of transaction groups are failing all with the same error.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 11, 2017, 2:59pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-sql-server-returned-incomplete-repsonse/16282/2 "2017-12-11T14:59:14Z")

</div>

I’ve seen ‘incomplete response’ errors before, but it’s been a long time. If I recall correctly, the database was under extra load for some reason, and queries were taking extra long to process. Which tripped a query duration limit in the database that was chopping off the connection. Check if your database is enforcing a low database query duration.  
Also consider disabling your transaction groups then re-enabling them one by one.

---

<div class="post-metadata">

**Author:** ![Hazmat480](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\
**Post date:** [December 11, 2017, 5:51pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-sql-server-returned-incomplete-repsonse/16282/3 "2017-12-11T17:51:57Z")

</div>

Thank you, I think it was under a heavy load after coming out of the shutdown. They are working fine now.