NaomiP 9/18/2007 3:42:00 PM

Error message when you start Microsoft Dynamics GP: "Dynamics

SYMPTOMS

When you start Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains, you may receive the following error message: Dynamics SQL Database has not been setup for this version.

CAUSE

 

Cause 1

This problem occurs because the values in the tables in the DYNAMICS database do not correspond to the version of Microsoft Dynamics GP or of Microsoft Business Solutions - Great Plains that you are using. See Resolution 1 in the "Resolution" section.

Cause 2

This problem occurs because the Client installation of Microsoft Dynamics GP was installed instead of the Server installation. You must install the Server installation before you can update the databases in Utilities. See Resolution 2 in the "Resolution" section.

RESOLUTION

 

Resolution 1

1. Make sure that you have a good backup of the DYNAMICS database.
2. Use Query Analyzer or SQL Management Studio to run the following script against the DYNAMICS database.
 SELECT * FROM DYNAMICS..DU000020
SELECT * FROM DYNAMICS..DB_Upgrade 
Notes
In the results for the DU000020 table, verify that the values in the following columns correspond to the version of Microsoft Dynamics GP or of Microsoft Great Plains that you are using:
The versionMajor column
The versionMinor column
For example, if you are using Microsoft Dynamics GP 9.0, you should see the following values:
The versionMajor column: 9
The versionMinor column: 0
In the DB_Upgrade table results, verify that the values in the following columns correspond to the version of Microsoft Dynamics GP or of Microsoft Great Plains that you are using:
The db_verMajor column
The db_verMinor column
The db_verOldMajor column
The db_verOldMinor column
For example, if you are using Microsoft Dynamics GP 9.0, you should see the following values:
The db_verMajor column: 9
The db_verMinor column: 0
The db_verOldMajor column: 9
The db_verOldMinor column: 0
3. If the values in the columns that are listed in step 2 do not correspond to the version of Microsoft Dynamics GP that you are using, run the following scripts in Query Analyzer or in SQL Server Management Studio.

Script 1

 
update DYNAMICS..DU000020 
  set versionMajor = VERSIONMAJOR, versionMinor = VERSIONMINOR
  where companyID = COMPANYID
 
Notes
Replace the VERSIONMAJOR placeholder and the VERSIONMINOR placeholder with the numbers of the version that you are currently using. For example, if you are using Microsoft Dynamics GP 9.0, the VERSIONMAJOR placeholder should be 9 and the VERSIONMINOR placeholder should be 0.
Replace the COMPANYID placeholder with the company ID of the company that has the incorrect version information. To determine the company ID, run the following statement.
 
SELECT * FROM DYNAMICS..SY01500
 

Script 2

 
update DYNAMICS..DB_Upgrade 
  set db_verMajor = VERSIONMAJOR, db_verMinor = VERSIONMINOR
  where db_name = DATABASENAME
 
Notes
Replace the VERSIONMAJOR placeholder and the VERSIONMINOR placeholder with the numbers of the version that you are currently using. For example, if you are using Microsoft Dynamics GP 9.0, the VERSIONMAJOR placeholder should be 9 and the VERSIONMINOR placeholder should be 0.
Replace the DATABASENAME placeholder with the name of the database for the company.

Resolution 2

 

Microsoft Dynamics GP

If you are using Microsoft Dynamics GP, remove the Client installation and reinstall the Server installation. To do this, follow these steps:

1. Click Start, click Control Panel, and then click Add or Remove Programs.
2. On the list, select Microsoft Dynamics GP, and then click Change.
3. Click Remove to remove the Client installation of Microsoft Dynamics GP.
4. When you reinstall Microsoft Dynamics GP, click Server in the Installation Type window, and then click Next.
5. Finish the installation.

Microsoft Business Solutions - Great Plains

If you are using Microsoft Business Solutions - Great Plains, convert the Client installation to a Server installation. To do this, follow these steps:

1. Start the installation by using CD 1 of the Microsoft Business Solutions - Great Plains installation CD set. To do this, double-click the CDSetup.exe file.
2. Click Install Great Plains, and then accept the same default settings that you used for the Client installation except for the following settings:
a. At the Select to Install Server or Client window, click Server and Client Installation.
b. At the Select Great Plains Components window, click SQL Server Objects.
3. Finish the installation.

Version: Unknown or N/A
Section: Dynamics GP
This thread has been marked as 'Closed' and archived


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3