web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
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

I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans