Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
User lock on table prevents other users from login
laursen
Member Posts: 2
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.
Any help tips and tricks to solve this issue will be much appreciated!
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!
0
Comments
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.