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 After upgrading RSA Authentication manager to version 8.6, users AnyConnect are not able to authenticate Number of Views Review result fails to save the changes made in RSA Via Lifecycle and Governance with error ORA-00001: unique constraint (… Number of Views Static Routes Number of Views How to obtain the version information for RSA Authentication Agent for PAM installed on Linux Number of Views
Trending Articles
Update an existing RSA Cloud Authentication Service Integrated Windows Authentication (IWA) Connector Identity Provider SA… RSA Authentication Manager 8.9 Release Notes (January 2026) Downloading RSA Authentication Manager license files or RSA Software token seed records RSA Authentication Manager 8.x import of replacement certificate fails with the error This certificate is already imported Artifacts to gather in RSA Identity Governance & Lifecycle
Don't see what you're looking for?
