Unable to obtain Jdbc connection from DataSource after applying latest Patch preventing startup.

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

After upgrading from 6.7.0.124 to 6.7.0.398 Release Automation is not available in the browser and appears to not be starting correctly. 

The Center_Upgrade.log and the nolio_dm_all.log contain the following error which holds the key to this problem:
2021-02-08T09:17:32.360-05:00 [localhost-startStop-1] ERROR (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:268) - Error calling Flyway Migrate
org.flywaydb.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
 at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
... {stack truncated} ...
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:3820b808-1724-4b7a-9cff-189145addca8)
 at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2152)
 at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUtils.java:50)
 ... 272 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:3820b808-1724-4b7a-9cff-189145addca8
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3151)
...
 at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148)
 ... 275 more
Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-8.4.1.x64 in java.library.path
 at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1860)

 

 

Cause

Nolio cumulative fix/build 6.7.2/b168 and 6.6.6/b10304 ships with an updated JDBC driver for MSSQL. Specifically, it uses version 8.4 (mssql-jdbc-8.4.1.jre8.jar) now. This jdbc driver requires an updated authentication DLL to successfully use integratedSecurity.

The version is called out in the error message:
Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-8.4.1.x64 in java.library.path

Environment

Release : 6.6 and 6.7

Component : CA RELEASE AUTOMATION RELEASE OPERATIONS CENTER

Resolution

Please review the error message closely to ensure you are gathering the correct files from Microsoft:
1. Download the 8.4.1 JDBC Driver from Microsoft:
https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver15#previous-releases

 

2. Then using your archive tool of choice unpack and locate the mssql-jdbc_auth-8.4.1.x64.dll from the sqljdbc_8.4.1.0_enu\sqljdbc_8.4\enu\auth\x64\ folder

3. Please the mssql-jdbc_auth-8.4.1.x64.dll in the \CA\ReleaseAutomationServer\bin\ directory and restart.