We have users on GP 2010 who are posting invoices. Randomly we have users who lockup during this process. This causes other users who are in GP to lockup as well. When we check the activity in SQL we see that the user has several locks on the master database. We kill the process that has the locks on the master database and this resolves the GP lockup for all users.
We are using GP 2010 with the January 2013 hotfix (version 11.00.2164) on SQL 2008r2 (version 10.50.1617). Users access GP via a Terminal server /RDS (2008r2). We upgraded to the January hotfix about a month ago and there have been no changes to the system since then. This issue first occurred last Thursday. It has now happened five days in a row all when users are posting. Users were posting all day and the first time we had an issue was at 1 p.m. The SQL and TS/RDS servers were rebooted over the weekend with no change.
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156