Unable to save workflow edits or refresh the workflow in RSA Identity Governance & Lifecycle
Originally Published: 2016-09-01
Last Modified: 2023-12-01
Article Number
Applies To
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
Issue
When editing a workflow in RSA Identity Governance & Lifecycle, saving the workflow edits fails with:
Could not get JDBC Connection; nested exception is java.sql.SQLException:
javax.resource.ResourceException: |j000453 Unable to get managed connection for java:/jdbc/avdb
javax.resource.ResourceException: |j000453 Unable to get managed connection for java:/jdbc/avdb
If you try to refresh the workflow using the drop-down Refresh option from the three dots menu, a similar error occurs:
The connection for dsn='jdbc/avdb' is currently unavailable.
If you try to refresh the workflow using the browser refresh option, a different error occurs:
The server login was denied for the following reason:
Note: The error says for the following reason but no reason follows even after you click on the OK button.
Cause
Resolution
- Login as the oracle user
- Shutdown the RSA Identity Governance & Lifecycle application, start the database and then restart the RSA Identity Governance & Lifecycle application
acm stop acm startdb acm start
To avoid this problem in the future, shutdown RSA Identity Governance & Lifecycle or put RSA Identity Governance & Lifecycle into maintenance mode (Admin > System > Maintenance tab) before shutting down the database.
Notes
