While upgrading our GP from GP2010 SP3 to GP2013 SP1, DYNAMICS database upgrade stopped unexpectedly with GP crashing without any information for me to debug.
But it stopped exactly at table
and crashed. Without spending anymore time, I just went and checked my ODBC DSN setup, syExcelReports . Expectedly, the ODBC DSN driver was not pointing to SQL Server Native Client 10.0. as explained by Aaron Berquist on his blog High Dynamics Range
For some reason, GP fails to process upgrade further if your DSN driver is NOT native client 10.0 or above.
Those who upgrade your GP to latest version, please check DSN before you start database upgrade using GP Utilities.
Debugging, DSN, GP, GP 2013, GP Administration, GP Utilities, GP2013, Implementation, Microsoft Dynamics GP, Microsoft Dynamics GP 2013, ODBC, SQL, SQL Native Client, SQL Server, syExcelReports, Troubleshooting, Upgrade |
David Musgrave informs us about the release of
. Read his post and plan for the upgrade. Microsoft Dynamics GP 2010 Service Pack 3
Got to plan my Saturday accordingly now.
Those who are on Microsoft Dynamics GP 10, would want to seriously think about upgrading their product.
Microsoft Dynamics GP Support Blog has posted this morning that Microsoft Dynamics GP 10 Mainstream Support ends on October 9th, 2012.
So be aware of this fact and plan for your upgrade at the earliest.
has got an important piece of information, posted by Njevity Blog Melissa Sandrovich, on available Upgrade Paths for Dynamics GP 2010.
The paths are detailed from versions 9.0 till lower versions of GP2010 to it’s current version.
Those who are looking for this information anywhere else, this post would be of immense time saver.
Mariano quotes us from Randal Mayer on
How to Upgrade 150+ GP Companies.
I have never even imagined more than 15-20 companies, and this advise IS needed for all of us.
And this post also answers a major question: Is Dynamics GP really capable of handling loads and transactions? Now a customer having 150+ companies in Dynamics GP 9.0. And we have already got Dynamics GP 2010 with SQL Server 2008 R2.
That’s a lesson to all who doubt GP’s capability.