Null Pointer Exception When tasks complete "IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection"
book
Article ID: 111992
calendar_today
Updated On:
Products
CA Identity ManagerCA Identity GovernanceCA 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.