Article Content
Article Number | 000033934 |
Applies To | RSA Product Set: RSA Identity Governance & Lifecycle 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 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 | The RSA Identity Governance & Lifecycle database was shutdown while the workflow was being edited. |
Resolution | RSA Identity Governance & Lifecycle requires the database to be running.
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 | Sometimes just restarting the database will appear to work (acm startdb). However, a clean startup is recommended which includes restarting both the RSA Identity Governance & Lifecycle application and the RSA Identity Governance & Lifecycle database. |