CA Identity ManagerCA Identity GovernanceCA Identity Portal
Issue/Introduction
After some time after installation, and without evident reason, CA Identity Governance Jboss Service fails to start , not allowing access to the admin UI Eurekify.log shows the following:
06:59:57,035 INFO [STDOUT] (AlertMonitor) 06:59:57,035 [AlertMonitor] ERROR com.workpoint.monitor.support.AlertMonitorThread - Exception caught while removing monitor rmi://MyServrName:1577/Alert_WPDS_-71ad1fbb:164cddcda80:-7fee com.workpoint.server.ejb.WorkPointEJBException: Unable to get managed connection for jdbc/WPDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/WPDS)
Environment
Identity Governance , applicable to any release Oracle 12c Database JBOSS 6.4 EAP Jasper server 6.2
Cause
By default Oracle users are created with an expiration policy set to 180 days. If not changed, the users used during the installation of CA Identity Governance , e.g. ystem, WPDS, gvm_datawarehouse, will eventually get their password expired and this error will be seen in logs:
Oracle User Password Expired , ORA-28001: the password has expired
Trouble Shooting Steps :
1. Please open the eurekify.log file located at \CA\RCM\Server\eurekify-jboss\server\eurekify\log folder and do a search for this Pattern "Unable to get managed connection for jdbc" Each jdbc is assosiated to a Datasource will indicate the username and password you need to Reset to Resolve the Expired Password condition.
a) if do you see something like this : com.workpoint.server.ejb.WorkPointEJBException: Unable to get managed connection for jdbc/WPDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/WPDS)
You need to review the Username/Password used on \CA\RCM\Server\eurekify-jboss\server\eurekify\deploy\wp-ds.xml file , where you will see something like this
06:59:57,887 WARN [org.hibernate.cfg.SettingsFactory] (main) Could not obtain connection metadata org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/eurekifyDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/eurekifyDS) ... 06:59:57,840 INFO [org.hibernate.connection.DatasourceConnectionProvider] (main) Using datasource: jdbc/eurekifyDS 06:59:57,855 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (main) Throwable while attempting to get a new connection: null org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-28001: the password has expired
You need to review the Username/Password used on \CA\RCM\Server\eurekify-jboss\server\eurekify\deploy\eurekify_sdb.xml file , where you will see something like this :
Using datasource: jdbc/eurekifyReportdbDS 06:59:57,887 WARN [org.hibernate.cfg.SettingsFactory] (main) Could not obtain connection metadata org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/eurekifyReportdbDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/eurekifyReportdbDS)
You need to review the Username/Password used on \CA\RCM\Server\eurekify-jboss\server\eurekify\deploy\reportdb-ds.xml file