ORA-00001: unique constraint (AACG.GRC_PERSP_ITEM_TL_U1) violated error during upgrade From To (Doc ID 2044504.1)

Last updated on AUGUST 25, 2015

Applies to:

Oracle Application Access Controls Governor - Version 8.6.3 and later
Information in this document applies to any platform.


On : version, Install, Migration, Upgrade

Customer upgrades GRC application from to While doing the upgrade facing below error in the grc.log which causes application server not to initialize.


2015-08-10 12:22:43,216 ERROR [Thread-2] DBConfigManager:1010 Error
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (AACG.GRC_PERSP_ITEM_TL_U1) violated
2015-08-10 12:23:17,782 ERROR [Thread-2] DBConfigService:380 Schema initialization failed with error:Unknown Error in the installation/Updating the Schema

The issue can be reproduced at will with the following steps:
1. Upgrade GRC to
2. After upgrade launch the application.
3. Check the grc.log file.

The issue has the following business impact:
Due to this issue, users cannot upgrade GRC application to


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms