EIM error SBL-EIM-00413 SBL-EIM-00412 (Doc ID 530991.1)

Last updated on MARCH 09, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3 SIA [16157] to 8.2.2 SIA[22320] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3 [16157] ITA Cons Sec
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Microsoft Windows 2000 Server SP 4

This document was previously published as Siebel SR 38-1610944421.


Symptoms

SBL-EIM-00413

I have insert 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 my IFB

[Siebel Interface Manager]
      USER NAME = "SADMIN"
      PASSWORD = "AgenteSmith"
      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
EIMTrace EIMTraceSubEvent 3 0000026051782a1c:0 2013-04-25 20:49:33 through EIM_CTLG_CAT

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