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!