One Star

Protocol violation - urgently need some advice

Hi we are running ETL version 6.2.1  .  we had this error.  It is not consistent on one table.  It change table every time we run a job flow. It could be driver issue, but what type of issue and how to solve this issue.
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tOracleInput_43 Protocol violation
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tParallelize_row12 - null
Exception in component tOracleInput_43
java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:776)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1035)
at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:297)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_43Process(S_AML_CUSTOMER.java:29788)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER$23.run(S_AML_CUSTOMER.java:32570)
Exception in component tParallelize_row12
java.lang.Exception: At least one of the subjobs in tParallelize fails
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tParallelize_row12Process(S_AML_CUSTOMER.java:32809)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_30Process(S_AML_CUSTOMER.java:11635)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_1Process(S_AML_CUSTOMER.java:4400)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_3Process(S_AML_CUSTOMER.java:3882)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_2Process(S_AML_CUSTOMER.java:3209)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.runJobInTOS(S_AML_CUSTOMER.java:33948)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.runJob(S_AML_CUSTOMER.java:32990)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_2Process(AML3_STAGING_JOBS_FLOW.java:2309)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_2Process(AML3_STAGING_JOBS_FLOW.java:2135)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_1Process(AML3_STAGING_JOBS_FLOW.java:2013)
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tParallelize_row12 At least one of the subjobs in tParallelize fails
: sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW - tRunJob_2 Child job running failed
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_1Process(AML3_STAGING_JOBS_FLOW.java:1777)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW$2.run(AML3_STAGING_JOBS_FLOW.java:11030)
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_2Process(AML3_STAGING_JOBS_FLOW.java:2334)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_2Process(AML3_STAGING_JOBS_FLOW.java:2135)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_1Process(AML3_STAGING_JOBS_FLOW.java:2013)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_1Process(AML3_STAGING_JOBS_FLOW.java:1777)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW$2.run(AML3_STAGING_JOBS_FLOW.java:11030)
Exception in component tOracleInput_39
java.sql.SQLException: Io exception: Invalid Packet Lenght
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:485)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1254)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_39Process(S_AML_CUSTOMER.java:27110)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER$19.run(S_AML_CUSTOMER.java:32402)
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tOracleInput_39 Io exception: Invalid Packet Lenght
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tParallelize_row12 - null
Exception in component tOracleInput_44
java.sql.SQLException: Io exception: Invalid Packet Lenght
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:485)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1254)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_44Process(S_AML_CUSTOMER.java:30526)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER$24.run(S_AML_CUSTOMER.java:32612)
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tOracleInput_44 Io exception: Invalid Packet Lenght
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tParallelize_row12 - null
Exception in component tOracleInput_40
java.sql.SQLException: Io exception: Invalid Packet Lenght
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:485)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1254)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_40Process(S_AML_CUSTOMER.java:27929)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER$20.run(S_AML_CUSTOMER.java:32444)
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tOracleInput_40 Io exception: Invalid Packet Lenght
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tParallelize_row12 - null
Exception in component tOracleInput_42
java.sql.SQLException: Io exception: Invalid Packet Lenght
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:485)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1254)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_42Process(S_AML_CUSTOMER.java:29242)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER$22.run(S_AML_CUSTOMER.java:32528)
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tOracleInput_42 Io exception: Invalid Packet Lenght
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tParallelize_row12 - null
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tOracleInput_31 Io exception: Invalid Packet Lenght
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tParallelize_row12 - null
Exception in component tOracleInput_31
java.sql.SQLException: Io exception: Invalid Packet Lenght
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:485)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1254)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_31Process(S_AML_CUSTOMER.java:24033)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER$15.run(S_AML_CUSTOMER.java:32234)
java.lang.ThreadDeath
at java.lang.Thread.stop(Thread.java:850)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tParallelize_row12Process(S_AML_CUSTOMER.java:32807)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_30Process(S_AML_CUSTOMER.java:11635)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_1Process(S_AML_CUSTOMER.java:4400)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_3Process(S_AML_CUSTOMER.java:3882)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.tOracleInput_2Process(S_AML_CUSTOMER.java:3209)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.runJobInTOS(S_AML_CUSTOMER.java:33948)
at sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER.runJob(S_AML_CUSTOMER.java:32990)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_2Process(AML3_STAGING_JOBS_FLOW.java:2309)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_2Process(AML3_STAGING_JOBS_FLOW.java:2135)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_1Process(AML3_STAGING_JOBS_FLOW.java:2013)
: sba_etl_uat.s_aml_customer_0_5.S_AML_CUSTOMER - tParallelize_row12 - null
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_1Process(AML3_STAGING_JOBS_FLOW.java:1777)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW$2.run(AML3_STAGING_JOBS_FLOW.java:11030)
Exception in component tOracleInput_3
java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:776)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1035)
at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:297)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)
at sba_etl_uat.s_aml_deptran_0_8.S_AML_DEPTRAN.tOracleInput_3Process(S_AML_DEPTRAN.java:15013)
at sba_etl_uat.s_aml_deptran_0_8.S_AML_DEPTRAN.tOracleInput_1Process(S_AML_DEPTRAN.java:5500)
at sba_etl_uat.s_aml_deptran_0_8.S_AML_DEPTRAN.tOracleInput_10Process(S_AML_DEPTRAN.java:17997)
at sba_etl_uat.s_aml_deptran_0_8.S_AML_DEPTRAN.tOracleInput_9Process(S_AML_DEPTRAN.java:18678)
: sba_etl_uat.s_aml_deptran_0_8.S_AML_DEPTRAN - tOracleInput_3 Protocol violation
at sba_etl_uat.s_aml_deptran_0_8.S_AML_DEPTRAN$2.run(S_AML_DEPTRAN.java:20367)
Exception in component tRunJob_8
: sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW - tRunJob_8 Child job running failed
java.lang.RuntimeException: Child job running failed
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_8Process(AML3_STAGING_JOBS_FLOW.java:6323)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_24Process(AML3_STAGING_JOBS_FLOW.java:6124)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW$10.run(AML3_STAGING_JOBS_FLOW.java:11406)
Ended Staging S_AML_REM_TRAN
Tue Oct 11 19:30:32 PHT 2016
Ended Staging S_AML_FCRATE
Tue Oct 11 19:30:35 PHT 2016
ENDED Staging S_AML_DEPOSIT
Tue Oct 11 19:31:10 PHT 2016
ENDED Staging S_CFOTHDATA
Tue Oct 11 19:35:48 PHT 2016
Io exception: Connection reset
Exception in component tOracleOutput_1
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1160)
at sba_etl_uat.s_aml_customeraddr_0_2.S_AML_CUSTOMERADDR.tOracleInput_3Process(S_AML_CUSTOMERADDR.java:4888)
at sba_etl_uat.s_aml_customeraddr_0_2.S_AML_CUSTOMERADDR.tOracleInput_2Process(S_AML_CUSTOMERADDR.java:2892)
at sba_etl_uat.s_aml_customeraddr_0_2.S_AML_CUSTOMERADDR.tOracleInput_1Process(S_AML_CUSTOMERADDR.java:2174)
at sba_etl_uat.s_aml_customeraddr_0_2.S_AML_CUSTOMERADDR.runJobInTOS(S_AML_CUSTOMERADDR.java:6079)
at sba_etl_uat.s_aml_customeraddr_0_2.S_AML_CUSTOMERADDR.runJob(S_AML_CUSTOMERADDR.java:5211)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_25Process(AML3_STAGING_JOBS_FLOW.java:10131)
: sba_etl_uat.s_aml_customeraddr_0_2.S_AML_CUSTOMERADDR - tOracleOutput_1 - Io exception: Connection reset
: sba_etl_uat.s_aml_customeraddr_0_2.S_AML_CUSTOMERADDR - tOracleOutput_1 Closed Connection
: sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW - tRunJob_25 Child job running failed
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_48Process(AML3_STAGING_JOBS_FLOW.java:9956)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW$19.run(AML3_STAGING_JOBS_FLOW.java:11829)
Exception in component tRunJob_25
java.lang.RuntimeException: Child job running failed
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tRunJob_25Process(AML3_STAGING_JOBS_FLOW.java:10156)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW.tJava_48Process(AML3_STAGING_JOBS_FLOW.java:9956)
at sba_etl_uat.aml3_staging_jobs_flow_0_1.AML3_STAGING_JOBS_FLOW$19.run(AML3_STAGING_JOBS_FLOW.java:11829)
3 REPLIES
One Star

Re: Protocol violation - urgently need some advice

Hey, I found this post which has a similar issue : https://www.talendforge.org/forum/viewtopic.php?pid=191088
Hope it helps.
One Star

Re: Protocol violation - urgently need some advice

HI we already follow the instruction to use the ojdbc7.  Still got error
One Star

Re: Protocol violation - urgently need some advice

Oracle support say..it is caused is similar to this.  
 
https://jira.talendforge.org/browse/TUP-13406 

any help