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

[#1]

Article Number

000038146

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/createSchema.sh, which drops and recreates the AVUSER database schema, 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 starting RSA Identity Governance & Lifecycle, users are unable to login to the user interface:

Unable to check Database.java.lang.NullPointerException

Image description

The errors are also seen in the /home/oracle/database/log/create.log file:

SQL/line#: /home/oracle/database/migration/populateReports.sql(1):
Start time [Fri Nov 15 13:30:08 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.CreateSchema.execute(CreateSchema.java:103)
	at com.aveksa.cli.CreateMigrateSchemaModule.runCommandImpl(CreateMigrateSchemaModule.java:277)
	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 [Fri Nov 15 13:30:08 EST 2019]
Execution time (s): 0

 

SQL/line#: /home/oracle/database/migration/setVersion.sql(1):
Start time [Fri Nov 15 13:30:51 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.CreateSchema.execute(CreateSchema.java:103)
	at com.aveksa.cli.CreateMigrateSchemaModule.runCommandImpl(CreateMigrateSchemaModule.java:277)
	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 [Fri Nov 15 13:30:51 EST 2019]
Execution time (s): 0
[0:00:00] File Completion Time: /home/oracle/database/migration/setVersion.sql
[0:09:32] Total Migration Time

Please note this is also a problem with the migrate.sh script file. Please see RSA Knowledge Base Article 000038148 -- 'java.io.FileNotFoundException: aveksa-version.properties' error running migrate.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 workaround is to move the appropriate aveksa-version.properties file to the /home/oracle/database directory and run createSchema.sh again.

STEPS

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 createSchema.sh again.

./createSchema.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)