000034939 - How to overcome the RSA Identity Governance and Lifecycle initialization status error when the database schema version is higher than the software version

Document created by RSA Customer Support Employee on Apr 13, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000034939
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: All
IssueThe  error below may occur when accessing the UI after applying a patch. In the example below, patch 2 is being applied to RSA Identity Governance and Lifecycle 7.0.1 GA.
 
Initialization Status
Initialization operations completed with errors.  Please resolve the problems(s) before the application server can accept requests.
Error:  Current software is ant a patch version older than indicated by the database.  Update software to a patch version that is greater than or equal to that of the database schema.  Software patch version:  P02 Database schema at patch version: P04.


User-added image
CauseRSA Identity Governance and Lifecycle might encounter this error when the previous hot fix parameter value is not removed during the patch installation. This could also happen if the database is restored on a system with a lower patch level.
Resolution
Run the queries below to check the Hotfix parameter and version details in T_SYSTEM_SETTINGS.
 
SELECT * FROM T_SYSTEM_SETTINGS WHERE parameter LIKE '%HotFix%';

The output will be similar to what is shown here:
 

PARAMETERVALUE
HotFix_Build115344
HotFixesP04

 
SELECT * FROM T_SYSTEM_SETTINGS WHERE parameter LIKE '%Version%';

The output will be similar to what is shown here:
 

PARAMETERVALUE
productVersion7.0.1
SchemaCreatedVersion5.1.4
hashReportVersion8f0ba73c3ff55ba72d45fe07a62681570ffc4bbe4e5a21ad7b2cbb1072173983
hashReportStyleVersion8f0ba73c3ff55ba72d45fe07a62681570ffc4bbe4e5a21ad7b2cbb1072173983

The database shows that the schema was created at version 5.1.4, the  hot fix is 7.0.0.115344 P04 and the major version is 7.0.1. 
Although you are trying to deploy P02 in V7.0.1, the system is taking the hot fix value of P04 from the T_SYSTEM_SETTINGS table. In order to fix this issue please contact RSA customer support.  It is strongly advised that you have a recent database backup before contacting customer support.

Attachments

    Outcomes