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?