Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Recieving an "Invalid Database Version" error when running CRMDiag on CaliberRM 2008 SP1 database

Recieving an "Invalid Database Version" error when running CRMDiag on CaliberRM 2008 SP1 database

Problem:

Recieving an "Invalid Database Version" error when running CRMDiag on CaliberRM 2008 SP1 database

Resolution:

Issue:
I am not able to run CRMDiag on my CaliberRM 2008 SP1 database. Receiving an "Invalid Database Version" error when running the utility.

Example
C:\>crmdiag -s SQMDB

crmdiag build version 10.0.345.2

Stopping SQM Monitor...
Note: Database will be modified and the nobackup flag is set. Database will not
be backed up!
Database Version 9.0.0
Database version does not match expected verion (1000).
*** Invalid Database Version.

Cause:
The database version was never upgraded or installed properly as it is at version 9.0.0. For CaliberRM 2008 SP1, it should be at version 10.0.0. The version of CRMDiag being used (10.0.345.2) is built specifically for version 10.0.0.

* In brand new installs, the databases are being created as version 9.0.0.
* In upgraded databases, the database conversion process likely never completed in its entirety. A successful upgrade should complete through Upgrade Step 11 and show start and finish of 10.0 Conversion.

(see attachment for excerpt of successful upgrade)

Resolution:

** For brand new 2008 SP1 installs **

To convert the database to version 10.0.0, you can run the upgrade command to run the full upgrade and convert the database. From the command prompt, run the following command:

  • dbmgr -upgrade

This process should complete through Upgrade Step 11 and show that it started and finished the 10.0 Conversion.

** For upgraded databases **

Check the Caliber install.log file to see if the "latest" upgrade process failed to complete. \Borland\CaliberRMServer\Lib\Install.log

If the any step of the upgrade process failed, that step and subsequesnt steps should be re-ran. This can be done by running the following command:

  • dbmgr -upgrade#

Example:

  • dbmgr -upgrade8
  • dbmgr -upgrade10
  • dbmgr -upgrade11

If step 6 failed, run steps 6-11, if step 2 failed ... steps 2-11, etc.

*Note: there is not a step 9 of the upgrade process*

upgrade_success.txt
Old KB# 29796

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 20:40
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.