News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Job Queue in Error Sta...

Small and medium business | Business Central, N...

Suggested answer

Job Queue in Error State - Locking Issue

(1) Share

Report

Report

Posted on by tanya07

1,535

Hello Experts!!

We can't save your changes right now, because a record in table 'G/L Entry' is being updated in a transaction done by another session. You'll have to wait until the other transaction has completed, which may take a while. Please try again later.

I am using Post Inventory to G/L report for my Job Queues. What could be the reason of the job queue going in error state for the mentioned error.

I am using Auto-Cost Adjustment always ON under inventory setup.

Thanks!

Regards,

TK

Categories:

Inventory and warehouse management

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Shauna Langley 608 Moderator on at

Like (0)

Report

Job Queue in Error State - Locking Issue

Hi,

There could be a multitude of reasons for this as any user could be running a process that causes this. If you search for database locks as below

this can show you who is causing the lock.

At least this will give you more information on what is causing the issue.

If that doesn't work then you may need to look into the telemetry which again can provide more information.

https://www.linkedin.com/posts/yzhums_telemetry-faq-frequently-asked-questions-activity-7067634635286999040-Uwov/

https://www.linkedin.com/posts/yzhums_whats-new-in-dynamics-365-business-central-activity-7105872498574966784-hLjM/

Some of these links might help.

Thanks,

Shauna

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 283,860 Test role Public

#2

Ludwig Reinhard 229,831 Microsoft Employee

#3

Martin Dráb 225,155 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans