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 figure it out, it was the Omni Tool security.
Thanks for your help.
Hung
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
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.
Hi Hung,
Run the script below:
delete tempdb..DEX_SESSION
delete tempdb..DEX_LOCK
delete DYNAMICS..SY00800
delete DYNAMICS..SY00801
delete DYNAMICS..ACTIVITY
Check the following reference for Victoria Yuidin,
victoriayudin.com/.../sql-view-for-user-activity-in-dynamics-gp
hope this helps
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156