EIM Unable to load data error SBL-EIM-00204 (Doc ID 520329.1)

Last updated on AUGUST 03, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3.6 [16186] to 8.2.2 SIA[22320] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.6 [16186]
Database: IBM DB2/UDB 7.2
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: IBM AIX 5L 5.1

This document was previously published as Siebel SR 38-1415226827.
***Checked for relevance on 11-Jul-2014***

Symptoms

SBL-EIM-00204, SBL-GEN-09103

I am getting an error that the configuration file is invalid after upgrade to Siebel 7.5.3.6. This error occured on the TEST server but not the DEV server.

here is the IFB


;Trial for Loading Order Items for Siebel 7.53 DWB
;
;Loading of orders is done with srvrmgr
;password in this file is invalid and
;overidden by parms passed to srvrmgr

[Siebel Interface Manager]
      USER NAME = "SADMIN"
      PASSWORD = "***"
      PROCESS = Import Order Items

[Import Order Items]
      TYPE = IMPORT
      BATCH = 1
      TABLE = EIM_ORDER_ITEM
      UPDATE STATISTICS = FALSE

      FIXED COLUMN = ALW_PART_SHIP_FLG, "N"
      FIXED COLUMN = ORDER_REV_NUM, 1
      FIXED COLUMN = BILLABLE_FLG, "Y"
      FIXED COLUMN = LOANER_FLG, "N"
      FIXED COLUMN = ROLLUP_FLG, "N"
      FIXED COLUMN = WRNTY_RCVR_FLG, "N"
      FIXED COLUMN = AUTO_RECV_FLG, "Y"
      FIXED COLUMN = DISCNT_SRC_CD, "Manual"
      FIXED COLUMN = EXCL_PRICING_FLG, "N"
      FIXED COLUMN = HOLD_FLG, "N"
      FIXED COLUMN = LATE_FLG, "N"
      FIXED COLUMN = PROCESSED_FLG, "N"
      FIXED COLUMN = PROMO_ITEM_FLG, "N"
      FIXED COLUMN = ROLLUP_FLG, "N"
      FIXED COLUMN = SHIP_COMPLETE_FLG, "N"
      FIXED COLUMN = SHIP_TOGETHER_FLG, "N"
      FIXED COLUMN = SINGLE_SRC_FLG, "N"

      ONLY BASE TABLES = S_ORDER_ITEM
      ONLY BASE COLUMNS = ORDER_ID, \
                          LN_NUM, \
                          PAR_ORDER_ITEM_ID, \
                          PROD_ID, \
                          QTY_REQ, \
                          DESC_TEXT, \
                          UNIT_PRI, \
                          X_TOTAL_BILLED, \
                          X_START_DATE, \
                          X_ACCESS_LEVEL, \
                          X_ISSN, \
                          X_PUBLISHER, \
                          X_END_DT

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