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

2 years ago

Originally Published: 2019-11-18

Article Number

000043644

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

User-added image

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

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

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

Run createSchema.sh again.

./createSchema.sh

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)

Attachments

If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).

aveksa-version.zip.zip

Don't see what you're looking for?

Related Articles

Trending Articles