Unable to add Event Manager Data Source in DX NetOps Performance Management

book

Article ID: 209990

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

After few restarts of the DX NetOps Performance Management Performance Center services there were Event Manager Data Source synchronization failures.

The Performance Center server was rebooted a few times to try and resolve it with no impact.

Then we tried to delete and add back the Event Manager Data Source from scratch but receive "Communication with data source failed" messages.

The last EMService.log before I deleted the data source had some errors like:

"Error creating bean with name 'notificationManager' defined in servletContext
[/META-INF/spring/application.xml]: Cannot resolve reference to bean 'rRep' ....."

Cause

The Event Manager MySql em database became corrupted at some point which prevented successful Event Manager Data Source addition.

Environment

Observed in DX NetOps Performance Management release r3.7.5

Resolution

The first thing to run in an effort to resolve this is the following command. Run it as the root or sudo root installation owner on the Performance Center server. Default installation path shown.

/opt/CA/PerformanceCenter/Tools/bin/npcshell.sh initem --production --dbhost localhost --dbpass <mysql password> --log /tmp/em-db-reinit.log

After that has completed without error run the following to check the values in the MySql em database general table. 

On the PC host go to (default path) /opt/CA/MySql/bin directory. Run the following and enter the MySql DB password when prompted.

./mysql -uroot -p -e "select * from em.general;"

If the ProductID entry and it's value are present, the Event Manager Data Source should be able to be added successfully in the Performance Center web UI.

If the ProductID table entry and value in em.general are missing the Data Source addition will fail. If it's missing it's likely that the general.sql command the npcshell.sh runs is missing the line to add the ProductID value.

To resolve that run the following after the npcshell.sh run to add the value manually.

On the PC host go to (default path) /opt/CA/MySql/bin directory. Run the following and enter the MySql DB password when prompted.

./mysql -uroot -p -e "INSERT INTO general VALUES ('ProductID', REPLACE(UUID(),'-',''));"

Once that completes run the following to validate the ProductID entry and value now is present in the em.general table.

./mysql -uroot -p -e "select * from em.general;"

If yes, we now see the ProductID entry and value in the em.general table, add the Event Manager Data Source in the PC web UI.

Additional Information

Never delete a Data Source unless directed to by Broadcom Support or Engineering. The cause of the error triggering synchronization failure is often resolvable without Data Source deletion and the possible negative impacts Data Source deletion causes.

This is not reproducible in current DX NetOps Performance Management releases. Ensure the latest release is running to avoid similar issues.