Tuesday, 16 August 2016

A save operation on table PM_Transaction_Open has created a duplicate key

So you post a batch and it gets stuck in batch recovery. Try to clear it and it cannot come out. When you click 'more details' on the error it tells you about the save operation creating a duplicate key.

What to do?

Backup company and system database and then run checklinks on the Payables Logical and Vendor tables. Run this twice and the keys will be recreated, you may have to delete the batch after if the transaction was posted and resulted in an extra record.

No comments:

Post a Comment