All Account Collectors fail in the step "Indirect Relationship Processing".

1. 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
   
   

    

2. 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

     
3. 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;

init.ora Parameters