Skip to main content

Error publishing batch, Fatal database error - Can't delete or change record

Article # 3044541 - Page views: 81


Can not Publish Batch Class:

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



This error is caused by the orphaned records in the Batch Document tables



To resolve the problem is to run the following SQL query directly on the Kofax Capture Database by using KI easyQuery2022.1 Tool

DELETE FROM BatchDocumentPartialRel
WHERE BatchID NOT IN (SELECT ExternalBatchID FROM BatchCatalog)

NOTE: It is strongly recommended to back up the database prior to running the SQL query.


Level of Complexity 



Applies to  

Product Version Build Environment Hardware
Kofax Capture all Versions      



Add any references to other internal or external articles



Article # 3044541
  • Was this article helpful?