User lock on table prevents other users from login

laursen

Hi,

We're getting an odd error in our NAV2013 environment. Occasionally a user gets a table locked and this prevents others from login. It is particularly annoying when it happens during the nightshift, and support isn't available.

Server instance: DynamicsNAV70_PROD
Session type: UnknownClient
Session ID: N/A
User: DOMAIN\USER
Type: System.ServiceModel.FaultException`1[[Microsoft.Dynamics.Nav.Types.ServerFault, Microsoft.Dynamics.Nav.Types, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]
Message: The User table cannot be changed because it is locked by another user.  Wait until the user is finished and then try again.
StackTrace:
     at Microsoft.Dynamics.Nav.Service.NSServiceBase.HandleException[T](Object& callOutput, Boolean& terminateConnection, Exception e)
     at Microsoft.Dynamics.Nav.Service.NSServiceBase.ExecuteOperation[T](String operationName, ServiceOperation`1 operation, Connection connection, Boolean revertLanguageChanges)
     at Microsoft.Dynamics.Nav.Service.NSServiceBase.OpenConnection(ConnectionRequest connectionRequest)
Source: Microsoft.Dynamics.Nav.Service
HResult: -2146233087

Any help tips and tricks to solve this issue will be much appreciated!

vremeni4

Hi,

In my experience the only way to resolve this issue is to find the code that is making changes on the User table, and to re-write the code so that user table does not get locked.
In general it is bad practise to have code that modifies records on the User table.

One way to re-create this issue would be to go to page where user is created to to put a CONFIRMATION dialogue before the record is stored. (before insert).
You would start inserting details for a new user, confirmation dialogue would appear but user does not click on anything it waits. This would lock the user table and all other users woudl not be able to login.

I hope this helps.
Thanks.