Skip to main content

Notifications

Announcements

No record found.

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

Table Locks

Posted on by 15
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,
 
  • Verified answer
    Community member Profile Picture
    Community member 15 on at
    Table Locks
    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.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    Table Locks
    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
  • Community member Profile Picture
    Community member 15 on at
    Table Locks
    Yes ,I did import the default table 81 and page 39 with no custom code,But I still have the same issue
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    Table Locks
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans