Microsoft Dynamics GP (Archived)

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

(0) Share

Report

Posted on by Nizamudeen

790

Iam Getting this problem when i post POP Invoice Entry Transaction.

please help me out this issue its great appreciated.

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Sort by

Suggested answer

sandipdjadhav 18,331 on at

Like (0)

Report
Copy link

Link copied!

Nizam,

Take good backup of Dynamics and Production db and try this solution : https://community.dynamics.com/gp/f/32/t/114755.aspx

Let me know how it goes.

Thanks

Sandip

Was this reply helpful? Yes No
Suggested answer

sandipdjadhav 18,331 on at

Like (0)

Report
Copy link

Link copied!

Try this before drop and create procedure. :

clear the ACTIVITY, SY00800 and SY00801 tables in the DYNAMICS database and

the DEX_LOCK and DEX_SESSION tables in the TEMPDB database

Was this reply helpful? Yes No
Nizamudeen 790 on at

Like (0)

Report
Copy link

Link copied!

Hi Sandip Thank you for Your Quick Response.

I tried This Solution but i haven't get that output.still iam unable to post the invoice transaction.

Was this reply helpful? Yes No
Suggested answer

John Lowther 5,122 on at

Like (0)

Report
Copy link

Link copied!

Hi Nizamudeen,

I am going to agree with Sandip,

Try clearing the Activity, SY00800, and SY00801 tables in the Dynamics database

and clear the DEX_LOCK and DEX_Session tables in the TEMP database.

If you still have the problem, then make a backup of all your databases and try the solution located here ==> community.dynamics.com/.../114755.aspx

Let me know how it goes,

Was this reply helpful? Yes No
Suggested answer

John Lowther 5,122 on at

Like (0)

Report
Copy link

Link copied!

Hey Nizamudeen,

Seems like our post overlapped each other ;)

Question: Did you try Try clearing the Activity, SY00800, and SY00801 tables in the Dynamics database and clear the DEX_LOCK and DEX_Session tables in the TEMP database first?

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

Run Check Links for the purchasing tables shown below and try again.

If you again facing the error then follow below link to resolve your issue.

http://support.microsoft.com/kb/931648

Note: This link is used for Sale Transactions and also help for Purchasing as well.

Hope this helps!!!

Was this reply helpful? Yes No
Nizamudeen 790 on at

Like (0)

Report
Copy link

Link copied!

Thanks to All For Giving Quickly Response...I will Try to Run Check Links And i will Let You Know..

Was this reply helpful? Yes No
Suggested answer

John Lowther 5,122 on at

Like (0)

Report
Copy link

Link copied!

I also found this post in the forum that may help.

community.dynamics.com/.../114755.aspx

Was this reply helpful? Yes No
Nizamudeen 790 on at

Like (0)

Report
Copy link

Link copied!

Same Error is Accruing how to resolve this please help me.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

Have you tried to 'Drop Auto Procedures' and 'Create Auto Procedures' for the Posting Definition Master in SQL Maintenance?

Was this reply helpful? Yes No