2 Replies Latest reply: Nov 14, 2012 7:01 AM by Gabriel Sideras RSS

    Errors not logged when IKM Oracle Multi Record Insert is selected

    Gabriel Sideras
      Dear All,
      I am new in ODI 11g and I am facing the following problem:

      I created a package with 3 Interfaces with Oracle Multi Record Insert.
      In the first interface I load the source data to a temporary target
      In the second interface target#1 table is loaded using interface#1
      In the third interface target#2 is loaded using interface#1 and the multiple insert is executed and committed.

      This works correctly, but when a data error occurs (e.g. mandatory column is null), instead of the error being logged in the Error table, execution of the last interface fails with the following error:
      Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into (<schema>.<table>.<column>)

      I noticed that when I use Oracle Incremental Update instead, the errors get logged correctly in the error table.

      Does anyone know what could be causing this?