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

Business Central/NAV Technical Forum
1

Hello,

I am using Microsoft Dynamics nav 2013. At the time of changing user details or adding new users or even changing their passwords I am getting the following error

“The operation could not complete because a record in the User Property table was locked by another user. Please retry the activity.”

When i check in the SQL server in the sys_dm_trans_lock , i find that both User and User property tables are locked.

Is there anyway i can find what is causing this? or how i can deallocate this lock? or even find what is causing the lock.

Thanks .

2

Encountered the same problem…since I was in a hurry I waited for all users to logout and restarted the service in order to have the tables unlocked.

Would be great to know what can be the cause to fix the problem in a less drastic way.

3

Having the same issue.

Just suddenly appears it seems.

I’m gonna restart the service, but first I would like to know what causes it.

Any new ideas?

Thanks!

4

Hi! So any idea what is the solution to be able to change the password?

Is it to restart the service?

5

@Anna Don’t know what you mean

I solved the problems. There were some inefficient created flowfields which caused severe performance problems. When I solved them by creating the appropiate keys, the message did not appear anymore.

6

Hi Tino, were they customized FlowFields?

7

Yes, they’re customized fortunatly. :slight_smile:

So then it’s much easier to understand where it went wrong.

8

Got it, when I have time I will start investigating from them.