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)
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
Release : 6.6 and 6.7
Component : CA RELEASE AUTOMATION RELEASE OPERATIONS CENTER
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.