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.
This issue is caused by the terajdbc4-15.x driver. For the complete error message, see the Teradata web site:
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.