a get/change operation on table 'Batch_Headers' failed. A record was already locked

Software Engineer
Software Engineer used Ask the Experts™
on
Hi:

For Microsoft Dynamics GP, has anyone ever found a definitive solution to the following error:

a get/change operation on table 'Batch_Headers' failed. A record was already locked

Thanks!

John
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hardware Tester and Debugger
Commented:
Hi there! :)

First, create backup of Dynamics and Production db. After that, clear the DEX_LOCK and DEX_Session tables in the TEMP database. If it still doesn't work, try this solution specified below.

Reference: https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/136027/a-get-change-operation-on-table-batch_headers-failed-a-record-was-already-locked

At the end, in SQL maintenance, 'Drop Auto Procedures' and 'Create Auto Procedures' for the Posting Definition Master solved the issue.

Author

Commented:
Thank you, for this, Noah!  Once the client is out of the app, I'll try these steps and let you know!

Thanks, again, for everything!

John

Author

Commented:
This worked!  Thank you, Noah!

John
NoahHardware Tester and Debugger

Commented:
You're welcome! Glad I was of help :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial