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
|