Error 1009153

Message text

Cannot remove row %3 from CK %2 during LOAD cleanup because of RI violation. %1

Item

Value

SQLCode

-1009153

Constant

EMSG_RI_VIOLATION_LOADCLEANUP

SQLState

QSB49

ODBC State

ERROR

Parameter 1

location of the exception

Parameter 2

index name for CK

Parameter 3

row ID that violated RI

Probable cause

The LOAD cleanup operation tried to remove a candidate key with self-referential integrity and the removed value exists in its associated foreign key, so the load was rolled back. Check the message log and row log, fix input rows that violate the integrity constraint, and reload.