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

[#1]

Article Number

000036108

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;

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

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

Image description