In ODI 12c, Rows are Incorrectly Inserted Even Though CKM Constraint Is Not Met and Error Threshold Is 0
(Doc ID 2487599.1)
Last updated on FEBRUARY 13, 2019
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
The behavior of Flow Control is different between Oracle Data Integrator (ODI) 11g and 126.96.36.199.0.
In ODI 11g, with "Maximum number of errors allowed" set to 0, when a check constraint is encountered, the bad records are inserted into the error table and the Integration Interface execution is marked as failed. The remaining steps are marked as "waiting". There are no rows inserted into target.
In ODI 12c, with "Maximum number of errors allowed" set to 0, the checks continue to be executed even once bad data is detected. The Mapping execution is still marked as failed, but the rows that are not failing the check are inserted into target. Also, all steps are executed and marked as successful.
With "Maximum number of errors allowed" set to 0, none of the records should be inserted into target.
To reproduce the behavior:
- Create a simple source and target Model.
- On target, implement a check constraint, ie, a number cannot be greater than 1.
- Create a Mapping using ODI 12c, the Oracle CKM and turning ON the Flow Control option.
- Have one or more rows in the Mapping which will fail the check.
- Execute the Mapping and observe the issue.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document