The Data Aggregator is not using the correct hostname for CAPC

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration

Issue/Introduction

How to get the Data Aggregator to re-register the proper hostname

WARN | EventPush | 2018-06-21 13:13:05,629 | PhaseInterceptorChain | ache.cxf.common.logging.LogUtils 452 | org.apache.cxf.cxf-api | | Interceptor for {http://netqos.com/nqevents/EventManager}IEventManagerWSService#{http://netqos.com/nqevents/EventManager}Push has thrown exception, unwinding now 
org.apache.cxf.interceptor.Fault: Could not send Message. 

Caused by: java.net.UnknownHostException: UnknownHostException invoking http://badHostname.com:8281/EventManager/EventManagerWS.asmx: badHostname.com

Also by

ERROR | EventPush        | 2021-04-01 05:10:27,247 | EventProducerWS | or.eventproducer.EventProducerWS  945 | a.im.NPCConnector.bundle |       | Failed to push 1200 events: Could not send Message.

Cause

http://<DA>:8581/rest/emregistration lists the incorrect address for Performance Center and Event Manager

Environment

Release: PM 3.7.x ,  NetOps 20.2.x
Component: IMAGGR

Resolution

1. In the CAPC GUI -> Data Sources, edit the Event Manager data source and set the proper hostname 
2. On the CAPC command line, login to mysql: mysql -uroot -pnetqos 
3. UPDATE em.data_sources SET LastEvent = 0, ConsumerID = 0 WHERE sourceid = DASOURCEID;
4. Do an incremental sync of the Data Aggregator data source