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.
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.
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;
The current setting for parallel_degree_policy can be seen in the Oracle Automated Workload Repository (AWR) Report in the init.ora Parameters section.