Unable to login to OC - wasp error - no Connection available - Login failed for user

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Users are unable to login to UMP even though wasp probe is running

Error captured in wasp.log:

[localhost-startStop-1, org.apache.catalina.core.ContainerBase.[wasp-engine].[localhost].[/reportscheduler]] listenerStart() Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener

[localhost-startStop-1, org.apache.catalina.core.ContainerBase.[wasp-engine].[localhost].[/reportscheduler]] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.interceptor.TransactionInterceptor#0': Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [spring/persistencyConfig.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [spring/persistencyConfig.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available

Error captured in portal.log

[DialectDetector:124] org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user .)
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user '.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

 

 

Environment

Release: UIM any version

Component: OC

UIM and OC installed on separate robots with data_engine probe set to authenticate to Microsoft SQL Server via Windows Authentication

Cause

UMP is unable to login to the Microsoft SQL Server to access the UIM back-end database

Resolution

Solution 1: Set the data_engine probe to authenticate to the Microsoft SQL Server with sa (Microsoft SQL Server System Administrator user) vs windows user.

Example:
A. Launch the data_engine probe configuration for the UIM server, select the Database tab and change the Connection Information to the sa user
Note: Validate that newly enter user credentials with the Test Connection option in the Database tab
B. Deactivate and activate the wasp probe

Solution 2: Configure the UMP "Nimsoft Robot Watcher" service "Log On" with the same windows user defined in the data_engine probe.

Example:
RDP to the UMP host server, launch Windows services, right click on "Nimsoft Robot Watcher" and select properties, Click on the Log On tab and enter the windows user in the "This account" section, restart the "Nimsoft Robot Watcher"