Siebel EIM >  SBL-EIM-00411: SQL WHERE clause expression invalid.

SBL-EIM-00411: SQL WHERE clause expression invalid

APPLIES TO:

Error Message Area:Enterprise Integration Manager - EIMVersion:Siebel 7.8

PURPOSE

This document is intended to provide cause and corrective action information about Siebel Error Message SBL-EIM-00411: SQL WHERE clause expression invalid.

Explanation

The value was expected to be an SQL where clause fragment but was unable to be processed as such.
Corrective ActionMake sure that the value is a parenthesized SQL where clause fragment.

Bug 16043570 : EIM46.SQL,EIM47.SQL,EIM48.SQL FILES ARE EMPTY AFTER APPLYING 8.1.1.8.
 Bug Attributes Type B - Defect Fixed in Product Version 8.1.1.11FPSeverity 2 - Severe Loss of Service Product Version 8.1.1.8Status 90 - Closed, Verified by Filer Platform 912 - Microsoft Windows (32-bit)Created 26-Dec-2012 Platform Version NO DATAUpdated 04-Apr-2013 Base Bug N/ADatabase Version 11.2.0.3 Affects Platforms GenericProduct Source Oracle Knowledge, Patches and Bugs related to this bug

Related Products Line Siebel Family Customer Relationship ManagementArea CRM - Enterprise Edition

Product 9019 - Siebel Data Model

Hdr: 16043570 11.2.0.3 EIM 8.1.1.8 EIM_SQL_TMPL PRODID-9019 PORTID-912Abstract: EIM46.SQL,EIM47.SQL,EIM48.SQL FILES ARE EMPTY AFTER APPLYING 8.1.1.8. *** 12/25/12 05:38 pm ***      BUG TYPE CHOSEN  ===============  Code    WHAT IS THE DESIRED BEHAVIOR?  =============================  eim46.sql,eim47.sql,eim48.sql files which are installed on 8.1.1.8 or  8.1.1.9 have enough settings so that we can import with MISC SQL parameter  successfully.    WHAT IS THE ACTUAL OR UNEXPECTED BEHAVIOR?  ==========================================  eim46.sql,eim47.sql,eim48.sql files which are installed on 8.1.1.8 or  8.1.1.9 are empty.  Due to this issue, SBL-EIM-00411 happened as follows when importing EIM  using MISC SQL parameter.    INTERNAL REPRO  ==============  Yes    REPRO_STEPS  ===========  - cd <SiebelServerRoot>/sqltempl  - ls -l eim*.sql    ERRORS  ======  EIM log when importing with MISC SQL parameter:    EIMTrace EIMTraceSubEvent 3 0000000a50c018ec:0 2012-12-06 22:10:03 12/6/12  22:10 Error SBL-EIM-00411: EXPR_S_CONTACT_PR_HELD_POSTN_ID is not  EIMTrace EIMTraceSubEvent 3 0000000a50c018ec:0 2012-12-06 22:10:03 defined  in eim48.sql!