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]

1 REPLY
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.