[TERADATA] TeraJDBC 15.10.00.14, Error 804, SQLState 08S01, java.io.IOException: Bad response message header with invalid message length of 8001472 bytes

oracle환경에서 teradata의 데이터를 가져오는 과정에서 오류가 발생했다.

몇일 전 TERA DB 업그레이드를 진행하여 의심이 갔다.

 

찾아보니 실제 TERA DB 업그레이드 영향이 맞았다.

 

원인 : Teradata Database의 버전을 올려서, JDBC Driver와 호환이 되지 않음

 

해결방안 : JDBC Driver의 버전을 올린다. 단, 전체적인 테스트가 필요함

 

테라 에러 로그 : 

[Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 804] [SQLState 08S01] 
Socket communication failure for Packet receive Tue Dec 20 16:15:00 KST 2022 socket orig
=10.253.21.90 local=0.0.0.0/0.0.0.0:11384 remote=10.253.21.90/10.253.21.90:1025 
keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=
unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=0 
connecttotaltime=1 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false 
redrive=false failurecache={/10.253.21.90:1025=Sun Dec 18 09:44:29 KST 2022} cid=38799a7 
sess=172528 java.io.IOException: Bad response message header with invalid message length of 
8001472 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.PreparedStatementController.run(PreparedStatementController.java:46) 
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.TDPreparedStatement.doPrepExecuteQuery(TDPreparedStatement.java:202)  
at com.teradata.jdbc.jdbc_4.TDPreparedStatement.executeQuery(TDPreparedStatement.java:2593)  
at obzen.server.zk.executeQuery(CachedPreparedStatement.java:104) 
at com.obzen.segment.DocCustLoad.insertLoadCustListForXlsx(DocCustLoad.java:4199)
at com.obzen.segment.DocCustLoad.insertCustgLoadList(DocCustLoad.java:766) 
at com.obzen.segment.DocCustLoad.execute(DocCustLoad.java:62) 
at obzen.server.td.obzen ecube(TransactionModelHandler.java:241)  
at obzen.service.workflow.WorkflowNode.run(WorkflowNode.java:587)
at obzen.service.servlet.ObzenServlet.running(ObzenServlet.java:306)  
at obzen.server.rl.run(ServiceWorkThread.java:291)