The RTTM Service does not start. Instead, it appears to be stuck and the Status is "IN PROGRESS". What should I do to get the Service started?

Document ID : KB000010016
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

 This document describes how to address RTTM Process stuck in "In Progress" issue.

Background:

 The RTTM service in APM can get stuck and display in the APM CEM GUI that the service status is "In Progress". This status persists across multiple restarts of the Enterprise Manager, and the Start and Stop buttons are not available to click.

 

Environment:
Introscope from 9.5x awards.
Instructions:

POSTGRES:

Using a database tool (such as pgadmin III or SQL*Plus), access the APM Database, and look for the table "ts_monitor_child_service".

Check the value of the column "ts_started" - it will have a value of "2".

Option 1:

Use a database tool (such as pgadmin III or SQL*Plus) to access the APM Database, and in the table "ts_monitor_child_service", find the item where the column "ts_child_service_id" is "7", and change the value of "ts_started" to "0" (zero).

Option 2:

Run below query over your Postgres database:

update ts_monitor_child_service set ts_started=0 where ts_started=2;

 

ORACLE:

Using a database tool, access the APM Database, and look for the table "ts_monitor_child_service".

Check the value of the column "ts_started" - it will have a value of "2".

Single Option:

update ts_monitor_child_service set ts_started=0 where ts_started=2;

Additional Information: