Unable to view notifications dashboard

Products

• VMware Smart Assurance

Issue/Introduction

• Unable to view Smarts Notifications in Watch4Net|M&R. Following error seen in Tomcat cas log:

The Spring ContextLoaderListener we wrap threw on contextInitialized.
But for our having caught this error, the web application context would not have initialized.
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ticketRegistry': Injection of persistence dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in ServletContext resource [/WEB-INF/deployerConfigContext.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: CasPersistence] Unable to build EntityManagerFactory

• Global Search in has stopped working.

• SEVERE error while initializing cas webapp.

Environment

All supported releases of Watch4Net/M&R

Cause

In /APG_HOME/Web-Servers/Tomcat/Default/webapps/cas/WEB-INF/deployerConfigContext.xml IP/FQDN of Master DB in JDBC URL set is incorrect.

Resolution

To resolve the issue, modify the deployerConfigContext.xml on the Frontend host as mentioned below:

• Path to file:

   /APG_HOME/Web-Servers/Tomcat/Default/webapps/cas/WEB-INF/deployerConfigContext.xml

• Make sure the file doesn't contain localhost for the following section:

          <constructor-arg value={&quot;url&quot;:&quot;jdbc:mysql://IP|FQDN:53306/masterautoReconnect=true&amp;connectTimeout=20000&amp;maxReconnects=2&amp;u