IDP - sigma portal login not working

Products

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

Issue/Introduction

Need help at the earliest as users are not able to access Sigma Portal.

Environment

Release:
Component: IDMGR

Resolution

Looking on the server log:

There does not seem to be a valid connection to the database.
In front of the IP server there is apache serving jk mod

18:32:29,466 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (http-/0.0.0.0:8080-6) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed. ClientConnectionId:9dd634e2-XXXX-XXXX-89b4-901f9bdd7079". Caused by: java.io.IOException: SQL Server returned an incomplete response. The connection has been closed. ClientConnectionId:9dd634e2-XXXX-XXXX-89b4-901f9bdd7079

18:32:29,480 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/0.0.0.0:8080-6) SQL Error: 0, SQLState: null 18:32:29,480 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/0.0.0.0:8080-6) javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/jdbc/sigmadb

18:32:29,492 ERROR [com.idmlogic.sigma.web.controller.ErrorHandlingController] (http-/0.0.0.0:8080-6) : javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection

Customer restarted the App server to solve the problem.