The workpoint log has daily occurrences of ORA-02049: timeout: distributed transaction waiting for lock errors in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2018-03-05
Article Number
000040813
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0,+, 7.0.1+, 7.0.2+, 7.1.0+

 
Issue
The workpoint log has daily occurrences of the following error:

      ORA-02049: timeout: distributed transaction waiting for lock
Cause
The configuration settings for distributed lock timeout and associated workflow settings are set too low.
Resolution
To 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

Related Articles

Trending Articles

Don't see what you're looking for?