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)
- outdated java_jre package
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.
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.