EIM Data Loads for Phones failed with SBL-EIM-00999: IF table EIM_CON_DTL has cyclic dependencies (at S_CONTACT) (Doc ID 485821.1)

Last updated on OCTOBER 06, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.8.2.3 SIA [19221] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise) and above
Version: 7.8.2.3 [19221] Life Sci
Database: Oracle 9.2.0.8
Application Server OS: Microsoft Windows 2000 Advanced Server SP 4
Database Server OS: Microsoft Windows 2000 Advanced Server SP 4

This document was previously published as Siebel SR 38-3079405661.

**** Checked for relevance on 07-Oct-2016 *****

Symptoms

Extension columns in EIM_ACCNT_DTL,EIM_CON_DTL and EIM_ASSET have been created using the Mapping Wizzard.While trying to load phones related to Accounts and Contacts using the above mentioned EIM tables these are the errors that have been encountered.

Account Phones Error from the command line
Internal :The process exited abnormally and the Operating system could not get the exit code

Contact Phones Error from the Logfile
Error 999 : IF table EIM_CON_DTL has cyclic dependencies (at S_CONTACT)!
Error 205: Failed to load the application dictionary.

Account Phone Insert .IFB
[Siebel Interface Manager]
        USER NAME = "SADMIN"
        PASSWORD = "SADMIN"
        PROCESS   = IMPORT ACCOUNT

[IMPORT ACCOUNT]
      Type = SHELL
      INCLUDE = "Import Account Phone"

[Import Account Phone]
       TYPE = IMPORT
       BATCH = 999
       TABLE = EIM_ACCNT_DTL
       INSERT ROWS = S_PARTY,FALSE
       UPDATE ROWS = S_PARTY,FALSE
       INSERT ROWS = S_ORG_EXT_XM,TRUE
       UPDATE ROWS = S_ORG_EXT_XM,TRUE
       UPDATE STATISTICS = FALSE
       ONLY BASE TABLES = S_PARTY,S_ORG_EXT_XM
       ONLY BASE COLUMNS = S_PARTY.PARTY_UID,\
                             S_PARTY.PARTY_TYPE_CD,\
                             S_ORG_EXT_XM.PAR_ROW_ID,\
                             S_ORG_EXT_XM.TYPE,\
                             S_ORG_EXT_XM.NAME,\
                             S_ORG_EXT_XM.ATTRIB_34


Contact Phone Insert IFB

[Siebel Interface Manager]
               USER NAME = "SADMIN"
               PASSWORD = "SADMIN"       
               PROCESS   = Import All

[Import All]
       TYPE=SHELL
       INCLUDE = "Import Contact Phone"

[Import Contact Phone]
      TYPE = IMPORT
      BATCH = 444
      TABLE = EIM_CON_DTL
      INSERT ROWS = S_PARTY,FALSE
      UPDATE ROWS = S_PARTY,FALSE
      INSERT ROWS = S_CONTACT_XM,TRUE
      UPDATE ROWS = S_CONTACT_XM,TRUE
      UPDATE STATISTICS = FALSE
      ONLY BASE TAB...

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