Remedy - AR System Server - Getting error: "ARERR 36 - The database is not the expected version. You may need to run an upgrade program..." while upgrading AR Server.

Knowledge Article

Remedy - AR System Server - Getting error: "ARERR 36 - The database is not the expected version. You may need to run an upgrade program..." while upgrading AR Server.
Getting error: "ARERR 36 - The database is not the expected version. You may need to run an upgrade program..." while upgrading AR Server.
Remedy AR System Server
AR System
BMC Remedy AR System Server
Remedy AR System Server
AR System
BMC Remedy AR System Server
What is the Remedy dbversion for each version of AR Server?
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

1. The value for dbversion is an attribute in the data dictionary that identifies the version of database schema for the ARSystem server. 
2. This attribute is modified during upgrade of ARSystem server to a later release.
3. If the value for dbversion in the data dictionary does not correspond to the expected value for a given version of AR System server, startup will fail with ARERR 36 error:
ARERR 36
The database is not the expected version.  You may need to run an upgrade program.
AR System server (arserverd) expects a different version of the AR System database from the version being referenced.  ARSystem server cannot run against an unknown version of the AR System database.

NOTE:
>> The value for dbversion cannot be changed at the database level as it reflects not only a given version of AR System server install or upgrade, it also reflects the version of the database schema itself; each version of AR System server has unique differences in the data dictionary.
>> Changing the value for dbversion requires running upgrade install for AR System server using that database.This upgrade install will also upgrade the data dictionary to the current version for that release of AR System server.
 
4. The definition for data dictionary of a given version of AR System server can be found in the Database Reference manual.

The following SQL can be used to determine the dbversion of a given database schema:
     SELECT dbversion from control
 
To know the value of dbversion corresponding to the version of AR System server installed please check the article below:
List of BMC Remedy Release Version Strings and dbversion values

For example if the ARERR 36, occurs while upgrading remedy from 9.1.07 to 20.02 on one of server, then can run below update statement in database to update dbversion to 9.1.07.This will help resolve the error and proceed with Upgrade on remaining servers of server group.

UPDATE control SET dbversion = '60';

Note: Please verify the dbversion once completed with the Upgrade.
 
Remedy AR System Server
AR System
BMC Remedy AR System Server
Attachment(s):