'ORA-00001: unique constraint (AVUSER.IDX_AK_DASHBOARD_COMPONENT) violated' error upgrading to version 7.1.0 of RSA Identity Governance & Lifecycle
Originally Published: 2019-06-18
Last Modified: 2022-06-20
Article Number
Applies To
RSA Version/Condition: 6.x, 7.x
Issue
Initialization operations completed with errors. Please resolve the problem(s) before the application server can accept requests.
Errors found while patching the schema
Errors found while patching the schema
The following errors are seen in the aveksa installation log (/tmp/aveksa-install.log):
[0:00:41 93%] .executing com.aveksa.migration.jdbctool.JavaStepPopulateReports
0 [main] INFO org.hibernate.Version - HHH000412: Hibernate Core {5.0.11.Final}
2 [main] INFO org.hibernate.cfg.Environment - HHH000206: hibernate.properties not found
3 [main] INFO org.hibernate.cfg.Environment - HHH000021: Bytecode provider name : javassist
380 [main] INFO org.hibernate.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
1157 [main] INFO org.hibernate.engine.jdbc.connections.internal.ConnectionProviderInitiator
- HHH000130: Instantiating explicit connection provider: com.aveksa.migration.utils.db.MigConnectionProvider
1177 [main] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: org.hibernate.dialect.Oracle10gDialect
1439 [main] WARN org.hibernate.orm.deprecation - HHH90000018: Found use of deprecated transaction factory setting
[hibernate.transaction.factory_class]; use the new TransactionCoordinatorBuilder settings
[hibernate.transaction.coordinator_class] instead
3582 [main] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1, SQLState: 23000
- ORA-00001: unique constraint (AVUSER.IDX_AK_DASHBOARD_COMPONENT) violated
3582 [main] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper
- ORA-00001: unique constraint (AVUSER.IDX_AK_DASHBOARD_COMPONENT) violated
java.sql.SQLException: com.aveksa.server.db.PersistenceException: Executing JDBC update failed
at com.aveksa.migration.jdbctool.PopulateAvReports.insertNonExistingReports(PopulateAvReports.java:2606)
at com.aveksa.migration.jdbctool.PopulateAvReports.execute(PopulateAvReports.java:83)
at com.aveksa.migration.jdbctool.JavaStepPopulateReports.run(JavaStepPopulateReports.java:17)
at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:211)
at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:107)
at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:98)
at com.aveksa.migration.jdbctool.IncrementalUpdate.update(IncrementalUpdate.java:481)
at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:159)
at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:83)
at com.aveksa.cli.CreateMigrateSchemaModule.runCommandImpl(CreateMigrateSchemaModule.java:211)
at com.aveksa.cli.BaseDatabaseCLIModule.runCommand(BaseDatabaseCLIModule.java:80)
(...)
[0:00:45 96%] executing migration/createPublicSchema.sql
[0:00:45 96%] .executing com.aveksa.migration.jdbctool.JavaStepPublicSchemaViews
[0:01:03 98%] executing Create Scripts/Grant_Select_To_Reports.sql
[0:01:13 98%] executing migration/updateRemoteDB.sql
[0:01:13 98%] .executing com.aveksa.migration.jdbctool.JavaStepUpdateRemoteDB
[0:01:13 98%] executing migration/setVersion.sql
[0:01:13 98%] .executing com.aveksa.migration.jdbctool.JavaStepSetVersion
[0:01:13 98%] executing migration/deleteHotFixes.sql
[0:01:13 98%] executing migration/recompileAll.sql
Cause
Resolution
Related Articles
RSA Identity Governance and Lifecycle 7.2.1 Configuring WildFly Clustering 25Number of Views RSA Governance & Lifecycle 8.0 Patch 05 Release Notes 59Number of Views RSA Identity Governance and Lifecycle 7.1.1 Configuring WildFly Clustering 19Number of Views RSA Identity Governance and Lifecycle IBM Lotus Notes (Domino) collector does not collect group data. 50Number of Views Overview of Public Database Schema Views in RSA Identity Governance & Lifecycle 189Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?