Skip to main content
Kofax

Several jobs unable to be validated due to "PRIMARY KEY constraint"

Article # 3045327 - Page views: 99

Issue

We have seen several cases of an issue whereby folders are getting locked in KTA.
Upon unlocking them, they are then going to the Validation (IPA) activity to try to process the invoice.

 

However they are unable to validate the invoices as they see a "PRIMARY KEY constraint"

 

Cause

There is an issue with the ForceUnlockItem() method in KTA v7.9 in that it doesn't remove the entries from the CachedDocument table. This issue is also resolved in KTA v7.10.

 

Solution

Please upgrade KTA to version 7.10

For a short term solution, you could go to the Job Details -> Unlock UI to unlock a locked folder/document. 

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
KTA 7.9      

 

References

Add any references to other internal or external articles

 

 

Article # 3045327
  • Was this article helpful?