When I do checklink in Sales Work getting error msg is that 'Users already loged in' where as nobody logged in. And, when I do reconcile the inventory items at that time getting msg that 'posting process is not completed' . There is no data in the recovery window. How do remove the stucked users from the table. We are using GP 2010.
*This post is locked for comments
Have a look on below link.
Hope this helps!!!
Hi Sukumaran,
Run the script below in SQL:
delete DYNAMICS..SY00800
delete DYNAMICS..SY00801
delete DYNAMICS..ACTIVITY
delete tempdb..DEX_LOCK
delete tempdb..DEX_SESSION
Make sure that all users are logged out of GP before running the script.
Look in Admin->Routines->master posting? This is supposed to list all batches including some stuck in processing. You may need to recover and complete those batches.
Worst case, you can go into SY0500 in the Dynamics database and manually delete those batch headers. This will not delete the detail, just the header that shows the batch as stuck.
As for the users, some people do not exit properly. First place to look is Administration->Utilities->System-> User activity to see if GP thinks anyone is logged in. You can delete those users if needed.
Otherwise, the user can be stuck in SQL. I always recommend shutting down and restarting SQL if nothing else works (of course at night when no one is supposed to be logged in)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (