Job Queue in Error State - Locking Issue

(1) Share

Report

Posted on by tanya07

1,636

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,

Categories:

Dynamics 365 Business Central

All responses (1)

Answers (0)

Suggested answer

Shauna Langley 848 Super User 2025 Season 1 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