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

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  

References

Add any references to other internal or external articles