Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

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

Posted on by 40

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans