Error SBL-EIM-00413 When Running An Update EIM Job (Doc ID 2058130.1)

Last updated on MARCH 27, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 8.1.1.5 [21229] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.5 [21229] version, EIM

Error SBL-EIM-00413 when running an update EIM job

I have a problem when I'm trying to run EIM job.

MDM:batch $ Run.sh QC_Miseajour_Contact rmdm
RUN TASK FOR COMPONENT EIM WITH ExtendedParams="BATCH=5555555555", CONFIG=/local/siebel/rmdm/batch/other/QC_Miseajour_Contact/IFB/UPDATE_CONTACT.ifb, ERRORFLAGS=1, TRACEFLAGS=8, SQLFLAGS=8
SBL-ADM-60070: Error reported on server 'RMDM' follows:
SBL-SVR-01042: Internal: Communication protocol error while instantiating new task SBL-EIM-00413: Invalid ONLY/IGNORE BASE COLUMNS specification.
SBL-EIM-00413: Invalid ONLY/IGNORE BASE COLUMNS specification.

This is the IFB file:

[Siebel Interface Manager]

PROCESS = CONTATCS_LOAD

[CONTATCS_LOAD]
TYPE = SHELL
INCLUDE = UPDATE_CONTACTS

[UPDATE_CONTACTS]
TYPE = IMPORT
BATCH = 5555555555
TABLE = EIM_CONTACT
ONLY BASE TABLES = S_CONTACT
UPDATE ROWS = TRUE
INSERT ROWS = FALSE
ONLY BASE COLUMNS = S_CONTACT.CUST_STAT_CD
ROLLBACK ON ERROR = TRUE



ERROR
-----------------------
SBL-EIM-00413: Invalid ONLY/IGNORE BASE COLUMNS specification.
Error SBL-EIM-00412: Must include target table S_PARTY for EIM_CONTACT
Error SBL-EIM-00413: Must include user key column S_CONTACT.PERSON_UID.
Error SBL-EIM-00413: Must include user key column S_CONTACT.BU_ID



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add only one column in the "ONLY BASE COLUMNS" parameter
2. run the job


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update Contacts using EIM

Changes

 The customer has added "ONLY BASE COLUMNS " parameter in the IFB file.

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