arcuds arcadmin cannot startup with wrong jdbc driver

Products

• CA Advanced Authentication
• CA Strong Authentication
• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)

Issue/Introduction

Symptom:
in arcotuds.log
2022-11-16 00:40:29,266 PST : [main] : INFO  : com.arcot.euds : Logger initialized successfully.
2022-11-16 00:40:29,266 PST : [main] : ERROR : euds.web.UDSInitServlet : [null] : [null] : [31009] : General error - Unable to start User Data Service. Error while checking the bootstrap status.Database error

in arcadmin.log
2022-11-16 00:41:47,376 PST : [Catalina-utility-2] : ERROR : cache.db.CacheRefreshService : Internal error: Unable to read cache refresh state table
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:3c0921b4-da6a-43df-8d42-f2f8ddd4d13f)
 at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) ~[commons-dbcp-1.3.jar:1.3]
 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[commons-dbcp-1.3.jar:1.3]
 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[commons-dbcp-1.3.jar:1.3]
 at com.arcot.common.database.DBManagerImpl.getConnection(DBManagerImpl.java:60) ~[arcot-common-2.3.jar:?]
 at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48) ~[ibatis-2.3.4.726.jar:?]
 at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89) ~[ibatis-2.3.4.726.jar:?]
...
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: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:3c0921b4-da6a-43df-8d42-f2f8ddd4d13f
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3806) ~[mssql-jdbc-11.2.0.jre8.jar:?]
...

Environment

tomcat 9.0.68
openjdk version "1.8.0_352"
strong authentication 9.1.1
windows server 2022
Microsoft JDBC Driver 11.2 for SQL Serverinstall the wrong version of jdbc driver

Cause

Install the wrong version of jdbc driver

Resolution

1. Stop tomcat service
2. Download and install mssql-jdbc-8.4.1.jre8.jar under <TOMCAT-HOME>\lib folder
3. Start tomcat