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.
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
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:
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 126.96.36.199:
update ts_monitor_child_service set ts_monitor_child_service.ts_started = 0
where ts_id in (
and ts_monitor_child_service.ts_started = 2); commit;