tteradata input Truncation Error

Four Stars

tteradata input Truncation Error

Hi

While reading data from tteradatainput ,I am getting the below error.

If i read 100 records then it works fine, it fails for around 90k records. Any help?

 

 

Starting job TestTrunc at 16:16 01/06/2018.

[statistics] connecting to socket on port 3804
[statistics] connected
2018-06-01 16:16:20|I6cAJs|I6cAJs|I6cAJs|11928|MSA|TestTrunc|_iiip8GXvEei_spld3uFkiw|0.1|Default||begin||
2018-06-01.16:16:24.189 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@3532ec19 Read message 1: Bad response message header with invalid message length of 6362648 bytes
2018-06-01.16:16:24.357 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@3532ec19 Read message 1 failed; closing socket due to: java.io.IOException: Bad response message header with invalid message length of 6362648 bytes
2018-06-01.16:16:24.414 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@3532ec19 Packet receive Fri Jun 01 16:16:24 PDT 2018 socket orig=teradevl.ca.boeing.com local=0.0.0.0/0.0.0.0:64453 remote=teradevlcop1.ca.boeing.com/137.136.234.163:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=36 connecttotaltime=39 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=670002 sess=10111881 java.io.IOException: Bad response message header with invalid message length of 6362648 bytes   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:768)   at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)   at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:141)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:137)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:128)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:329)   at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:317)   at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1106)   at msa.testtrunc_0_1.TestTrunc.tTeradataInput_1Process(TestTrunc.java:1026)   at msa.testtrunc_0_1.TestTrunc.runJobInTOS(TestTrunc.java:10066)   at msa.testtrunc_0_1.TestTrunc.main(TestTrunc.java:9872)  
[FATAL]: msa.testtrunc_0_1.TestTrunc - tTeradataInput_1 [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive Fri Jun 01 16:16:24 PDT 2018 socket orig=teradevl.ca.boeing.com local=0.0.0.0/0.0.0.0:64453 remote=teradevlcop1.ca.boeing.com/137.136.234.163:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=36 connecttotaltime=39 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=670002 sess=10111881 java.io.IOException: Bad response message header with invalid message length of 6362648 bytes   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:768)   at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)   at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:141)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:137)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:128)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:329)   at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:317)   at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1106)   at msa.testtrunc_0_1.TestTrunc.tTeradataInput_1Process(TestTrunc.java:1026)   at msa.testtrunc_0_1.TestTrunc.runJobInTOS(TestTrunc.java:10066)   at msa.testtrunc_0_1.TestTrunc.main(TestTrunc.java:9872)  
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive Fri Jun 01 16:16:24 PDT 2018 socket orig=teradevl.ca.boeing.com local=0.0.0.0/0.0.0.0:64453 remote=teradevlcop1.ca.boeing.com/137.136.234.163:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=36 connecttotaltime=39 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=670002 sess=10111881 java.io.IOException: Bad response message header with invalid message length of 6362648 bytes   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:768)   at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)   at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:141)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:137)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:128)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:329)   at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:317)   at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1106)   at msa.testtrunc_0_1.TestTrunc.tTeradataInput_1Process(TestTrunc.java:1026)   at msa.testtrunc_0_1.TestTrunc.runJobInTOS(TestTrunc.java:10066)   at msa.testtrunc_0_1.TestTrunc.main(TestTrunc.java:9872)  
    at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:94)
    at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:69)
    at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:207)
    at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59)
    at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:919)
    at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:141)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:137)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:128)
    at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)
    at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:329)
    at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:317)
    at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1106)
    at msa.testtrunc_0_1.TestTrunc.tTeradataInput_1Process(TestTrunc.java:1026)
    at msa.testtrunc_0_1.TestTrunc.runJobInTOS(TestTrunc.java:10066)
    at msa.testtrunc_0_1.TestTrunc.main(TestTrunc.java:9872)
Caused by: java.io.IOException: Bad response message header with invalid message length of 6362648 bytes
    at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:768)
    ... 11 more
Exception in component tTeradataInput_1 (TestTrunc)
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive Fri Jun 01 16:16:24 PDT 2018 socket orig=teradevl.ca.boeing.com local=0.0.0.0/0.0.0.0:64453 remote=teradevlcop1.ca.boeing.com/137.136.234.163:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=36 connecttotaltime=39 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=670002 sess=10111881 java.io.IOException: Bad response message header with invalid message length of 6362648 bytes   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:768)   at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)   at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:141)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:137)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:128)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:329)   at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:317)   at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1106)   at msa.testtrunc_0_1.TestTrunc.tTeradataInput_1Process(TestTrunc.java:1026)   at msa.testtrunc_0_1.TestTrunc.runJobInTOS(TestTrunc.java:10066)   at msa.testtrunc_0_1.TestTrunc.main(TestTrunc.java:9872)  
    at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:94)
    at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:69)
    at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:207)
    at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59)
    at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:919)
    at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:141)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:137)
    at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:128)
    at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)
    at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:329)
    at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:317)
    at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1106)
    at msa.testtrunc_0_1.TestTrunc.tTeradataInput_1Process(TestTrunc.java:1026)
    at msa.testtrunc_0_1.TestTrunc.runJobInTOS(TestTrunc.java:10066)
    at msa.testtrunc_0_1.TestTrunc.main(TestTrunc.java:9872)
Caused by: java.io.IOException: Bad response message header with invalid message length of 6362648 bytes
    at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:768)
    ... 11 more
Data truncation
2018-06-01 16:16:24|I6cAJs|I6cAJs|I6cAJs|MSA|TestTrunc|Default|6|Java Exception|tTeradataInput_1|java.sql.SQLException:[Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive Fri Jun 01 16:16:24 PDT 2018 socket orig=teradevl.ca.boeing.com local=0.0.0.0/0.0.0.0:64453 remote=teradevlcop1.ca.boeing.com/137.136.234.163:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=36 connecttotaltime=39 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=670002 sess=10111881 java.io.IOException: Bad response message header with invalid message length of 6362648 bytes   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:768)   at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:768)   at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:141)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:137)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:128)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)   at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:329)   at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:317)   at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1106)   at msa.testtrunc_0_1.TestTrunc.tTeradataInput_1Process(TestTrunc.java:1026)   at msa.testtrunc_0_1.TestTrunc.runJobInTOS(TestTrunc.java:10066)   at msa.testtrunc_0_1.TestTrunc.main(TestTrunc.java:9872)  |1
[ERROR]: msa.testtrunc_0_1.TestTrunc - talendLogs_DB - Data truncation
2018-06-01 16:16:24|I6cAJs|I6cAJs|I6cAJs|11928|MSA|TestTrunc|_iiip8GXvEei_spld3uFkiw|0.1|Default||end|failure|3963
[statistics] disconnected
Job TestTrunc ended at 16:16 01/06/2018. [exit code=1]

Moderator

Re: tteradata input Truncation Error

Hello,

What's your Teradata version? Could you please indicate on which talend build version you got this issue?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tteradata input Truncation Error

You mean the Teradata Driver ? It is 15.10 ([Teradata Database] [TeraJDBC 15.10.00.33])

I am not sure on how to check the enterprise Teradata version. 

 

I am using Talend Real time big data platform 6.4.1

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.