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

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

book

Article ID: 263847

calendar_today

Updated On:

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.

 

 

Attachments

java_jre-2.1.5_1681315952475.zip get_app