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. 

Wait! Before You GoWould you like to talk to a business software expert to answer your questions?

When you schedule a free consultation with MIBAR, you will experience a one-on-one conversation with a business technology expert who is passionate about understanding your unique needs or issues. Schedule a free consultation today at the link below or give us a call at (212) 869-9300.

Learn More