000035953 - Migration to RSA Identity Governance & Lifecycle 7.0.2 GA fails with the error ORA-00001: unique constraint (AVUSER.UK_T_VIEW_DEF_VIEW_ID) violated

Document created by RSA Customer Support Employee on Mar 3, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035953
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Product/Service Type: Access Certification Manager (ACM)
RSA Version/Condition: 7.0.2
IssueThe database migration to 7.0.2 GA (or P01) can fail with the following error:

ORA-00001: unique constraint (AVUSER.UK_T_VIEW_DEF_VIEW_ID) violated ORA-06512: at line 24

The migrate.log will show the error during the running of the script /home/oracle/wildfly/standalone/tmp/vfs/temp/temp485174e0d2634b4f/content-4ac86bd61b8cb9d2/contents/aveksa.war/WEB-INF/database/Upgrade/Initialization/update/ACM-00092.sql.

Note: The location listed above will be different for every customer and through every ACM restart.

CauseThere was a change in review definition views that affected Group by Application (now called Group by Business Resource in new installations) that will affect customers upgrading from 7.0.1 P05.
ResolutionTo resolve this issue,
  1. Download the attached SQL script from a later patch of 7.0.2.
  2. Rename the downloaded file and replace the original in /home/oracle/database/database/Upgrade/Initialization/update/ACM-00092.sql.  For example:

cp /tmp/ACM-00092-fixed.sql /home/oracle/database/database/Upgrade/Initialization/update/ACM-00092.sql

  1. Then run the migration again, outside the UI:

cd /home/oracle/database
sh migrate.sh