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.
SAP Knowledge Base Article - Preview