000033934 - Unable to save workflow edits or refresh the workflow in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Mar 10, 2017Last modified by RSA Customer Support on Mar 13, 2020
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033934
Applies ToRSA 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

 


User-added image




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.
 


User-added image


 


User-added image


 



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:


 


User-added image
 


Note: The error says for the following reason but no reason follows even after you click on the OK button.


 
CauseThe RSA Identity Governance & Lifecycle database was shutdown while the workflow was being edited.
 
ResolutionRSA Identity Governance & Lifecycle requires the database to be running.
  1. Login as the oracle user
  2. 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.

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

Attachments

    Outcomes