Size Data Unit (SDU) mismatchException

One Star

Size Data Unit (SDU) mismatchException

When I run the Talend job on Windows, I get the following error (SDU mismatch) anytime there is a database error.
1) Target Column width is insufficient
2) Primary/Foreign Key Value is null
I have wasted 100's of hours trying to figure out the issues in the absence of a proper Oracle error message. SDU mismatch error is not sufficient enough to pinpoint the problem.
Io exception: Size Data Unit (SDU) mismatchException in component tOracleOutput_1
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

I ran the same Job on Unix today, I got a proper error message ORA-01400 that was much easier to debug than the error received on Windows.
Exception in component tOracleOutput_1
java.sql.SQLException: ORA-01400: cannot insert NULL into
("DW_TCSG"."COURSE_ENROLLMENT_FACT"."DW_INSTR_DEMO_KEY")
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
I wish I knew this before, I would have saved 100's of hours me and my team has put in to solve these SDU mismatch errors.
Can someone please tell me why is this happening and how can I get the Oracle errors on Windows instead of generic SDU mismatch error?
Highlighted
Community Manager

Re: Size Data Unit (SDU) mismatchException

Hi
Which version are you using? and what's your JDK version? It seems this problem is related to Oracle Driver.

Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Size Data Unit (SDU) mismatchException

Talend Version: 5.2.1, Build id: r95165-20121212-0909
I am using JRE6 not JDK.
One Star

Re: Size Data Unit (SDU) mismatchException

Hey Shong,
Can you please help me resolve this issue? The SDU mismatch errors are taking a lot of time for us to resolve.
Your help will be highly appreciated.
Thanks a lot in advance!
Vivek
One Star

Re: Size Data Unit (SDU) mismatchException

Can anyone please help me with this issue?
One Star

Re: Size Data Unit (SDU) mismatchException

Hi Shong,
Is there a solution for the issue I am facing at all or is this a Talend bug?
Regards

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now