unable to generate MCS checksums with mcs-cli when using windows database authentication

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I am trying to perform the post upgrade steps provided in the product documentation here:  ( Monitoring Configuration Service ) which states that I should use the checksum utility to transform the profiles and policies from the older 20.x architecture to the new 23.x architecture.

When I run the command given in the documentation:

java  -jar mcs-cli.jar checksum-generator -username <username> -password  <password> uim <primary hub IP Address> >> mcsprofiles_cli_logs.txt

I receive an error:

Exception in thread "main" org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (This Driver is not configured for integrated authentication. ClientConnectionId:  <id>
...
Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-9.4.1.x64 in java.library.path

 

 

 

Environment

DX UIM 23.x upgraded from 20.x 

Database set to Windows (Integrated) Authentication (SSPI)

 

Cause

missing driver

Resolution

1. Locate the file sqljdbc_auth.dll which is located at <UIM HOME>\Nimsoft\lib\
2. Copy (don't move) this file to the appropriate jre\bin folder for the version of JRE which is installed with DX UIM -- e.g. <UIM_HOME>\Nimsoft\jre\jre8u382b05\bin\
3. rename the copied file mssql-jdbc_auth-9.4.1.x64.dll
4. Ensure that you are logged in to Windows using a user that has privileges for the CA_UIM database (if possible, log in with the same user that is configured in data_engine.)
5. Execute the command again, and this time it should succeed.

 

java  -jar mcs-cli.jar checksum-generator -username <username> -password  <password> uim <primary hub IP Address> >> mcsprofiles_cli_logs.txt

Additional Information

Engineering is currently (August 2024) investigating this as a defect but the above steps will work around the issue and allow you to proceed with the checksum creation.