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

Document ID : KB000003919
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

 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;