'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
  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
  1. Run createSchema.sh again.
./createSchema.sh
  1. 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).

Related Articles

Trending Articles

Don't see what you're looking for?