ODI 12.2.1.4 Flow Control Check Fails Session After Passing Maximum Allowed Errors
(Doc ID 2755035.1)
Last updated on AUGUST 07, 2024
Applies to:
Oracle Data Integrator - Version 12.2.1.4.210108 and laterOracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.
Symptoms
After upgrading to Oracle Data Integrator (ODI) 12.2.1.4 (or applying Patch 28813200), Flow Control stops checking further rows against the constraints after the maximum error threshold is marked with an error.
However, the behavior experienced in ODI 12.2.1.2 and 12.2.1.3 was to check the entire set of data and mark the session as failed if the max error threshold was met.
See the following examples for clarification.
Example One (behavior post upgrade): An ODI 12.2.1.4 mapping is configured to use Flow Control, and a datastore is configured to error after a maximum of zero errors. When the mapping is executed and a row fails the check, the row is inserted into the E$ table, the session will stop and no further rows will be checked.
Example Two (behavior prior to upgrade): In ODI 12.2.1.2 or 12.2.1.3, that same configuration will check all the rows and insert all failures into the E$ table before failing the session.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |