Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP 2010 User ...
Microsoft Dynamics GP (Archived)

Dynamics GP 2010 User Security Setup: This user ID is being edited by another user.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Dear All:

We are facing this issue an information message, after selecting the User ID .

Product: Dynamics GP 2010

0020.Capture.PNG

Thanks 

Tauqir

*This post is locked for comments

  • Sureshn07 Profile Picture
    Sureshn07 700 on at
    RE: Dynamics GP 2010 User Security Setup: This user ID is being edited by another user.

    Please check the ODBC for connecting to GP Database from GP Application. Make sure the ODBC is created using ODBC 32 Bit. I was also facing the same issue, and after troubleshooting found that ODBC was the culprit.

  • Dedi Hermawan Profile Picture
    Dedi Hermawan 295 on at
    RE: Dynamics GP 2010 User Security Setup: This user ID is being edited by another user.

    Hello Tauqir Abbas :D

    I have same issue like you

    I already use SQL Script :

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    But not solved,

    Then i restart my SQL Server but not solved too

    But finally i have the solution for this issue

    i check my SQL Server Collation it different with database backup

    So i need Install SQL Server with the same collation with Database Backup

    and i Works now nothing problem again

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP 2010 User Security Setup: This user ID is being edited by another user.

    Dear Sir/Madam:

    We tried these SQL queries, still facing the same issue.

    Thanks

    Tauqir

  • Verified answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Dynamics GP 2010 User Security Setup: This user ID is being edited by another user.

    Hi

    Looks like a locked record somewhere.  I would suggest once all users are logged out, clearing the Activity and temp files in SQL Server as a first port of call.

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    Then log back in and try again.

    Cheers

    Heather

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans