Hi
When i try to edit any user security in GP 2010 i got the following msg:
This user is bening edit by another user
*This post is locked for comments
Hi
When i try to edit any user security in GP 2010 i got the following msg:
This user is bening edit by another user
*This post is locked for comments
Have you tried the below script against your GP SQL server Instance?
Before running these code, make sure all the users logged off from GP.
DELETE FROM DYNAMICS..ACTIVITY
DELETE FROM DYNAMICS..SY00800
DELETE FROM DYNAMICS..SY00801
DELETE FROM tempdb..DEX_LOCK
DELETE FROM tempdb..DEX_SESSION
If you still facing the issue, try to restart your SQL server services for the GP and try again.
Hope this helps!!!
facing same trouble. still not work, already tried this way.
Dynamics GP 2013. any idea?
Hi,
i am also facing the same issue GP10 sp3 which is upgraded from GP8 SP5. i have checked those tables but there is no session. it is empty.
Ali
Have everyone log out of GP and execute the following scripts on SQL Server.
DELETE FROM DYNAMICS..ACTIVITY
DELETE FROM DYNAMICS..SY00800
DELETE FROM DYNAMICS..SY00801
DELETE FROM tempdb..DEX_LOCK
DELETE FROM tempdb..DEX_SESSION
Let us know if you need further assistance.
Get everyone to log out of GP. Then delete the activity table (run the following query in SQL - Delete Dynamics..ACTIVITY).
If this doesn't sort the issue, post again.
Ian.
André Arnaud de Cal...
292,494
Super User 2025 Season 1
Martin Dráb
231,309
Most Valuable Professional
nmaenpaa
101,156