000039490 - Incorrect setting for Oracle PARALLEL_DEGREE_POLICY causes issue in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Dec 18, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000039490
Applies ToRSA 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".



  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.
 

 



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

Attachments

    Outcomes