New Business Service and Business Transactions are not visible under Introscope.

Products

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

Issue/Introduction

 New Business Service and Business Transactions are not visible under Introscope. 

 In the CEM console, the TIM Collection Services (both RTTM Collection Service and Transaction Discovery Service) are neither running nor stopped. The service status is "In Progress". Restarting the Enterprise Managers on both Collectors and MOM does not help. The "In Progress" status still persists. The Start and Stop buttons are not available to click. This is preventing from running any Automatic Transaction Discovery sessions as well as not sending any RTTM-related data to the EM.

Environment

All Supported APM releases running CEM

Resolution

Check the status of the EM services in the database, then follow the steps below: This change will be then reflected in the GUI.

 

Run the following SQL statement:

select ts_monitors.ts_name, ts_child_services_def.ts_name,

ts_monitor_child_service.ts_started from ts_monitors,

ts_child_services_def, ts_monitor_child_service where

ts_monitor_child_service.ts_child_service_id=ts_child_services_def.ts_id

and ts_monitor_child_service.ts_monitors_id=ts_monitors.ts_id;

 

After doing this, then modify the ts_started field of the

ts_monitor_child_service table to a 0 if the service is stopped or

a 1 if the service is started.

 

This is a sample output for one TIM:

apmTIMCollectorHost,Defect.Collection.Service,1

apmTIMCollectorHost,Recording.Collection.Service,1

 

apmTIMCollectorHost,Events.Collection.Service,1

 

apmTIMCollectorHost,Hourly.Collection.Service,1

 

apmTIMCollectorHost,RTTM.Collection.Service,2

 

apmTIMCollectorHost,Transaction.Discovery.Collection.Service,2

 

apmTIMCollectorHost,Login.Collection.Service,1

 

 

Transaction Discovery Service for the TIMs should report a value of 2.  Then set to 0 for any values showing as 2 or 1.

 

If any of the other services appear in this state , then also make the above change.

 

 

 

Here's an example of the UPDATE SQL used to fix customer's table in 9.0.7.0:

 

update ts_monitor_child_service set ts_monitor_child_service.ts_started = 0

where ts_id in (

select

ts_monitor_child_service.ts_id

from ts_monitors,

ts_child_services_def,

ts_monitor_child_service

where

ts_monitor_child_service.ts_child_service_id=ts_child_services_def.ts_id

and ts_monitor_child_service.ts_monitors_id=ts_monitors.ts_id

 

and ts_monitor_child_service.ts_started = 2); commit;