event-processing-manager Alert-Consolidation fails to start

Products

• VMware Smart Assurance

Issue/Introduction

After an upgrade, the event-processing-manager Alert-Consolidation service fails to start

Environment

Watch4Net 7.7 

Cause

Missing useSSL flag values in the generic-live-writer.xml and alert-event-archive.xml files.

Out of date table definition in the alert-event.xml file.

Resolution

Update the jdbc connection to utilize the useSSL false flag

1. vi /opt/app/APG/Event-Processing/Generic-Live-Writer/Alert-Consolidation/conf/generic-live-writer.xml
   Update: <datasource url="jdbc:mysql://localhost:53306/events?autoReconnect=true&autoReconnectForPools=true&useSSL=false"
   
   vi /opt/app/APG/Event-Processing/Generic-Live-Writer/Alert-Consolidation/conf/alert-event-archive.xml
   Update: <datasource url="jdbc:mysql://localhost:53306/events?autoReconnect=true&autoReconnectForPools=true&useSSL=false"

Replace the alert-event.xml to allow proper table mapping of the genericevents_live table.

1. Replace:
   

   /opt/app/APG/Event-Processing/Generic-Live-Writer/Alert-Consolidation/conf/alert-event.xml

    

   with updated file which has been attached to this KB.
   
   
2. Restart the event-processing-manager Alert-Consolidation service
   

   /opt/app/APG/bin/manage_modules.sh service restart 'event-processing-manager Alert-Consolidation