How to disable Statistics Collector?

How to disable Statistics Collector?

book

Article ID: KB0078269

calendar_today

Updated On:

Products Versions
TIBCO BPM Enterprise (formerly TIBCO ActiveMatrix BPM) 4.0.0, 4.1.0, 4.2.0

Description

SC is driven from the EC audit events, generating process instance and work item statistics that can be used to run reports against. Background threads in the BPM node generate these statistics

Stats Collector data is processed as follows - 
- When an event is persisted in EC_EVENT_INT, a request to process statistics for this event is queued into EC_EVENT_TRIGGER
- The SC background thread picks up this request and processes them to the target SC tables - EC_PE_ACTIVITY, EC_USER_ACTIVITY, EC_CASE_STATUS, EC_PE_STATUS & EC_WI_STATUS. 

Note: If data from the above SC tables are not used, then it is safe to disable SC.

 

Issue/Introduction

This article outlines the steps needed to disable Statistics Collector (SC).

Environment

ALL

Resolution

Following steps are required to disable SC - 

1. Disable the SC thread -

In sc.properties, add or modify the property - 
           
         eventProcessorSuspend=true

2. Disable the enqueue of requests in EC_EVENT_TRIGGER - 

In ec-event-rules.xml - 
===============
In default_stagingareatrigger, comment out all messageId's except for BX_TEMPLATE_DEPLOYED

<channel name="default_stagingareatrigger" target="StagingAreaTrigger">
          <rules>
             <rule name="TriggerMessages" ruleOrder="800">
                <filter>
                   <messageIds>
                      .
                      .
                      <messageId>BX_TEMPLATE_DEPLOYED</messageId>
===============