APM Database ts_entity table entries of MOM Primary and Secondary

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• CA Application Performance Management (APM / Wily / Introscope)
• INTROSCOPE
• DX Application Performance Management

Issue/Introduction

When running the SQL Query, seeing the Secondary MOM is not specified correctly:

select external_id, history from (
select vertex_id, count(1) as history from appmap_vertices
where start_time > (sysdate - 5)
group by vertex_id
order by 2 desc) t
join appmap_id_mappings m on t.vertex_id=m.vertex_id
where rownum < 20;

 

EM_MOM:<host>2330@5001
         1

EXTERNAL_ID
--------------------------------------------------------------------------------
   HISTORY
----------

 

EM_MOM:<host>2329@5001
         1

EM_COLLECTOR:<host>2330|<host>2333@5001
         1

EM_CONNECTION:<host>2333

 

<host>2329 is the Primary MOM 

<host>2330 is the Secondary MOM 

 

 

Environment

Release : 10.7.0

Component : APM Agents

Cause

The secondary MOM configured with different roles ;

Please choose either standalone EM , Cluster Single MOM, or Secondary MOM in HA.

It also might have the Master ETC property has been changed  

ts_entity table contains :

Resolution

1. Stop the Enterprise Manager.

2. SQL> delete from ts_entity;
     SQL> commit;

3. Start the EM