Smarts EPM is not starting

Products

• VMware Smart Assurance

Issue/Introduction

You observe that the Smarts Event Processing Manager (EPM) service fails to start. When you review the EPM logs, you see below errors indicating a failure to initialize or connect to the database:

Could not create connection to database server

Environment

All supported releases of Watch4net|M&R

Cause

This issue occurs because the database hostname or password credentials embedded within the JDBC URL are configured incorrectly in the application configuration files. This prevents the EPM service from establishing a successful connection to the underlying database during the initialization phase.

Resolution

You must audit and update the JDBC URL settings in the specific configuration files to ensure they contain the correct primary database hostname and credentials.

1. Navigate to the configuration directory: /APG_HOME/Event-Processing/Generic-Live-Writer/emc-smarts/conf/

2. Open the following files for editing:

   • my-smarts-archive.xml (only if MySQL is used to store archived events)
   • my-smarts-live.xml

3. Locate the <datasource> or JDBC URL section and verify the hostname and password. Update them as follows:

   • Hostname: Ensure the FQDN or IP matches your primary database server (e.g., jdbc:mysql://####:53306/)
   • Password: Ensure the password matches the database user's current credentials (e.g., password="####")

4. Save the changes to both files.

5. Restart the Smarts EPM service to apply the new configuration: /APG_HOME/bin/manage-modules.sh service restart event-processing-manager emc-smarts

6. Verify that the service starts successfully and remains in a running state.