Null Pointer Exception When tasks complete "IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection"

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

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

 

Environment

Virtual Appliance 14.2

Cause

The problem is related to a communication problem between Virtual Appliance and Database

Resolution

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.