You’re offline. This is a read only version of the page.
655
Our controller created a batch which had a status of MARKED.
After I changed the status of this batch to UNAPPROVED, he received the following message when he attempted to delete the batch:
A remove operation on table 'PM_Key_MSTR' failed because the record couldn't be locked.
I saw a previous article that suggests
1) run Check Links on the payables logical file then
2) run reconcile on the purchasing documents.
When I tried to run check links, I received the following message:
[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PKPM00400'. Cannot insert duplicate key in object 'dbo.PM00400'. The duplicate key value is (1,
01T86237TS430324M ).
I have run a select statement on the PM00400 and don't see the values (1,
01T86237TS430324M ) from the above message listed in this table.
I see transactions with these values in the PM10000 table which lists these values as the payment number.
Do you have any ideas on what needs to be done to resolve the error so the batch can be deleted?
*This post is locked for comments
was able to delete the batch.
It sounds like you may need to recreate the PM Keys table (PM00400). It's essentially an index of every trx in Payables and from time to time something corrupts it and rebuilding it is necessary. I did a quick search to find the link for you but can't. If you are unable to find it, let me know and I'll do another search, there should be a KB article on this process that you can follow and try.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (