ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Duplicate MCS database entries have been detected error message when upgrading KB000094159 says it is safe

book

Article ID: 132538

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM) NIMSOFT PROBES

Issue/Introduction

We are trying to upgrade our environment up to 8.51 and will then upgrade to 9.0.2 so we are back in supported versions but when the database preparation is run the above error message is generated. There is only one profile in the database and when we run the MSSQL query in this KB - https://comm.support.ca.com/kb/duplicate-mcs-profile-detected/kb000094159 we get It is safe to upgrade to UIM 8.51

Environment

Release:
Component: UIMINS

Resolution

  • uimserver_ia_install shows
May 20, 2019 11:35:03 AM com.microsoft.sqlserver.jdbc.AuthenticationJNI WARNING: Failed to load the sqljdbc_auth.dll 
2019-05-20 11:35:17,161 ERROR provider.NimDBProviderBase:createConnection:159 [SwingWorker-pool-2-thread-1] - This driver is not configured for integrated authentication. com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
  • v7.0.0.0 of sqljdbc_auth.dll was present in the windows\system32 folder
  • This version was not compatible with the UIM database
  • deleting the file from windows\system32 allows the install to succeed as it used the version in the ...\Nimsoft\lib folder