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

Document created by RSA Customer Support Employee on Nov 18, 2019Last modified by RSA Customer Support Employee on Dec 3, 2019
Version 21Show Document
  • View in full screen mode

Article Content

Article Number000038148
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.1.0 P08, 7.1.0 P09, 7.1.1 P02, 7.1.1 P03
IssueWhen 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.



User-added image




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.

CauseThis 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.
ResolutionThis issue is resolved in RSA Identity Governance & Lifecycle 7.1.1 P05.
WorkaroundThe 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.
 

User-added image


  1. 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


  1. Run migrate.sh again.


./migrate.sh


  1. Restart RSA Identity Governance & Lifecycle 


acm restart
NotesThe error below is benign and may be safely ignored:
 
java.io.FileNotFoundException: /home/oracle/database/reportdefs/UserEntitlements.jrxml (No such file or directory)

Attachments

Outcomes