Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Posting in GP 2010 is ...

Posting in GP 2010 is causing locks on the master database.

(0) Share

Report

Posted on by Jon McKinnon

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