unable to load data to S_ASSET_CON using EIM
Last updated on OCTOBER 13, 2017
Applies to:Siebel Enterprise Integration Manager - Version 7.7.2  and later
Information in this document applies to any platform.
***Checked for relevance on 19-Aug-2014***
The requirement is to associate contacts to existing assets using EIM and the EIM task is failing with following error:
Process [Import Contact_Asset] had all rows on EIM_ASSET for batch 20080918:
Import processing failed for all rows. (severity 3).
1. Asset records already exist in the base table
2. Load following columns in EIM_ASSET:
3. Run EIM task using following ifb parameter:
INSERT ROWS = S_ASSET, FALSE
UPDATE ROWS = S_ASSET, FALSE
4. Run EIM task.
It fails with following error:
“All rows specified for importing in this process failed. Either no rows were specified or all rows could not be imported into the base tables. All rows failed to be processed for this interface table. Either the data in the rows is invalid for import or row specifications did not match any existing base table rows for export, delete or merge.”
The association of contact to Asset is essential for assigning assets to contacts.
Behavior pattern: This behavior exists for certain assets/contact combination and works fine for some other indicating that this is a data issue.
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