How to track the filter executed by TIBCO BusinessEvents(BE) query on TIBCO ActiveSpaces (AS)

How to track the filter executed by TIBCO BusinessEvents(BE) query on TIBCO ActiveSpaces (AS)

book

Article ID: KB0082277

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition 5.5.0

Description

You can enable event logging on TIBCO BusinessEvents(BE) Inference/Query members from as-admin to get exact filter submitted to AS when a query is executed from BE.

Issue/Introduction

How to track the filter executed by TIBCO BusinessEvents(BE) query on TIBCO ActiveSpaces (AS)

Environment

All Supported Operating Systems

Resolution

To enable event logging for specific Inference/Query member:
  1. connect to the cluster using as-admin session.
  2. execute command "show members" and record the Member-Name of the Inference/Query agent where the query is being executed
  3. execute command below to enable event logging on the member:
execute on member '<membername>' set event_log log_level 'INFO'
       4. filter information will be recorded in the as-events-<id>.log which is located at (<currentWorkDir>/log/as-events-<id>.log)
       To validate the filter string check for String '"filter" :' in the event log file. e.g:
{"time" : "2018-03-21T10:33:29.501", "thread" : 7584, "level" : "INFO", "module" : "TestSpace", "method" : "Space::getEntryHandlesCount", "msg" : "arg", "filter" : "Prop1 = 'test9834'"}
Note:
Event logging cannot be disabled once enabled. To reduce the output in the event log file, set the log_level to "ERROR":
execute on member '<member_name>' set event_log log_level 'ERROR'