"KUP-04020: found record longer than <SIZE>, In /<DBFS MOUNT POINT>/<FILE>" Error is Encountered when Executing ODI Load Plans with Exadata as Target
(Doc ID 2502062.1)
Last updated on OCTOBER 17, 2019
Oracle Data Integrator - Version 126.96.36.199.0 and later Information in this document applies to any platform.
The following error is received when executing Oracle Data Integrator (ODI) Load Plans with Exadata as a Target:
ODI-1226: Step <STEP> fails after 1 attempt(s). ODI-1240: Flow <FLOW> fails while performing a Integration operation. This flow loads target table <TARGET TABLE>. ODI-1228: Task <TASK> fails on the target ORACLE connection <DATA SERVER>. Caused By: java.sql.SQLException: ORA-29913: error in executing <CALLOUT_NAME> callout ORA-29400: data cartridge error KUP-04020: found record longer than buffer size supported, <SIZE>, in /<DBFS MOUNT POINT>/<FILE.bad> (offset=<OFFSET>)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) ...
Some bad files are created in the server after the execution.
After manually removing all bad files and running again, the execution succeeds.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!