SAP Knowledge Base Article - Preview

1554427 - WebIntelligence reports based on Teradata timeout after 10 minutes

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

SAP BusinessObjects Enterprise XI 3.1

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.