# Transaction group stored procedure read timeout

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-stored-procedure-read-timeout/38286>\
**Category:** Ignition\
**Created:** [September 2, 2020, 8:05am UTC](https://forum.inductiveautomation.com/t/transaction-group-stored-procedure-read-timeout/38286 "2020-09-02T08:05:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrea.parola](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@andrea.parola](https://forum.inductiveautomation.com/u/andrea.parola)\
**Post date:** [September 2, 2020, 8:05am UTC](https://forum.inductiveautomation.com/t/transaction-group-stored-procedure-read-timeout/38286/1 "2020-09-02T08:05:57Z")

</div>

Hello,

I created a stored procedure transaction group to run a sp that takes about 5 minutes to execute.  
After 60 second the transaction group goes in error with “read timeout”

java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out

I tried to modify the properties in the SQL Server in the connection section and in the project properties

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/c/7cc9e840236172f216f24713e227cf58c062bb42.jpeg)

How can I run this stored procedure without having the timeout after 60 seconds?

thank you  
Andrea

---

<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:** [September 2, 2020, 12:00pm UTC](https://forum.inductiveautomation.com/t/transaction-group-stored-procedure-read-timeout/38286/2 "2020-09-02T12:00:42Z")

</div>

Consider running it in the gateway, not from a Vision Client, and using sendMessage to report the results to clients that need it.

---

<div class="post-metadata">

**Author:** ![andrea.parola](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@andrea.parola](https://forum.inductiveautomation.com/u/andrea.parola)\
**Post date:** [September 2, 2020, 12:29pm UTC](https://forum.inductiveautomation.com/t/transaction-group-stored-procedure-read-timeout/38286/3 "2020-09-02T12:29:58Z")

</div>

I did not get your answer, the transaction group is scheduled to run at night, but today I found this error. I checked and the reason is the execution time of the stored procedure. So even I launch it from the vision client or I close it and let it run with the given schedule, I still get the same error.

Can you give me some more details?