All collectors are visible in Workstation Investigator & WebView but some are missing under CEM Setup/Services/Service Configuration & EM Configuration.

Article Id: 35473
Status: Published
Updated On: 14-02-2018 07:39
Legacy Id: TEC1786855
Products:
CA Application Performance Management Agent (APM / Wily / Introscope) , INTROSCOPE
Issue/Introduction:

Symptoms:

All collectors are visible in Workstation Investigator & WebView but some are missing under CEM Setup/Services/Service Configuration & EM Configuration.

The missing collectors are ones where 2 collectors are installed on the same server. In particular on the server running the Tim Collection Service (TCS):

  • When collector2 is started the EM Configuration shows no additional row added for collector2, but does show collector1 port number change to be that of collector2.
  • Messages in both EM logs indicate that TCS seems to be running on both collectors.
  • These Oracle APM DB errors are repeated in collector1 log but stats aggrgation is running without problems and existing ts_us_sessions_map partitions do not have a HIGH_VALUE which overlap with ts_us_sessions_map_20151209_13:

[ERROR] [SessionPartition.Thread1] [Manager.com.timestock.tess.util.DbUtils] Execute failed for SQL DDL 'ALTER TABLE ts_us_sessions_map ADD PARTITION ts_us_sessions_map_20151209_13 VALUES LESS THAN (TIMESTAMP '2015-12-09 14:00:00 -5:00')' 

java.sql.SQLException: ORA-14074: partition bound must collate higher than that of the last partition 

 

Cause:

For the missing collectors, the EM_HOME/config/internal/server/tess.internal.properties file contained a entity.guid that matched the corresponding value for the collector on the same server. That value must be unique for all EMs in the cluster.

The tess.internal.properties file with unique entity.guid is created when the EM first starts and connects to the APM DB. In this case the problem had been caused by duplication of the collecor1 EM installation on same server after collector1 had been started, so the tess.internal.properties had been inadvertently duplicated to the collector2 EM installation.

 

Resolution:

Per TEC1248765 ("Seeing this error in multiple collector logs: Unable to create partition for") :

Stop each collector which has the problem:

Delete the file EM_HOME/config/internal/server/tess.internal.properties

Restart the collector.

Environment:

Release: CEMUGD00200-9.7-Introscope to CA Application-Performance Management-Upgrade Main
Component: