My Oracle Support Banner

Siebel EIM Import From SIEBEL.EIM_CONTACT Table Failing With ORA-00001: unique constraint (SIEBEL.S_CONTACT_U1) violated Error (Doc ID 2759935.1)

Last updated on DECEMBER 02, 2023

Applies to:

Siebel CRM - Version 8.1.1.11.17 [IP2013] and later
Information in this document applies to any platform.

Symptoms

Siebel IP13:

EIM Import from EIM_CONTACT table is failing and sending errors:

ORA-00001: unique constraint (SIEBEL.S_CONTACT_U1) violated and

SBL-EIM-00101: Invalid arguments passed to EIM



The follow steps can be executed to reproduce the issue:

 

  1. Go to Siebel-root\siebsrvr\bin
  2. Run command :

    srvrmgr /g <gtwy-host> /e <enterprise> /u <user> /p <user-password> /s <siebel-server>

  3. Run the EIM task:

    Srvrmgr> run task for component eim with config=<job-name>.ifb, TraceFLags=1, ErrorFlags=1, SQLFlags=8

  4. EIM job <job-name>ifb is configured as following:

     

 

 

Changes

 It was informed that nothing was changed in the EIM Ifb job, since the last time it was executed.

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!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.