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
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.
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.
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.
facing same trouble. still not work, already tried this way.
Dynamics GP 2013. any idea?
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.
If you still facing the issue, try to restart your SQL server services for the GP and try again.
Hope this helps!!!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
