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

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

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

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

Don't see what you're looking for?

Related Articles