UMP USM Failure

Document ID : KB000095174
Last Modified Date : 09/05/2018
Show Technical Document Details
Issue:
After upgrading ump_usm to 8.52 hf15 to support the latest monitoring configuration service changes, the UIM UMP portal fails to start. 

The portal.log showed error:
08 May 2018 22:40:17,044 ERROR [DialectDetector:124] org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".)
Environment:
UIM 8.51SP1 on Windows 2012 with SQLserver database backend
Resolution:
Data_engine was configured with a loopback address rather than ip address.
Change data_engine.cfg line
server = xxx.xxx.xxx.xxx, 1433
to reflect the correct ip address of the UIM database server