Error: 'java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive'

Problem Description

When reading a large number of rows from Teradata and writing the data into a destination table, results in the following error:

Caused by: java.io.IOException: Bad response message header with invalid message length of 16775105 bytes at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:768) ... 11 more Exception in component tDBInput_3 (title_xxxx) java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive

However, Jobs reading a smaller number of rows work as expected.

 

Root Cause

This issue is caused by the terajdbc4-15.x driver. For the complete error message, see the Teradata web site:

https://support.teradata.com/community?id=community_question&sys_id=38164b2f1b57fb00682ca8233a4bcbaf

 

Solution

  • To resolve this issue, use a tLibraryLoad component and upload the terajdbc4-16.x version to the Job.

  • To make the change at the Studio level, delete all versions of the terajdbc drivers from the Studio .m2 directory (C:\Talend\7.0.1\studio\configuration\.m2\repository\com\teradata), except for the 16.x version.

Version history
Revision #:
7 of 7
Last update:
‎03-23-2020 06:50 AM
Updated by:
 
Contributors