Dynamics Community Forum Thread Details

Business Portal - DB Version Error on Pre-Requisite Check

Hi,

I am working at a company as the SharePoing administrator, there were some serious challenges around how the SharePoint configuration and deployment was done on our environment so we set out to install a new SharePoint server with Business Portal for GP.

I have installed all the Pre-requisites as per the Installation Guide and the GP Web Services Installation Guide, but when I run the pre-requisites checker i get an error stating that the database version is incorrect.

In the log file the error is like this:

Prerequisite Item: DB Version
Status : Failed
Result :
Your DB Major Version: 9. Minimum Requirement: 10.
Your DB Minor Version: 0. Minimum Requirement: 0.

Now this was running before so there should be no problems, the other thing i thought was that perhaps i was connecting to a invalid database but it seems that the "DYNAMICS" DB on my SQL box is the correct one.

My Environment:

MOSS 2007 Enterprise with SSRS Integrated Mode on a single server
SQL Server 2005 - version 0.0.3042.0 Enterprise Edition (64Bit)

Any help will be appreciated on this matter, thank you in advance.

What version GP? what version BP? Not sure I can help...but maybe the following will point you in the right direction:

You could look at the du000020 table in the Dynamics database, this contains info on company db versions. If you on GP 10, then all records in this table must be a value of 10 for the field 'versionmajor' and 0 for the field 'versionminor'. A query like select * from du000020 where versionmajor <> '10' run against the dynamics database will show up any problems.

A similar query can also be run against the DB_UPGRADE table also in the dynamics database. (the field is different, but a 'select * from....' will show you what the versionmajor field is called). This table contains info on Database Versions. and database status....if any of the database statuses are not equal to '0' it means they have not upgraded properly. You will want to re-run GP Utilities to complete any upgrade tasks.

Something else you could look at - have you checked your database compatibility levels? For SQL 2005 it should be 90. The Master, model and Dynamics databases all need to be 90. These can be verified (and changed if needed) by selecting the database in SQL manager, right clicking and selecting properties.

Are any of the GP company databases off-line? I did get install errors whereby all databases had to be on line (actually got around it by editing the sy01500 table - which contains info on all of the company databases).

Its something to start with anyway! Hope it helps.

Quick Links

Leaderboard