Constraint violation errors while loading data into EIM tables

Invalid batch number, Row ID, or LOV value

Error while updating or deleting data from EIM tables

ERROR_EIM_TABLE. Contains the name of the EIM table into which the PowerCenter Integration Service is loading data.

ERROR_ROW_ID. Contains the row ID of the row for which the error occurred.

ERROR_BATCH_NUM. Contains the batch number of the row for which the error occurred.

ERROR_MSG. Contains detailed error message.

If a database error occurs, the error message appears in the following format:

If a non-database error occurs, the error message does not contain the SQLState and NativeErrorCode. The error message appears in the following format:

If multiple errors occur for a row while loading data into the EIM table, the PowerCenter Integration Service uses a new line character as a delimiter to concatenate the error messages in the ERROR_MSG port.