Siebel EIM >  EIM_INVOICE: Error 413: The column that determines the type of the File Attachment is not included

EIM_INVOICE: Error 413: The column that determines the type of the File Attachment is not included

APPLIES TO:
Siebel Enterprise Integration Manager - Version 7.5.2.216 SIA [16084] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.2.216 [16084] Life Sci
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: Microsoft Windows 2000 Advanced Server SP 3

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

SYMPTOMS
SBL-EIM-00413

Configured EIM to upload data to S_INVOICE using EIM_INVOICE. However, all data can't upload.

CAUSE
Bug

SOLUTION

The customer was using EIM_INVOICE to update S_INVOICE. They used the following ifb:

[Siebel Interface Manager]
USERNAME = "SADMIN"
PASSWORD = "SADMIN"
PROCESS = Import EIM_INVOICE

[Import EIM_INVOICE]
TYPE = IMPORT
BATCH = 1000
TABLE = EIM_INVOICE
ONLY BASE TABLES = S_INVOICE
UPDATE ROWS = S_INVOICE, TRUE
FIXED COLUMN = INVC_INVC_TYPE_CD, "Default"
FIXED COLUMN = INVC_APPR_FLG, "Y"
FIXED COLUMN = INVC_CUSTSIGNOFFFL, "Y"
FIXED COLUMN = INVC_DELINQUENTFLG, "Y"
FIXED COLUMN = INVC_DOCNUMGNRTDFL, "Y"
ONLY BASE COLUMNS = S_INVOICE.INVC_NUM \
, S_INVOICE.INVC_TYPE_CD \
, S_INVOICE.APPR_FLG \
, S_INVOICE.CUST_SIGN_OFF_FLG \
, S_INVOICE.DELINQUENT_FLG \
, S_INVOICE.DOCNUM_GNRTD_FLG \
, S_INVOICE.ACCNT_ID \
, S_INVOICE.INVC_DT

They received the following errors:

“Error 413: The column that determines the type of the File Attachment is not included in the list of active columns. Without it, file attachments cannot be imported.”

“EIM-00413: Invalid ONLY/IGNORE BASE COLUMNS specification.”

The behavior is that of Change Request 12-4T6PMU: EIM_INVOICE and ONLY BASE COLUMNS need to reference cols: FILE_EXT, FILE_NAME, FILE_SRC_TYPE. Please review the following reference for further details:
Service Request #: 38-290507154, Abstract: EIM IMPORT OF DEBT INFORMATION INTO EIM_INVOICE

The errors were resolved by adding the following in the ONLY BASE COLUMNS parameter of the .ifb file:

FILE_EXT, FILE_NAME, FILE_SRC_TYPE