Locked User

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Locked User

Check the following reference for Victoria Yuidin,

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

hope this helps

Was this reply helpful? Yes No
Tristan Clores 2,812 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Locked User

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

Thanks for your help.

Hung

Was this reply helpful? Yes No