Share
Report
75,730I was at a client's site yesterday and while I was there a user had an issue entering an inventory adjustment entry for an item. She would enter the item number and then the quantity and as soon as she moved off the quantity GP would lock. You could not minimize the screen or anything so the other recourse was to kill GP using task manager. Usually when this happens I run my SQL check for lock scripts and it will tell me the user(s) locking the record. This time there was nothing. The fix was to slowly back all users out of GP. The most perplexing thing about this one was that we did have the offending user exit GP but he had only been sitting on his GP home page with no other GP windows open. So there was a SQL lock there but I had no way to see it. This was GP 2013. This was a rare event and I am curious if any one has experienced this? Yes, there were spids sitting in the dex_lock and dex_session tables but usually these spids will match up with what my scripts show me but not this time. If any one from Microsoft can chime in on this one and provide SQL scripts that you would use to check for locks I would appreciate it.
*This post is locked for comments
All responses (
Answers (
