ODI 12.2.1.4 Flow Control Check Fails Session After Passing Maximum Allowed Errors (Doc ID 2755035.1)

Last updated on MARCH 20, 2023

Applies to:

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