It is currently Tue Sep 02, 2014 1:08 am




Post new topic Reply to topic  [ 3 posts ] 
 Read Timed Out Error 
Author Message
Trooper
Trooper

Joined: Thu Jun 10, 2010 10:48 pm
Posts: 17
Post Read Timed Out Error
Hi all,

I got this problem when I try to run a query from a table in PMI and I haven't got any result. But the query is too complex and it takes nearly two minutes when I run it in SQL Server Management Studio. I tried to set the connection time using fpmi.system.setConnectTimeout() function. But I still have that problem. Please let me know how to solve it. I also pasted the error message.


Message: Connection lost because of following error:Read timed out
Time: Thu Mar 3 2:56:45PM
Severity: ERROR
Logger: factorypmi.common.gateway_interface.ConnectionStatus
Stack Trace: java.net.SocketTimeoutException: Read timed out&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at java.net.SocketInputStream.socketRead0(Native Method)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at java.net.SocketInputStream.read(Unknown Source)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at java.io.BufferedInputStream.fill(Unknown Source)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at java.io.BufferedInputStream.read1(Unknown Source)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at java.io.BufferedInputStream.read(Unknown Source)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at sun.net.www.http.HttpClient.parseHTTP(Unknown Source)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at java.net.HttpURLConnection.getResponseCode(Unknown Source)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at com.inductiveautomation.factorypmi.common.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:192)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at com.inductiveautomation.factorypmi.common.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:152)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at com.inductiveautomation.factorypmi.common.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:148)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at com.inductiveautomation.factorypmi.common.gateway_interface.GatewayInterface.runQuery(GatewayInterface.java:454)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at com.inductiveautomation.factorypmi.application.gateway.QueryManager\$QueryExecutor.run(QueryManager.java:321)&#13;<br>&nbsp;&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Unknown Source)&#13;<br>
Stack Trace: java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(Unknown Source)
java.io.BufferedInputStream.fill(Unknown Source)
java.io.BufferedInputStream.read1(Unknown Source)
java.io.BufferedInputStream.read(Unknown Source)
sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)
sun.net.www.http.HttpClient.parseHTTP(Unknown Source)
sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
java.net.HttpURLConnection.getResponseCode(Unknown Source)
com.inductiveautomation.factorypmi.common.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:192)
com.inductiveautomation.factorypmi.common.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:152)
com.inductiveautomation.factorypmi.common.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:148)
com.inductiveautomation.factorypmi.common.gateway_interface.GatewayInterface.runQuery(GatewayInterface.java:454)
com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:321)
java.lang.Thread.run(Unknown Source)


Wed Mar 02, 2011 11:23 pm
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 2:46 pm
Posts: 1982
Location: Sacramento, CA
Post Re: Read Timed Out Error
There is not a way to edit the read timeout setting in FactoryPMI. You will have to optimize the query in order to get it working.

_________________
Travis Cox
Inductive Automation
Technical Support Rep.


Thu Mar 03, 2011 9:23 am
Profile WWW
General
General

Joined: Tue Feb 24, 2009 1:30 pm
Posts: 891
Location: Calgary
Post Re: Read Timed Out Error
If you need help, post the query here and some of the SQL guru's will take it apart for you.


Sun Mar 06, 2011 8:23 pm
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: