Skip to main content
Kofax

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

Article # 3044541 - Page views: 81

Issue

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"".

 

Cause

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

 

Solution

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 

Moderate

 

Applies to  

Product Version Build Environment Hardware
Kofax Capture all Versions      

 

References

Add any references to other internal or external articles

 

 

Article # 3044541
  • Was this article helpful?