000036108 - The workpoint log has daily occurrences of  ORA-02049: timeout: distributed transaction waiting for lock errors in RSA  Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Mar 6, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036108
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0,+, 7.0.1+, 7.0.2+, 7.1.0+

IssueThe workpoint log has daily occurrences of the following error:

      ORA-02049: timeout: distributed transaction waiting for lock
CauseThe configuration settings for distributed lock timeout and associated workflow settings are set too low.
ResolutionTo resolve these errors, increase the distributed lock timeout and two custom values to the Admin configuration as explained below.
  1. Login to SQL as sysdba.
  2. Run the following command:

SQL> ALTER system set distributed_lock_timeout=305 scope=spfile; 
SQL> commit;

  1. In the UI, navigate to Admin > System > Settings > Edit and scroll to the bottom.
  2. On the Custom tab, add the following two custom values:

  • Set WFSaveRetries custom value to 10.
  • Set WFSaveRetryWait to 3000.

User-added image