When importing Account or Contact data using EIM, the batch fails with the following error: EIM-00107: ODBC (SQL) error.
The log file displays an error message similar to the following error shown below for an Oracle database: ODBC error 23000: [MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-00001: unique constraint (SIEBEL.S_CONTACT_U1) violated
ODBC error 23000: [MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-00001: unique constraint (SIEBEL.S_ORG_EXT_U1) violated
|
This unique constraint error usually occurs due to inconsistent data in the base tables or incorrect data populated in the interface tables. The inconsistent data may result when two different server tasks, such as Siebel EAI processes and an EIM process, are run at the same time to import the same data. For an example of this, see Example of Troubleshooting the Unique Constraint Error when Importing Accounts or Contacts. |
See Example of Troubleshooting the Unique Constraint Error when Importing Accounts or Contacts. |