# Query: readt ime out exception

**URL:** <https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [May 9, 2017, 8:15pm UTC](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249 "2017-05-09T20:15:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![claudio](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@claudio](https://forum.inductiveautomation.com/u/claudio)\
**Post date:** [May 9, 2017, 8:15pm UTC](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249/1 "2017-05-09T20:15:11Z")

</div>

Hello  
I have a query that takes about 1 minute and 20 sec in the Management Studio  
If i put this query in a table object i receive the following exception  
Error running query:

SQLQuery(query=MY QUERY  
, database=MY\_DB)@0ms  
On: test.Root Container.Power Table.data  
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:317)  
at java.lang.Thread.run(Unknown Source)  
Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Read timed out  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.newGatewayException(GatewayInterface.java:329)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.getResponse(GatewayInterface.java:488)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:265)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:260)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runLimitQuery(GatewayInterface.java:805)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runQuery(GatewayInterface.java:774)  
at com.inductiveautomation.factorypmi.application.gateway.SQLQuery.execute(SQLQuery.java:48)  
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.execute(QueryManager.java:690)  
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.access$500(QueryManager.java:663)  
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:314)  
… 1 more  
Caused by: java.net.SocketTimeoutException: Read timed out  
at java.net.SocketInputStream.socketRead0(Native Method)  
at java.net.SocketInputStream.socketRead(Unknown Source)  
at java.net.SocketInputStream.read(Unknown Source)  
at java.net.SocketInputStream.read(Unknown Source)  
at java.io.BufferedInputStream.fill(Unknown Source)  
at java.io.BufferedInputStream.read1(Unknown Source)  
at java.io.BufferedInputStream.read(Unknown Source)  
at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)  
at sun.net.www.http.HttpClient.parseHTTP(Unknown Source)  
at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)  
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)  
at java.net.HttpURLConnection.getResponseCode(Unknown Source)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.getResponse(GatewayInterface.java:408)  
… 9 more

How can i increase Read timed out parameter?  
Many thanks  
C.

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [May 9, 2017, 8:53pm UTC](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249/2 "2017-05-09T20:53:55Z")

</div>

Yes, use the [system.util.setReadTimeout](https://docs.inductiveautomation.com/display/DOC79/system.util.setReadTimeout) function. By default it is 60 seconds.

---

<div class="post-metadata">

**Author:** ![claudio](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@claudio](https://forum.inductiveautomation.com/u/claudio)\
**Post date:** [May 9, 2017, 9:13pm UTC](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249/3 "2017-05-09T21:13:45Z")

</div>

Should I use this function in the startup section of gateway scripts?  
Because I have already tried this solution without positive effects

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [May 9, 2017, 11:34pm UTC](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249/4 "2017-05-09T23:34:09Z")

</div>

No, you should put it in the Client Startup Script, not the Gateway Startup Script. Did you try that?

---

<div class="post-metadata">

**Author:** ![claudio](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@claudio](https://forum.inductiveautomation.com/u/claudio)\
**Post date:** [May 10, 2017, 7:31am UTC](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249/5 "2017-05-10T07:31:53Z")

</div>

> [@nmudge](#):
>
> system.util.setReadTimeout

Hello  
I'll try and I'll let you know  
Best regards  
Claudio

---

<div class="post-metadata">

**Author:** ![claudio](https://avatars.discourse-cdn.com/v4/letter/c/7cd45c/32.png) [@claudio](https://forum.inductiveautomation.com/u/claudio)\
**Post date:** [May 10, 2017, 3:58pm UTC](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249/6 "2017-05-10T15:58:34Z")

</div>

Thank you nmudge, it works!