Invalid Credentials error displayed during OC login after upgrade to DX UIM 20.4 CUx or fresh OC installation

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

After upgrading to DX UIM 20.4 CUx or fresh OC installation, we are getting an error when trying to login to UMP/OC page for all users.

 

Apr 12 05:36:16:086 ERROR [Catalina-utility-1, com.firehunter.ump.exceptions.DataFactoryException] Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId
Apr 12 05:36:16:086 ERROR [Catalina-utility-1, com.firehunter.ump.exceptions.DataFactoryException] 
Apr 12 05:36:16:086 ERROR [Catalina-utility-1, com.firehunter.ump.exceptions.DataFactoryException] java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId

and

Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-9.4.1.x64 in java.library.path
    at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1867)
    at java.lang.Runtime.loadLibrary0(Runtime.java:870)
    at java.lang.System.loadLibrary(System.java:1122)
    at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:51)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4237)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:88)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4227)

and

Caused by: org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is 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)

Environment

• Release: 20.4 ,23.4
• Component: UIM OPERATOR CONSOLE - WASP & CORE

Cause

- outdated java_jre package

Resolution

This is a known issue and the errors in the wasp log indicate that the java_jre installed on the OC robot is outdated.

Please make sure to upgrade the java_jre to the latest compatible version.

1. From IM or AC select the local archive.
2. Select the java_jre package and make sure it is the latest version and is downloaded and available, e.g., java_jre v2.15.
   
   
   
   
   
3. Drag and drop the java_jre package to the OC robot(s).
4. Confirm the wasp probe is green and has a port and PID on the OC robot.
5. Recheck the wasp.log for the same errors and/or attach it to the case
6. Log in to the OC and verify the issue is fixed.

 

Additional Information

If java_jre is updated and the issue still exist, please try the below steps:

1. Add a parameter to the data_engine (integratedSecurity=SSPI)

2. obtain mssql-jdbc_auth-9.4.1.x64.dll  which can be obtain here:  https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc_auth/9.4.1.x64

3. place this file into /Nimsoft/jre/(version)/bin  folder of the OC robot.

4. restart the robot and try to login again after wasp is up.