• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Business Central
  • Dynamics NAV
    • NAV 2018
    • NAV 2017
    • NAV 2016
    • NAV 2013
  • Others
    • About
    • Privacy Policy
    • Disclaimer
    • Contact Us

Navision Planet

This Blog is intended to help Microsoft Dynamics NAV / Business Central ERP developers as well as users. If you just go through these blogs you will understand what I have told is correct. The Blog will continuously get update with latest news. This Blog is handled by a group of Microsoft Certified Partners as well as Business Solution Specialists in Microsoft Dynamics NAV and Dynamics 365 Business Central. Feel free to mail us for any doubts.

  • LS Retail
  • Help Topics
    • Finance Module
    • Manufacturing Module
    • Warehouse Module
    • Administration
  • Navision Developer
  • GST
  • D365 Business Central
  • CU Update
    • Download Business Central

How to Find which user is locking a table?

How to Find which user is locking a table?

When you want to make a changes or post something and the following messeage come out:

“table is Locked by another user”


Orginal error message will came on Purchase Line table as follows

The operation could not complete because a record in the Purchase Line table was locked by another user. Please retry the activity.

Navision document posting error message

This means that another user is also modifying data in the same table. Navision has locked the table for the user to modify so that no other users can modify the same data at the same time.

Any other user who wants to modify the same data must wait until the user who locked the table to finish his / her changes first. Once the user has finish modifying the data, Navision will release the table lock for other users to use.

All the 2 tier architecture versions of Microsoft Dynamics NAV ( Business Solution 3.0 to 5.0 versions ) facing this error. 

Navision allow you to check which user is locking other users via following steps.

Dynamics NAV Sessions with locking details
Dynamics NAV Sessions with locking details

Find Locking User Details

  1. Go to File–>Database–>Information.
  2. Select the Sessions tab.
  3. Drill down to the current sessions.
  4. Check on the Blocking user id column to find out who is locking other people.

Please note locking user session will show at the time of Locking initialized only. So if you are checking the details after some time then you will not receive those details. Also note that you will get the visibility of locking session when you have sufficient permission set assigned on SQL server. That means administration permission required to find the user creating locking.

You overcome this issue by scheduling posting users different departments.

For example, Tell Purchase invoice team to post the transaction between 10 AM to 2 PM for one set of user. And other set of users to assign other time etc. Make sure 2 users will not post the same transaction at same moment.

You can also kill the session of other user to over come this. For doing this select the user session and press delete button.  Then on popup message select yes to kill the user session.

Strongly recommended,  all to get over this by upgrade your ERP solution to latest versions.

If you are still having issue then do raise one comment over here in Navision Planet. We are Happy to Help U.

Reader Interactions

Comments

  1. Satinder says

    February 7, 2021 at 9:22 pm

    I m facing same problem in requisition line and item journal line,
    Pls give solution

    Reply
    • JUBEL THOMAS says

      July 23, 2021 at 4:18 pm

      Is this issue still exists?

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Subscribe

  • Email
  • Facebook
  • Twitter

Our Topics

Administration Analysis Reports Business Central Developer Toolkit Docker Dynamics NAV Beta Download Dynamics NAV Release Error Message Finance Module GST Human Resource Login Error LS Retail LS Retail 2013 Manufacturing Module Microsoft Certified Trainers (MCTs) Microsoft Dynamics Business Central Microsoft Dynamics NAV 2009 Microsoft Dynamics NAV 2013 Microsoft Dynamics NAV 2015 Microsoft Dynamics NAV 2017 Microsoft Dynamics NAV 2018 MSDyn365BC NAV 2016 Navision Certification Navision Developer Navision Introduction Navision Modules Navision Retail Navision Tips And Tricks Powershell Purchase Order Sales Module SQL Server Useful Sites Visual Studio Code Warehouse Module

Footer

Recent Post

  • Business Central Complete Version List and Direct Download
  • You do not have access to Microsoft Dynamics NAV or D 365 Business Central Error
  • Dynamics NAV Versions List

Search

Contact : support@navisionplanet.com for Microsoft Dynamics NAV (Navision ) and LS Retail Development or Functional support for any modules

 

Editors News Letter


New Microsoft Dynamics NAV Technical Blog opened the Navision Planet Team

MIBUTECH

https://www.mibutech.blogspot.com

Copyright © 2023 Navision Planet