'java.io.FileNotFoundException: aveksa-version.properties' error running migrate.sh in RSA Identity Governance & Lifecycle

[#1]

Article Number

000038148

Applies To

RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.1.0 P08, 7.1.0 P09, 7.1.1 P02, 7.1.1 P03

Issue

When running /home/oracle/database/migrate.sh, to upgrade an existing database to the currently installed version of RSA Identity Governance & Lifecycle, the following two errors are seen in the output:

• java.io.FileNotFoundException: /home/oracle/database/reportdefs/UserEntitlements.jrxml (No such file or directory)
• java.io.FileNotFoundException: aveksa-version.properties

After restarting RSA Identity Governance & Lifecycle, the user interface indicates Schema Migration is required even though you have just run the migration script.

Image description

The errors are also seen in the /home/oracle/database/log/migrate.log (or /home/oracle/wildfly/standalone/log/migrate.log) file:
 

SQL/line#: /home/oracle/database/migration/populateReports.sql(1):
Start time [Mon Nov 18 10:39:24 EST 2019]
java com.aveksa.migration.jdbctool.JavaStepPopulateReports
java.io.FileNotFoundException: /home/oracle/database/reportdefs/UserEntitlements.jrxml 
(No such file or directory)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(FileInputStream.java:195)
        at java.io.FileInputStream.<init>(FileInputStream.java:138)
        at com.aveksa.common.utils.IOUtils.getFileAsString(IOUtils.java:101)
        at com.aveksa.migration.jdbctool.PopulateAvReports.readJRXML(PopulateAvReports.java:2757)
        at com.aveksa.migration.jdbctool.PopulateAvReports.createReportFromXMLFile(PopulateAvReports.java:2672)
        at com.aveksa.migration.jdbctool.PopulateAvReports.createReportFromXMLFile(PopulateAvReports.java:2654)
        at com.aveksa.migration.jdbctool.PopulateAvReports.createReportFromXMLFile(PopulateAvReports.java:2639)
        at com.aveksa.migration.jdbctool.PopulateAvReports.initializeReportTemplates(PopulateAvReports.java:88)
        at com.aveksa.migration.jdbctool.PopulateAvReports.execute(PopulateAvReports.java:69)
        at com.aveksa.migration.jdbctool.JavaStepPopulateReports.run(JavaStepPopulateReports.java:17)
        at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:211)
        at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:107)
        at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:98)
        at com.aveksa.migration.jdbctool.IncrementalUpdate.update(IncrementalUpdate.java:481)
        at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:163)
        at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:83)
        at com.aveksa.cli.CreateMigrateSchemaModule.runCommandImpl(CreateMigrateSchemaModule.java:211)
        at com.aveksa.cli.BaseDatabaseCLIModule.runCommand(BaseDatabaseCLIModule.java:97)
        at com.aveksa.cli.Main.run(Main.java:351)
        at com.aveksa.cli.Main.main(Main.java:405)
End time [Mon Nov 18 10:39:24 EST 2019]
Execution time (s): 0

 

SQL/line#: /home/oracle/database/migration/setVersion.sql(1):
Start time [Mon Nov 18 10:40:17 EST 2019]
java com.aveksa.migration.jdbctool.JavaStepSetVersion
java.io.FileNotFoundException: aveksa-version.properties
        at com.aveksa.migration.jdbctool.JavaStepSetVersion.run(JavaStepSetVersion.java:35)
        at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:211)
        at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:107)
        at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:98)
        at com.aveksa.migration.jdbctool.IncrementalUpdate.update(IncrementalUpdate.java:481)
        at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:163)
        at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:83)
        at com.aveksa.cli.CreateMigrateSchemaModule.runCommandImpl(CreateMigrateSchemaModule.java:211)
        at com.aveksa.cli.BaseDatabaseCLIModule.runCommand(BaseDatabaseCLIModule.java:97)
        at com.aveksa.cli.Main.run(Main.java:351)
        at com.aveksa.cli.Main.main(Main.java:405)
End time [Mon Nov 18 10:40:17 EST 2019]
Execution time (s): 0
[0:00:00] File Completion Time: /home/oracle/database/migration/setVersion.sql
[0:04:08] Total Migration Time

Please note this is also a problem with the createSchema.sh script file. Please see RSA Knowledge Base Article 000038146 -- 'java.io.FileNotFoundException: aveksa-version.properties' error running createSchema.sh in RSA Identity Governance & Lifecycle for more information.

Cause

This is a known issue in RSA Identity Governance & Lifecycle versions 7.1.1 P02, 7.1.1 P03, 7.1.0 P08, and 7.1.0 P09 and has been reported in engineering ticket ACM-102310.

Resolution

This issue is resolved in the following RSA Identity Governance & Lifecycle versions and/or patch levels:

• RSA Identity Governance & Lifecycle 7.1.1 P05
• RSA Identity Governance & Lifecycle 7.2

Workaround

The preferrred workaround is to run the migration from the user interface. An alternate workaround would be to move the appropriate aveksa-version.properties file to the /home/oracle/database directory and run migrate.sh again.
 

PREFERRED WORKAROUND

1. Go to the user interface, enter AuthorizeMigration at the password prompt and press Migrate Schema.

 

Image description

2. Restart RSA Identity Governance & Lifecycle  

acm restart

 

ALTERNATE WORKAROUND

1. Download the attached aveksa-version.zip file.
2. Note the files are named in the format aveksa-version_<versionpatch>.properties.
3. Extract the appropriate file for your RSA Identity Governance & Lifecycle version and patch level.
4. Copy the file to the /home/oracle/database directory using WinSCP or a similar tool.
5. Login to the server as the oracle user.
6. Rename aveksa-version_<versionpatch>.properties to aveksa-version.properties.

cd /home/oracle/database
mv aveksa-version_<versionpatch>.properties aveksa-version.properties

7. Run migrate.sh again.

./migrate.sh

8. Restart RSA Identity Governance & Lifecycle 

acm restart

Notes

The error below is benign and may be safely ignored:
 

java.io.FileNotFoundException: /home/oracle/database/reportdefs/UserEntitlements.jrxml (No such file or directory)