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
Originally Published: 2018-01-26
Last Modified: 2023-11-30
Article Number
000041393
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Product/Service Type: Access Certification Manager (ACM)
RSA Version/Condition: 7.0.2
Issue
The 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.

Cause
There 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.
Resolution
To 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



 
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?