In April of 2001, Microsoft Corp announced the acquisition of Great Plains Software Inc. for about $ 1.1 Billion. Great Plains was not a failing business but was leading supplier of midmarket business applications called now Microsoft Great Plains.

I remember what Doug Burgum (company president) said, “Microsoft Great Plains will continue to enhance our solid reputation for customer service and innovative business solutions. With the commitment of our 2,200 global channel partners, more than 2,000 team members, and the tremendous people and technical assets within Microsoft, we have the opportunity to reshape some of the basic assumptions that have guided commerce in the past and truly improve the lives and business success of our customers.”

The innovation of Great plains targeted the improvement of the functionalities as new versions were put on the market but extended beyond the normal most of the previous errors within the application.

What could be the reason for Microsoft to do that?

Let me just make an assumption here: Based Doug said, “With the commitment of our 2,200 global channel partners, more than 2,000 team members,…”

Microsoft probably feels obligated to ignore the errors in the application to permit partners to get busy solving problems, given the sense of being relevant for the maintenance of the software and preserving the partnership.

In that perspective I am bringing you a solution if you are confronted by the issue that a company is locked and you can’t run an upgrade.

You just need to go to the Dynamics database and look for  duLCK table and delete the contents of the duLCK. After you have run this script :

Delete activity against the dynamics database.

In order for you to finish the upgrade first try to remove the lock on the test company.

go to your SQL server and see if you have records on DYNAMICS..duLCK if you have then make sure no one is logged in GP for that company and then delete the contents of the duLCK table.

Then, retry your upgrade!

Need GP help? Get worry free Dynamics GP Upgrades and support from the experts at MIBAR. Contact us for more information. 

As a company who has worked with businesses throughout New York to help users make the most out of Dynamics GP, the MIBAR team is ready and able to help you on your move away from the Dynamics GP platform—providing a secure, efficient, and seamless transition to a future-proof cloud product.

As a Dynamics GP user, it is important that you understand GP End of Life. It is not just a distant event; it carries substantial implications that every business must be aware of. To learn more, please watch our on-demand webinar, Microsoft Dynamics GP End of Life – What’s Next, to:

  • Gain a firm grasp of the critical dates that will shape your decision-making process.
  • Decode the terminology to understand how it will directly affect your day-to-day operations & future of your org.
  • Delve into the security & business continuity risks that may jeopardize your organization.

Click here to watch now.

Dynamics GP Alternatives