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
Article Number
Applies To
RSA Product/Service Type: Access Certification Manager (ACM)
RSA Version/Condition: 7.0.2
Issue
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
Resolution
- Download the attached SQL script from a later patch of 7.0.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
- 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
RSA Via Lifecycle and Governance User Interface is inaccessible after rebooting an Appliance with the error "This page can… Number of Views Self-Service Console doesn't display On-Demand Authentication (ODA) link for RSA Authentication Manager 8.x Number of Views The T_AV_ROLE_METRICS table is very large in RSA Identity Governance & Lifecycle Number of Views RSA Authentication Manager 8.x services won't start when network interface adapter eth0 is not found Number of Views Skyhigh Secure Web Gateway (Cloud using Browser Setting) - RSA Ready Implementation Guide Number of Views
Trending Articles
Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA Authentication Manager 8.9 Release Notes (January 2026) AFX Server Fails to Start with 'Could Not Build a Validated Path' and 'Timed Out Waiting for AFX Applications to Start' in… AFX Server stuck in 'Not running' State, with error 'timed out waiting for AFX applications to start' Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
