Siebel EIM >  SBL-EIM-00413 Invalid ONLY/IGNORE BASE COLUMNS specification

SBL-EIM-00413 Invalid ONLY/IGNORE BASE COLUMNS specification

Error SBL-EIM-00413 When Running An Update EIM Job (

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

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

CAUSE
The issue is caused by the following setup:
In the IFB file the customer hasn't specified all the required fields and user key columns in the "ONLY BASE COLUMNS" parameter.

When the "ONLY BASE COLUMNS " parameter is used in the IFB file it should contain first all user key columns and required columns followed by the columns you wish to update.

This statement is from EIM Administration Guide:
ONLY BASE COLUMNS

Specifies and restricts base table columns for the import process. Use commas to separate column names, which can be qualified with base table names. Include all user key columns and required columns.

SOLUTION
In this case the required columns are from S_PARTY as follows : S_PARTY.PARTY_TYPE_CD and S_PARTY.PARTY_UID and the user keys are from S_CONTACT : S_CONTACT.PERSON_UID, S_CONTACT.BU_ID.