Null Pointer Exception When tasks complete "IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection"
Article ID: 111992
CA Identity ManagerCA Identity GovernanceCA Identity Portal
The problem is the communication between Virtual Appliance and Database.
2018-08-20 15:26:39,704 ERROR [ims.tmt.IMSMessageListener] (Thread-40 (HornetQ-client-global-threads-624110867)) processToEndState: Exception occured during event processing: java.lang.NullPointerException at com.netegrity.ims.task.TaskSessionImpl.enqueueSecondaryEvent(TaskSessionImpl.java:761) [ims.jar:] at com.ca.identitymanager.identitypolicies.IdentityPoliciesStateListener.post(IdentityPoliciesStateListener.java:116) [identitymanager.jar:]
After that we have a SQL connection problem:
2018-08-20 15:34:36,539 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (pool-16-thread-1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:347) ... Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <Host_IP>, port <Database_Port> has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
Virtual Appliance 14.2
The problem is related to a communication problem between Virtual Appliance and Database
Check if the connection with Database is working fine. If some problem was identified, from the Virtual Appliance Dashboard redeploy the Database configuration to update its connection.