Martin and Associates

Error During GP 2013 Upgrade from GP 2010 or GP 10 about the system database not being found

Error During GP 2013 Upgrade from GP 2010 or GP 10 about the system database not being found

I recently ran into this issue when trying to start an upgrade from GP 2010 to GP 2013.  Here is the scenario:

  • A test server had been created, and copies of the live gp databases restored
  • A fresh install of GP 2010 was on the test server, and the companies could be accessed through the GP client.
  • A new install of GP 2013 was completed, with the latest service pack.  Rolled with the default to create a new data source, and to keep the system database name as DYNAMICS
  • Windows Server 2008 R2 and SQL 2008 R2

When running GP 2013 Utilities, it asked to create a new system database, which I thought was weird since a DYNAMICS database was already present on the server, and I specified during the install to use that name.  I clicked to create a Basic install, and then when it tried that, up popped this error message:

“A system database name was not supplied.  Run a repair of the Microsoft Dynamics GP installation.”

I could only hit OK and then Utilities closed.  Using my freshly gained knowledge at Convergence 2013, there is a new line in the Dex.ini file that keeps track of the system database name.  That line is called “Pathname”, and it should look like this:

Pathname=DYNAMICS/dbo/

Where DYNAMICS is the name of the system database.  However, it seems that after an initial install, that line reads Pathname=/dbo/ with no system database name.

After updating the file to read correctly (Pathname=DYNAMICS/dbo/) I was able to run GP 2013 Utilities and perform the update.

What fun!

Other Blog Posts

Martin & Associates Named to 2015 Top 100 VARs

Martin and Associates has been named to the Bob Scott’s Insights Top 100 VARs for 2015. The Top 100 resellers are chosen from organizations specializing in the sale and implementation

Budgeting Add-on Solutions for Sage 500

Budgeting is a vital task that is typically tedious due to the logistics of manually linking spreadsheets together, but today’s software has changed that experience.  Third party software manufacturers are

Sage Enterprise Intelligence is Now Available for Sage 500

Sage Software announced today the general availability of Sage Enterprise Intelligence – an intuitive business intelligence solution integrated with Sage 500 ERP – to help business users reduce time spent

Emailing Vendor Remittances for AP ACH Payments in Acumatica

Starting with Acumatica version 6.10.0680, Vendor Remittances can be emailed after processing payments in the AP module. This document will cover emailing Vendor Remittance information for AP ACH payments.  This document assumes

WordPress Appliance - Powered by TurnKey Linux