Table Locks

(1) Share

Report

Posted on by Community member

Hello ,

I am trying to add line to Gen. Journal Line (81) in NAV 2017,It takes a lot of time to insert a record .As a result i get locks before is a screenshot of an example of the database

Kindly Advice,

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

KasparsSemjonovs 4,817 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Have You done any modifications to the table 81 ? You can run the Debugger, to see what is causing the issue, but I am most certain it is connected with Your modifications.

Was this reply helpful? Yes No
Community member 15 on at

Like (0)

Report
Copy link

Link copied!

Yes ,I did import the default table 81 and page 39 with no custom code,But I still have the same issue

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,311 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, this is also related to the performance of the server. Have you installed it in a virtual machine? Try reallocating resources, such as memory or the number of CPU cores.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Community member 15 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Thanks Everyone ,I had a workflow custom code that was looping indefinately,,Its Now sorted and inserting into the general jourline line is ok.

Was this reply helpful? Yes No