User Table locked all the time

Mathes · 2014-11-26

Hi,

we need to change a few Windows Security ID's for NAV Users due to changes in our AD. I tried since yesterday to change or delete the "old" user but I always get the message "The operation could not complete because a record in the User table was locked by another user".

Has anyone experienced the same problem and/or a solution for this?

Greetings

Mathes

mohana_cse06 · 2014-11-26

Are you the only one in Database?

Please restart the service and try..

Mathes · 2014-11-26

Hi, unfortunately not, it's a live environment and there are a lot of users only. Is there no other way to solve this?

regards

mohana_cse06 · 2014-11-26

Do you have test environment?

Please try to replicate there and try after restarting.

or restore the latest backup of live and test, if it works then you can do it in non productive ours.
if it is a 24 hrs service then you can send a notification to all users for a down time of 5 min

Mathes · 2014-11-26

Hi, after stopping and starting the services it worked. Thank you very much for your help.

regards

mathes

Mathes · 2014-11-28

A few more Information for that issue:

it seems the NAS-Service is blocking the user table, after stopping only the nas service I was today able to change the user table.

regards

Mathes

Howdy, Stranger!

Quick Links

Categories

User Table locked all the time

Answers