My Oracle Support Banner

EIM Contact does not update PR_OU_ADDR_ID error SBL-EIM-00425 (Doc ID 491705.1)

Last updated on NOVEMBER 27, 2019

Applies to:

Siebel Enterprise Integration Manager - Version [16084] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: [16084]
Database: Oracle
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: Sun Solaris 5.6

This document was previously published as Siebel SR 38-1202064501.
***Checked for relevance on 14-May-2014***


I’m trying to resolve pr_ou_addr_id for our contact records. I have attached my import and export ifb files. I have no problem exporting the records, but when I try to import them back I get the following error:

Process [Contacts] had all rows fail

EIM_CONTACT2 for batch 1976:
Import processing failed for all rows. (severity 3)

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.

(compmain.cpp 16(1554) err=100425 sys=0) EIM-00425: All rows in interface table failed.
(smisched.cpp 17(820) err=100425 sys=0) EIM-00425: All rows in interface table failed.

I have been using the following sql to resolve bu id’s

update EIM_CONTACT2 set                                                                                                                                                                            
CHRC_CALL_LST_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CHRC_CALL_LST_BU)                                                                                                  
,CONPRD_ACCNT_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CONPRD_ACCNT_BU)                                                                                                  
,CON_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CON_BU)                                                                                                                      
,CON_CAMP_SRC_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CON_CAMP_SRC_BU)                                                                                                  
,CON_LSTCMPWVSRC_BI = (select min(OI.ROW_ID) from S_BU OI where OI.NAME = CON_LSTCMPWVSRC_BU)                    ...


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

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