'ORA-01400: Cannot Insert NULL Into....' Signaled when Running an ODI Integration Interface Loading Flat File Data to a Database Table
(Doc ID 1313763.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 11gR1]
Information in this document applies to any platform.
When loading data from a flat file into a not null primary key field with an ODI version 22.214.171.124, the Integration Interface fails with the following message :
This issue appears after having upgraded from ODI 10g to ODI 11g.
More specifically, when using the LKM File to SQL Knowledge Module, any columns containing ' ' (spacebar characters) are trimmed and a NULL value is inserted into the C$ table and subsequently into the target table(s).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!