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.