Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Locked User

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I’m having a problem with this error message (below). Is there a table I could clear up for this? I’ve clear the activity, sy00800 and delete tempdb.dex_lock and session tables. Usually it would allow me back in after 30 minutes, now it’s been 2 days.

Error Message: “Your User ID has been locked out of the accounting system…”

GP 9, Omini Tools

Thanks for any help.

Hung Tran

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Locked User

    I figure it out, it was the Omni Tool security.

    Thanks for your help.

    Hung

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Locked User

    I'm still gettting that message. Do you think this is a GP error message? I think it could be the Omni Tool. Have you ever come across this message before?

    Thanks

    Hung

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Locked User

    Log in to GP as 'sa' and change the user's password - see if they can log in.

    Look at Security in SQL for that user - right click and select properties - there is a tick box somewhere marking the user as disabled - untick it.

    Ian.

  • Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Locked User

    Hi Hung,

    Run the script below:

    delete tempdb..DEX_SESSION

    delete tempdb..DEX_LOCK

    delete DYNAMICS..SY00800

    delete DYNAMICS..SY00801

    delete DYNAMICS..ACTIVITY

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Locked User

    Check the following reference for Victoria Yuidin,

    victoriayudin.com/.../sql-view-for-user-activity-in-dynamics-gp

    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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans