Monday, November 30, 2009

Different IF_ROW_STAT errors for Siebel EIM Import Process


Depending upon the type of failure, the IF_ROW_STAT column of the interface table records are set with different kinds of values.
AMBIGUOUS: Two rows in the base table have same user key but different conflict IDs.
DUP_RECORD_EXISTS: One or more rows that exist in the interface table exactly matches with base table record.
DUP_RECORD_IN_EIM_TBL: One or more rows have the same user key of another row within the interface table.
FOREIGN_KEY: When a required foreign key column in the target table could not be resolved.
IMPORTED: The rows got successfully imported for both target and not-target base tables.
IMPORT_REJECTED: A user-specified filter query failed for this row. Rows which were eliminated as a result of FILTER_QUERY.
IN_PROGRESS: This value is set in the first step, the initialization step, of the import process.
NOT_ALLOWED: This value is set when a particular operation is not permitted.
PARTIALLY_IMPORTED: The rows got successfully imported for target table but failed for one or more non-target tables.
PICKLIST_VALUES: Required bounded pick list value could not be resolved.
REQUIRED_COLS: One or more required columns were found NULL.
ROLLBACK: When EIM encounters an error during a roll back operation, this value is set.
SQL_ERROR: This value is set, when EIM fails importing, when the transaction logging is enabled.


---------------------END-----------------------------

No comments:

Post a Comment