Skip to main content
Kofax

Fatal database error Cannot delete or change record Since related records exist when publishing Batch Class

7947

QAID # 7947 Published

Question / Problem:

Why am I receiving the error message :

'Fatal database error - Can't delete or change record. Since related records exist in table DELETE statement conflicted with COLUMN REFERENCE constraint 'BatchDocumentPartialRelRelSetupIDForeign'

when I try to change or publish a Batch Class?

Answer / Solution:

This error is generally the result of orphaned records in the Batch Document tables. This can be the result of stuck Batches or Batches that for some reason never completed, and can be fixed by running the Batch Removal Utility.

If the Ascent Capture database has been moved from MSDE to SQL Server, it may be necessary to run several queries to determine the orphaned files and remove them correctly. In this event, please call the Capture group of Kofax Technical Support for assistance.

Applies to:

Product Version Category
CAPTURE 7.0 Administration
CAPTURE 7.0 MSDE/SQL
CAPTURE 7.5 Administration
CAPTURE 7.5 MSDE/SQL
CAPTURE 8.0 Administration
CAPTURE 8.0 MSDE/SQL
CAPTURE 9.0 Administration
CAPTURE 9.0 MSDE/SQL