How to overcome the RSA Identity Governance & Lifecycle initialization status error when the database schema version is higher than the software version
Originally Published: 2017-03-15
Article Number
Applies To
RSA Version/Condition: All
Issue
Initialization Status Initialization operations completed with errors. Please resolve the problems(s) before the application server can accept requests. Error: Current software is at 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.
Cause
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:
| PARAMETER | VALUE |
| HotFix_Build | 115344 |
| HotFixes | P04 |
SELECT * FROM T_SYSTEM_SETTINGS WHERE PARAMETER LIKE '%Version%';
The output will be similar to what is shown here:
| PARAMETER | VALUE |
| productVersion | 7.0.1 |
| SchemaCreatedVersion | 5.1.4 |
| hashReportVersion | 8f0ba73c3ff55ba72d45fe07a62681570ffc4bbe4e5a21ad7b2cbb1072173983 |
| hashReportStyleVersion | 8f0ba73c3ff55ba72d45fe07a62681570ffc4bbe4e5a21ad7b2cbb1072173983 |
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.
