Siebel EIM >  SBL-EIM-00412 Invalid ONLY/IGNORE BASE TABLES specification

SBL-EIM-00412 Invalid ONLY/IGNORE BASE TABLES specification

EIM error SBL-EIM-00413 SBL-EIM-00412

APPLIES TO:

Siebel Enterprise Integration Manager - Version 7.5.3 SIA [16157] to 8.2.2 SIA[22320] [Release V7 to V8]

SYMPTOMS

User has inserted in the Base Table S_INVOICE_ITEM (X_FLG_OMAGGIO, X_FLG_PACCHETTO) and in the EIM table S_INVC_ITEM 2 new field when execute the DTS for import reurn this errror
GenericLog GenericError 1 2004-11-12 19:20:25 Error 413: Column S_INVOICE_ITEM.X_FLG_OMAGGIO doesn't exist!

GenericLog GenericError 1 2004-11-12 19:20:25

GenericLog GenericError 1 2004-11-12 19:20:25 Error 413: Column S_INVOICE_ITEM.X_FLG_PACCHETTO doesn't exist!

GenericLog GenericError 1 2004-11-12 19:20:25

GenericLog GenericError 1 2004-11-12 19:20:25 Error 413: Included column X_FLG_OMAGGIO doesn't exist in S_INVOICE_ITEM!

GenericLog GenericError 1 2004-11-12 19:20:25

GenericLog GenericError 1 2004-11-12 19:20:25 Error 413: Included column X_FLG_PACCHETTO doesn't exist in S_INVOICE_ITEM!

GenericLog GenericError 1 2004-11-12 19:20:25 (compmain.cpp 16(1555) err=100413 sys=0) SBL-EIM-00413: Specifica ONLY/IGNORE BASE COLUMNS non valida.

GenericLog GenericError 1 2004-11-12 19:20:25 (smisched.cpp 17(821) err=100413 sys=0) SBL-EIM-00413: Specifica ONLY/IGNORE BASE COLUMNS non valida.

GenericLog GenericError 1 2004-11-12 19:20:25

GenericLog GenericError 1 2004-11-12 19:20:25 Recorded 1 group of failures and 4 errors.

this is the IFB

[Siebel Interface Manager]
USER NAME = "<Username>"
PASSWORD = "<Password>"
PROCESS = IMPORTA RIGHE FATTURA

[IMPORTA RIGHE FATTURA]
TYPE = SHELL
INCLUDE = DELETE EIM_INVC_ITEM
INCLUDE = IMPORT EIM_INVC_ITEM

[DELETE EIM_INVC_ITEM]
TYPE = DELETE
BATCH = 2401
TABLE = EIM_INVC_ITEM
DELETE EXACT = TRUE
ONLY BASE TABLES = S_INVOICE_ITEM

[IMPORT EIM_INVC_ITEM]
TYPE = IMPORT
BATCH = 2400
TABLE = EIM_INVC_ITEM
ONLY BASE TABLES = S_INVOICE_ITEM, CX_INV_ITEM_REL
NET CHANGE = TRUE
INSERT ROWS = S_INVOICE, FALSE
UPDATE ROWS = S_INVOICE, FALSE
ONLY BASE COLUMNS = S_INVOICE_ITEM.INVOICE_ID, \
S_INVOICE_ITEM.LN_NUM, \
S_INVOICE_ITEM.ITEM_AMT, \
S_I...

===========================================

Reproduced the below error in EIM_0050_52428802.log 8.2.2.2 SIA [23016] ENU

EIMTrace EIMTraceSubEvent 3 0000026051782a1c:0 2013-04-25 20:49:33 4/25/13 20:49 Error SBL-EIM-00412: Base table CX_CATEG_LOCAT not available

CAUSE
Configuration/ Setup

SOLUTION

For the benefit of other users,

After the changes are made to the schema, you need to recreate diccache.dat in siebsrvr\bin directory. Please check the timestamp of this file. If it has an older date, then you need to recreate it. To recreate it, rename the file to a different name, and start EIM task which will start recreating it. When it is being recreated, the filename is diccache.tmp; and after it is fully created, it is diccache.dat. The task will wait (stays in Active or Queued status) until diccache.dat is there.

You may also have eimcolrelcache.dat in siebsrvr\bin directory. The eimcolrelcache.dat is created during delete and merge. Normally it is not used during import or export. So if you don't have it, it is ok. If you do have it, you should recreate it also. To do that, rename it to a different name, and when you start EIM task, choose the parameter named "Extended Parameters" (ExtendedParams) and enter the whole string as the value:

NUM_IFTABLE_LOAD_CUTOFF = 0

This parameter will recreate both diccache.dat and eimcolrelcache.dat.

Customer resolved this error by running the task with "Extended Parameters” set to NUM_IFTABLE_LOAD_CUTOFF = 0 which recreated diccache.dat and eimcolrelcache.dat.