GETTING SBL-EIM-00107: ODBC (SQL) ERROR WHEN RUNNING EIM JOB BY DUPLICATED RECORDS

(Doc ID 973299.1)

Last updated on JULY 20, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.8.2 SIA [19213] and later
Information in this document applies to any platform.

Symptoms


Comments
--------
Environment
=========

Siebel/Database:V7.8.2.1/Oracle

Steps
=======

1) You have run an EIM job with 1 million records and the job initially failed.

2) Divided the records into 8 batches and started parallel EIM execution.

3) The job fails with the same error

Error message
===========

DBC error 23000: [DataDirect][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_ASSET_U1) violated
This low-level failure caused all processing to halt for the specified interface table. Check the error messages for more information.
< Importing EIM_ASSET 3:07m
Import EIM_ASSET 800008 3:07m
SBL-EIM-00107: ODBC (SQL) error
SBL-EIM-00107: ODBC (SQL) error

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