Article Number
000039490
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.2.0, 7.2.1
Platform (Other): Oracle Database
Issue
All Account Collectors fail in the step "Indirect Relationship Processing".
- The following error is logged to the aveksaserver.log file.
09/21/2020 08:43:54.400 INFO (Exec Task Consumer#0 - Sequence) [com.aveksa.server.db.persistence.PersistenceServiceProvider] executeCallableStatement giving up after hitting SQLException: ORA-00001: unique constraint (AVUSER.PK_T_EXPLODEDUENTS_ID) violated
- In addition, there may be similar error messages during migration (upgrade).
The following error may occur in the migrate.log.
ERROR at line 1:
ORA-00001: unique constraint (AVUSER.PK_T_MEXPLODEDUENTS_ID) violated
ORA-06512: at "AVUSER.ROLE_MANAGEMENT_PKG", line 5342
ORA-06512: at line 56
- Customers may report non-specific performance issues when conducting intensive database activities such as Reviews.
Cause
When Oracle PARALLEL_DEGREE_POLICY is set to AUTO or ADAPTIVE certain MERGE queries that are used by RSA Identity Governance & Lifecycle to generate unique sequences may result in duplicates. This may occur on any type of Oracle installation but may occur more frequently with Oracle RAC.
Setting PARALLEL_DEGREE_POLICY to AUTO or ADAPTIVE has the potential to decrease the query time for specific queries but may also increase the time for other queries. RSA recommends setting this to MANUAL for overall performance.
Resolution
RSA recommends Oracle PARALLEL_DEGREE_POLICY be set to MANUAL.
The following command line sets Oracle Parallelism to manual and is effective immediately (does not require a restart of Oracle):
ALTER SYSTEM SET PARALLEL_DEGREE_POLICY=MANUAL SCOPE=BOTH;
Notes
The current setting for parallel_degree_policy can be seen in the Oracle Automated Workload Repository (AWR) Report in the init.ora Parameters section.
init.ora Parameters
| Parameter Name | Begin value | End value (if different) |
|---|
| parallel_degree_policy | MANUAL | |
