SBL-EIM-00205 error in EIM import task

(Doc ID 744975.1)

Last updated on MARCH 11, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 8.0.0.2 [20412] and later
Information in this document applies to any platform.
***Checked for relevance on 10-Oct-2014***


Symptoms

EIM import task failed with following error message:


  Error SBL-EIM-00205: Self-referential join to EIM_CONTACT1.CON_ADDR_ORGGRPNAM not in EIM_CONTACT1
  Error SBL-EIM-00205: Failed to load the application dictionary.


The column mentioned has not been modified, though EIM_CONTACT1 has been modified by the Table Mapping Wizard. As suggested by MOS results, we have tried to modify the NUM_IFTABLE_LOAD_CUTOFF parameter to several values to no effect. The task is invoked in this way:

   srvrmgr /g stmdev1fe1v /e MDEV1FE1 /u sadmin /p SADfE1MdeV1 /c "run task for component EIM server mdev1fe1 with config=/opt/sbl/home/MIG/$1, errorflags= 1, traceflags= 7, sqlflags=8"

Before invoking the task diccache.dat has been deleted and it was regenerated with exactly the same size again.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms