Background documentation-530: Referential integrity violated Locate this document in the navigation structure

 

Explanation

Possible reasons:

  1. An INSERT or UPDATE statement issued on a table that is the referencing table in a referential CONSTRAINT definition produces a row that is not a matching row of the CONSTRAINT definition.

  2. Deleting rows from a referenced table in a referential CONSTRAINT definition using ON DELETE RESTRICT in the DELETE rule produces a matching row.

User Response
  1. Display the definition of the referential CONSTRAINT definition using a QUERY statement issued on the DOMAIN.FOREIGNKEYCOLUMNS system table. Change the INSERT or UPDATE statement according to this definition.

  2. Use a suitable QUERY statement to find out which row of the referencing table prevents the required rows from being deleted from the referenced table.