The workpoint log has daily occurrences of ORA-02049: timeout: distributed transaction waiting for lock errors in RSA Identity Governance & Lifecycle
Originally Published: 2018-03-05
Last Modified: 2023-11-30
Article Number
Applies To
RSA Version/Condition: 7.0,+, 7.0.1+, 7.0.2+, 7.1.0+
Issue
ORA-02049: timeout: distributed transaction waiting for lock
Cause
Resolution
- Login to SQL as sysdba.
- Run the following command:
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:
- Set WFSaveRetries custom value to 10.
- Set WFSaveRetryWait to 3000.
Related Articles
Impersonation error when creating a token using runtimeAPI.createToken 22Number of Views AFX server fails to start with a message: WARNING!! Timed out waiting for AFX applications to start in RSA Identity Govern… 144Number of Views RSA Announces the Availability of RSA Governance & Lifecycle 8.0 Patch 07 HF01 11Number of Views Questions on creating an AFX connector to PostgreSQL using a generic ODBC driver in RSA Identity Governance & Lifecycle 142Number of Views WebSphere clustered server node causes system outages due to 'ORA-02049: timeout: distributed transaction waiting f… 375Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?