Symptom
Webi reports based on Teradata with a jdbc connection which take more than 10 minutes fail.
ct_cdz_error_context:MESSAGE:A database error occured.
The database error text is: [Teradata JDBC Driver] [TeraJDBC
12.00.00.110] [Error 802] [SQLState HY000] Timeout occurred for Packet
receive Sat Jan 29 11:25:50 CST 2011 socket local=/<IP address:port>
remote=<FQDN>/<IP:Port> cid=16de067
sess=1599446 java.net.SocketTimeoutException: Read timed out at
java.net.SocketInputStream.socketRead0(Native Method) at
java.net.SocketInputStream.read(SocketInputStream.java:129) at
com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:356)
at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream
(TDPacketStream.java:818) at
com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action
(StatementReceiveState.java:124) at
com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody
(StatementController.java:108) at
com.teradata.jdbc.jdbc_4.statemachine.StatementController.run
(StatementController.java:99) at
com.teradata.jdbc.jdbc_4.Statement.executeStatement
(Statement.java:309) at
com.teradata.jdbc.jdbc_4.Statement.executeStatement
(Statement.java:254) at com.teradata.jdbc.jdbc_4.Statement.execute
(Statement.java:227) at
com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalStatement.execute
(TeraLocalStatement.java:394) at
com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalStatement.execute
(TeraLocalStatement.java:358) at
com.businessobjects.connectionserver.java.drivers.jdbc.JDBCDriver.prepare(Unknown Source) at
com.businessobjects.connectionserver.java.JAVAOpenJob.describe(Unknown
Source) at
com.businessobjects.connectionserver.core.RepositoryJob.Describe
(Unknown Source) . (WIS 10901)
2
Read more...
Environment
Teradata
JDBC connection
Product
Keywords
ten, 10, setQueryTimeout, teradata sql server 3110, Error 802, Teradata JDBC Driver, Timeout occurred for Packet, SQLState HY000, ODBC , KBA , BI-RA-WBI-DSL , Obsolete, use : BI-RA-WBI-BE-DP , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.