Error message in the installation wizard for Business Portal in Microsoft Dynamics GP: "The Business Portal data in the database you selected is not compatible with this version of the Business Portal"


When you click Next in the installation wizard for Business Portal in Microsoft Dynamics GP, you receive the following error message:
The Business Portal data in the database you selected is not compatible with this version of the Business Portal. You must select a different database before continuing.

Cause


This problem occurs because the installation wizard for Business Portal has determined that a database incompatibility exists. The incompatibility prevents the installation or the upgrade from continuing.

Resolution


To identify the incompatibility, to resolve the error message, and to enable the installation wizard to finish, follow these steps.
  1. Start the query tool for SQL Server. To do this, use the following step for your version of SQL Server:
    • SQL Server 2008: Click Start, point to Programs, click Microsoft SQL Server 2008, click SQL Server Management Studio, and then click the New Query button.
    • SQL Server 2005: Click Start, point to Programs, click Microsoft SQL Server 2005, click SQL Server Management Studio, and then click the New Query button.
    • SQL Server 2000: Click Start, point to Programs, click Microsoft SQL Server, and then click SQL Query Analyzer.
  2. Determine whether there are any orphaned companies in Microsoft Dynamics GP. To do this, run the following statement against the DYNAMICS database.
    select * from DYNAMICS..SY01500 where INTERID not in
    (select name from master..sysdatabases)
    Notes
    • The SY01500 table is the company master table. This table contains a record for each company in Microsoft Dynamics GP.
    • If this script returns records, you have to restore the Microsoft SQL Server database to an online status. Or, you have to remove the records from the following tables in the DYNAMICS database:
      • SY01500
      • DU000020
      • DB_Upgrade
  3. Determine whether company version differences exist. To do this, run the following statement against the DYNAMICS database. In the statement, replace X with the Microsoft Dynamics GP major version that you are running.
    select * from DYNAMICS..DU000020 where versionMajor <> X
    Notes
    • The DU000020 table contains company version information.
    • All the companies for all the products have to be upgraded in the back-office application to successfully install the corresponding Business Portal version.
    • If you install Business Portal 3.0, all the records in the table must match the following columns:
      • versionMajor = 9
      • versionMinor = 0
    • If you install Business Portal for GP 10.0, all the records in the table must match the following columns:

      • versionMajor = 10
      • versionMinor = 0
    • If this statement returns records, run Microsoft Dynamics GP 9.0 Utilities to resolve any outstanding upgrade issues.
  4. Determine whether database version differences exist. To do this, run the following statement against the DYNAMICS database. In the statement, replace X with the Microsoft Dynamics GP major version that you are running.
    select * from DYNAMICS..DB_Upgrade where db_verMajor <> X
    Notes
    • The DB_Upgrade table contains database version information.
    • All the companies for all the products have to be upgraded in the back-office application to successfully install the corresponding Business Portal version.
    • If you install Business Portal 3.0, all records in the table must match the following columns:
      • db_verMajor = 9
      • db_verMinor = 0
    • If you install Business Portal for GP 10.0, all the records in the table must match the following columns:

      • db_verMajor = 10
      • db_verMinor = 0
    • If this statement returns records, run Microsoft Dynamics GP 9.0 Utilities to resolve any outstanding upgrade issues.
  5. Determine the database status. To do this, run the following statement against the DYNAMICS database.
    select * from DYNAMICS..DB_Upgrade where db_status <> 0
    Notes
    • If this statement returns records, run Microsoft Dynamics GP Utilities to resolve any outstanding upgrade issues.
    • If Microsoft Dynamics GP Utilities indicates that all companies are upgraded, run the following statement to change the database status to 0. When you change the database status to 0, you enable the Business Portal installation wizard to run.
      update DYNAMICS..DB_Upgrade set db_status = 0 where db_status <> 0
  6. Determine the feature ID version information. To do this, run the following statement against the DYNAMICS database.

    select * from DYNAMICS..MBFInstalledDatabases
    Notes
    • Business Portal only supports upgrades from specific versions. The following upgrade paths are supported.

      Note Business Portal 2.7 is also known as Business Portal 2.5 Feature Pack
      • Business Portal 3.0 to Business Portal for GP 10.0
      • Business Portal 2.7 to Business Portal for GP 10.0
      • Business Portal 2.7 to Business Portal 3.0
      • Business Portal 2.5 to Business Portal 3.0
    • Except for Business Framework, all features require that the major version value in the Ver_Major field and the minor version value in the Ver_Minor field be set to the corresponding Business Portal version.
    • Business Portal for GP 10.0 will have values of 4 in the Ver_Major column.

References


For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

923665 How to uninstall Business Portal 3.0

862544 How to remove Business Portal 2.x