# Transaction Group with query on Linked Server stops after 60 seconds

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-with-query-on-linked-server-stops-after-60-seconds/38972>\
**Category:** Ignition\
**Created:** [September 23, 2020, 8:04am UTC](https://forum.inductiveautomation.com/t/transaction-group-with-query-on-linked-server-stops-after-60-seconds/38972 "2020-09-23T08:04:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mario.colombo91](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mario.colombo91/32/14148_2.png) [@mario.colombo91](https://forum.inductiveautomation.com/u/mario.colombo91)\
**Post date:** [September 23, 2020, 8:04am UTC](https://forum.inductiveautomation.com/t/transaction-group-with-query-on-linked-server-stops-after-60-seconds/38972/1 "2020-09-23T08:04:54Z")

</div>

Greetings,

in our project we use a Transaction group that activate a Stored Procedure on DataBase to retrieve data using a query with linked server.  
The Transaction Group operates until 60 seconds, and then stops with error “Read Timeout”.  
 ![TgPanelError](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/8/0871668ac4c33fc457eaddb1a76687e3570523ba.png) ![ReadTimeOut](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/b/3bdcee5a9f557bbcdf955307b7b10a57edb27914.png)  
We tried using a simple stored procedure that waits 2 minutes, but it stops too. Here the detailed error.

 ![DetailedError](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/7/873afb85b9a0373a5d16e21f7a904b7d5eacc9c6.png)

We are using Ignition 8.0.12, Microsoft SQL Server JDBC Driver 4.0.  
This same configuration works on another server, with JDBC driver 4.2.

The fact that our query is blocked exactly at 60 secs is letting us guess that there is a timeout counter on queries; we have seen the “Read Timeout” in timing panel under the Project Properties, but we guess it’s a vision property, not connected to query timings.

 ![ReadTimeoutPanel](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/b/3bd694fbb5f07398862fada27977df469c7a1ea4.png)

How to let our Transaction group works over 60 seconds? It depends on the JDBC drivers? It depends on a Timeout setting? Or there’s another problem with the Transaction Group or the Stored Procedure?

Thanks in advance for your reply

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [September 24, 2020, 8:53pm UTC](https://forum.inductiveautomation.com/t/transaction-group-with-query-on-linked-server-stops-after-60-seconds/38972/2 "2020-09-24T20:53:29Z")

</div>

We are not explicitly setting any query timeout, so it must be a function of the JDBC Driver you are using or the server you are connected to.

---

<div class="post-metadata">

**Author:** ![mario.colombo91](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mario.colombo91/32/14148_2.png) [@mario.colombo91](https://forum.inductiveautomation.com/u/mario.colombo91)\
**Post date:** [November 5, 2020, 4:03pm UTC](https://forum.inductiveautomation.com/t/transaction-group-with-query-on-linked-server-stops-after-60-seconds/38972/3 "2020-11-05T16:03:12Z")

</div>

That’s correct, we upgrated our JDBC driver and it works!