RSA Identity Governance and Lifecycle migration script insertMigrationReportDefinitions.sh fails with error ORA-01017: table or view does not exist

[#1]

Article Number

000034676

Applies To

RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 6.9.1, 7.0.0, 7.0.1
Product Name: RSA Identity Governance and Lifecycle
 

Issue

The RSA Identity Governance and Lifecycle migration script named insertMigrationReportDefinitions.sh fails with the following error:

ERROR: ORA-01017: invalid username/password; logon denied

When running any of the Migration Reports they fail with the error ORA-00942: table or view does not exist.

Image description

The /home/oracle/jboss-4.2.2.GA/server/default/deploy/aveksa.ear/aveksa.war/log/aveksaServer.log shows the following exception:

12/14/2016 08:31:36.298 ERROR (http-0.0.0.0-8443-31) [com.aveksa.server.report.Report] get all display cols 
com.aveksa.server.runtime.ServerException: java.sql.SQLException: ORA-00942: table or view does not exist

 

Cause

This issue may occur if the  insertMigrationReportDefinitions.sh script fails to complete successfully.  The most common failure is supplying an incorrect password for the AVUSER or the AVDWUSER accounts.  

The following shows a failed attempt to run the insertMigrationReportDefinitions.sh 

oracle@acm-691:/tmp/aveksa/MigrationReports> insertMigrationReportDefinitions.sh
Using /home/oracle/Aveksa_System.cfg configuration file to find the target database ...
ORACLE_CONNECTION_ID=AVDB
AVEKSA_USER=avuser
AVEKSA_REPORTS_USER=avdwuser
 
Provide the password for the user avuser: 
Creating required views and reports for migration ...
 
Package created.
 
No errors.
 
Package body created.
 
No errors.
 
View created.
 
View created.
 
View created.
 
View created.
 
View created.
 
View created.
 
View created.
 
View created.
 
View created.
 
View created.
 
PL/SQL procedure successfully completed.
 
Granting privileges on migration report views to reports user ...
 
PL/SQL procedure successfully completed.
 
Provide the password for the reporting user avdwuser:
Creating synonyms for avdwuser user ...
ERROR:
ORA-01017: invalid username/password; logon denied
 
oracle@acm-691:/tmp/aveksa/MigrationReports>

 

Resolution

• Ensure that the insertMigrationReportDefinitions.sh completes without error.  
• Ensure that you have used the correct password for AVUSER and for AVDWUSER.
• Note that the default password for AVDWUSER on a hardware appliance is not the same a the password for AVUSER.  If you are not sure of the passwords in use for the appliance, contact RSA Customer Support and request assistance. 
• On page 11 of the RSA Identity Governance and Lifecycle V7.0.1 Upgrade and Migration Guide, the instructions indicate that when the script completes correctly it should end with a status of Created required reports with Category Migration.

The following shows a successful attempt to run the insertMigrationReportDefinitions.sh:

oracle@acm-691:/tmp/aveksa/MigrationReports> insertMigrationReportDefinitions.sh
Using /home/oracle/Aveksa_System.cfg configuration file to find the target database ...
ORACLE_CONNECTION_ID=AVDB
AVEKSA_USER=avuser
AVEKSA_REPORTS_USER=avdwuser
 
Provide the password for the user avuser: <enter avuser password>
Creating required views and reports for migration ...
 
Package created.
 
No errors.
 
Package body created.
 
No errors.
 
View created.
 
View created.
 
View created.
 
View created. 
 
View created. 
 
View created.
  
View created.

View created.
 
View created.
 
View created.
  
PL/SQL procedure successfully completed.
 
Granting privileges on migration report views to reports user ...
 
PL/SQL procedure successfully completed.
 
Provide the password for the reporting user avdwuser:
Creating synonyms for avdwuser user ...
 
PL/SQL procedure successfully completed.
 
Thu Jan 12 12:44:21 EST 2017
Created required reports with Category Migration
oracle@acm-691:/tmp/aveksa/MigrationReports>

Notes

If you are using an RSA Hardware Appliance and do not know the values for the passwords, contact RSA Customer Support for the default values for AVUSER and for AVDWUSER.