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,554

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:

Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Shauna Langley 691 Super User 2024 Season 2 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... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans