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

Last updated on MARCH 30, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.2.216 [16084] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.2.216 [16084]
Database: Oracle 9.2.0.2
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***
""CHECKED FOR RELEVANCE ON 26-OCT-2015""

Symptoms

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)                    ...

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