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?

Products

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

Issue/Introduction

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

 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.

Resolution

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

See TEC1321714  -- "New Business Service and Business Transactions are not visible under Introscope" for additional information.