Siebel EIM >  SBL-EIM-00452 Match expression invalid for IF table

SBL-EIM-00452 Match expression invalid for IF table

APPLIES TO:
Siebel Enterprise Integration Manager - Version 7.5.2.100 [15252] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.2.100 [15252]
Database: Oracle 9.0.1.3
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: HP-UX 11i

SYMPTOMS
We are trying to do an EXPORT Process. The error message is "Error 452: Only Siebel Extension child table name can be specified in EXPORT" & EIM-00452: Match expression invalid for IF table.

I tried without S_PARTY, the err msg is Must include target table S_PARTY for EIM_CONTACT.

My IFB is
[Siebel Interface Manager]
USER NAME = "sadmin"
PASSWORD = "sadmin"
PROCESS = Export Contacts

[Export Contacts]
TYPE = EXPORT
BATCH = 1
TABLE = EIM_CONTACT
ONLY BASE TABLES = S_PARTY,S_CONTACT
EXPORT MATCHES = SIEBEL.S_CONTACT, (CUST_STAT_CD = 'Marked For Deletion')

Can you help us on this matter. Our work is on hold because of this. Please see the attached log files.

CAUSE
Configuration/ Setup

SOLUTION
Message 1
The customer wanted to export contact records using eim.

They received an error message during the export process "Error 452: Only Siebel Extension child table name can be specified in EXPORT" & EIM-00452: Match expression invalid for IF table.

They had the following ifb file for the export process

[Siebel Interface Manager]
USER NAME = "sadmin"
PASSWORD = "sadmin"
PROCESS = Export Contacts

[Export Contacts]
TYPE = EXPORT
BATCH = 1
TABLE = EIM_CONTACT
ONLY BASE TABLES = S_PARTY,S_CONTACT
EXPORT MATCHES = SIEBEL.S_CONTACT, (CUST_STAT_CD = 'Marked For Deletion')

- Resolution

We suggested that we do not require to use the TableOwner.TableName in the export matches criteria.

However with the criteria EXPORT MATCHES = S_CONTACT, (EMP_FLG = 'N') in the ifb file the following error was shown in the eim log
....
DELETE FROM SIEBEL.EIM_CONTACT
WHERE (IF_ROW_BATCH_NUM = 1)GenericLog GenericError 1 2004-09-14 14:00:59 [DataDirect][ODBC

Oracle driver][Oracle]ORA-00942: table or view does not exist
.......

The customer logged into the database using the sadmin credentials, similar to eim process they received an error ORA-00942: table or view does not exist.

The behavior was resolved when the DBA granted permission to the EIM_CONTACT table for the SADMIN login