ysmallik

Query Timing out after 15 seconds. Please Help...

Discussion created by ysmallik on Apr 17, 2013
Latest reply on Apr 17, 2013 by Gregor

The query is :

 

 

 
SELECT pi.tag,pi.time,pi.value,pp.userint1 FROM piinterp2 pi, pipoint pp
   WHERE pi.tag like '%GN_MW-_-_%-_-AV' ESCAPE '-' and pi.time = '2013-04-03 20:00:00'
   and pi.tag = pp.tag and pp.userint1 > 0
union
SELECT pc.tag,pc.time time, pc.value,pp.userint1 FROM picomp2 pc , pipoint pp
   WHERE pc.tag like '%GN_MW-_-_%-_-AV' ESCAPE '-' and pc.time >= '2013-04-03 20:00:00'
   and pc.time < '2013-04-03 20:05:00' and pc.tag = pp.tag and pp.userint1 > 0
order by tag, time

 Here is my url and JDBC Driver information.

 

URL: jdbc:pisql://adpiweb1/Data Source=adchis1; Integrated Security=SSPI; Support PI Wildcards = False; Time Zone=UTC;  Command Timeout=100;

 

com.osisoft.jdbc.Driver 1.3.0.0251

 

PI SQL DataAccessServer Build 251 using PIOLEDB

 

PIOLEDB: 3.3.1.2

 

 java.sql.SQLException: [PI SQL DAS gSOAP Channel] End of file or no input: Operation interrupted or timed out after 630s send or 630s receive delay

 

at com.osisoft.jdbc.StatementImpl.executeQuery(StatementImpl.java:306) at getSnap2.main(getSnap2.java:85)

 

Caused by:com.osisoft.rdsa.RdsaException: [PI SQL DAS gSOAP Channel] End of file or no input: Operation interrupted or timed out after 630s send or 630s receive delay

 

at com.osisoft.rdsa.Command.ExecuteReader(Native Method)

 

at com.osisoft.rdsa.Command.executeReader(Command.java:72)

 

at com.osisoft.jdbc.StatementImpl.executeQuery(StatementImpl.java:302)

 

... 1 more

 

java.sql.SQLException: [PI SQL DAS gSOAP Channel] End of file or no input: Operation interrupted or timed out after 630s send or 630s receive delay

 

at com.osisoft.jdbc.ConnectionImpl.close(ConnectionImpl.java:113)

 

at getSnap2.main(getSnap2.java:129)

 

Why is my query timing out after 15 seconds? What should I do the get around this problem and what does 630s mean in the error message.

 


Thanks

 

Yudhvir Singh

Outcomes