Unable to login to UMP

Document ID : KB000037278
Last Modified Date : 12/11/2018
Show Technical Document Details
Issue:

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:
UIM and UMP 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"