Open topic with navigation

TIBCO® BPM Enterprise 5.5.0

# ec_event

The ec_event table holds information about events that have been registered with the Event Collector.

Column Name | Description
--- | ---
event_id | The identifier of the event.
message_category | The category of the message.
message_id | The identifier of the message.
message | The description of the event.
severity | The severity of the event - one of the following: TRACE DEBUG INFO SERVICE AUDIT WARN ERROR FATAL
event_timestamp | The time stamp at which the event occurred.
managed_obj_id | Valid values for this attribute depend on the value of the messageCategory attribute.
principal_id | The unique identifier of the security principal associated with the event.
principal_name | The name of the security principal associated with the event.
managed_obj_name | Valid values for this attribute depend on the value of the messageCategory attribute.
managed_obj_version | Valid values for this attribute depend on the value of the messageCategory attribute.
managed_obj_type | Valid values for this attribute depend on the value of the messageCategory attribute.
managed_obj_status | Status of the managed object.
managed_obj_url | Valid values for this attribute depend on the value of the messageCategory attribute.
managed_obj_details | Valid values for this attribute depend on the value of the messageCategory attribute.
parent_obj_id | Valid values for this attribute depend on the value of the messageCategory attribute.
app_name | For BX (Process Services) events, this is the name of the application that generated the event. For BRM (Business Resource Management Services) events, this is the name of the process that generated the event.
wi_schedule_start | Scheduled start date of the work item associated with the event.
wi_schedule_end | Scheduled end date of the work item associated with the event.
wi_org_ent_list | Offer set for the work item. This is the GUID, entity type, and model version, separated by the tab character. Multiple entities are separated by the newline character.
wi_priority | Priority of the work item associated with the event.
ext_message | Extended message for the message. This will generally contain more information. For example, the failure reason for a failed activity.
retry_time | The time when the failed activity will be retried again.
resource_id | Identifier of the resource associated with the event.
resource_name | Name of the resource associated with the event.
entity_id | Identifier of the organization model entity associated with the event.
entity_type | Type of the organization model entity associated with the event. This must be one of the following values: ORGANIZATION ORGANIZATIONAL_UNIT GROUP POSITION PRIVILEGE CAPABILITY RESOURCE LOCATION ORGANIZATION_TYPE ORGANIZATIONAL_UNIT_TYPE POSITION_TYPE LOCATION_TYPE ORGUNIT_RELATIONSHIP_TYPE POSITION_HELD ORGUNIT_RELATIONSHIP ORGUNIT_FEATURE POSITION_FEATURE PARAMETER_DESCRIPTOR
channel_id | Unique identifier of the presentation channel associated with the event.
app_act_name | Name of the process activity associated with the event. For example, StartEvent, ScriptTask, DBTask, gateway, Success, Failure.
app_act_model_id | The design time identifier of the process activity: the unique identifier of the process activity associated with the event from the model.
app_act_instance_id | The runtime identifier of the process activity: the unique identifier of the process activity associated with the event from the activity instance.
sys_action_comp_id | Identifier of the component that requested a system action check. (Typically this is "BRM".)
sys_action_id | Unique identifier of the requested system action.
root_proc_ins_id | Identifier of the upper-most parent process.
parent_proc_ins_id | Identifier of the parent process associated with the event.
parent_act_ins_id | Identifier of the parent activity associated with the event.
sub_proc_ins_id | Identifier of the sub-process associated with the event.
sub_proc_name | Name of the sub-process associated with the event.
process_priority | Priority of the process instance associated with the event.
module_name | The process package name of the deployed process associated with the event. (This is not set for BRM (Business Resource Management Services) events.)
prior_step_id | Identifier of the previous activity (to the one associated with the event).
sub_proc_ver | Version of the sub-process associated with the event.
model_major_version | Major version number of a case data model.
model_version | Version number of a case model.
role_name | The role name given to a link between two case data classes.
iteration |
iteration_id |
host_task_name |
host_task_type |
interrupts_main_flow |
attribute1 | Value (integer) of this custom work attribute
attribute2 | Value (text) of this custom work attribute
attribute3 | Value (text) of this custom work attribute
attribute4 | Value (text) of this custom work attribute
attribute5 | Value (decimal) of this custom work attribute
attribute6 | Value (date-time) of this custom work attribute
attribute7 | Value (date-time) of this custom work attribute
attribute8 | Value (text) of this custom work attribute
attribute9 | Value (text) of this custom work attribute
attribute10 | Value (text) of this custom work attribute
attribute11 | Value (text) of this custom work attribute
attribute12 | Value (text) of this custom work attribute
attribute13 | Value (text) of this custom work attribute
attribute14 | Value (text) of this custom work attribute
attribute15 | Value (integer) of this custom work attribute
attribute16 | Value (decimal) of this custom work attribute
attribute17 | Value (decimal) of this custom work attribute
attribute18 | Value (decimal) of this custom work attribute
attribute19 | Value (date-time) of this custom work attribute
attribute20 | Value (date-time) of this custom work attribute
attribute21 | Value (text) of this custom work attribute
attribute22 | Value (text) of this custom work attribute
attribute23 | Value (text) of this custom work attribute
attribute24 | Value (text) of this custom work attribute
attribute25 | Value (text) of this custom work attribute
attribute26 | Value (text) of this custom work attribute
attribute27 | Value (text) of this custom work attribute
attribute28 | Value (text) of this custom work attribute
attribute29 | Value (text) of this custom work attribute
attribute30 | Value (text) of this custom work attribute
attribute31 | Value (text) of this custom work attribute
attribute32 | Value (text) of this custom work attribute
attribute33 | Value (text) of this custom work attribute
attribute34 | Value (text) of this custom work attribute
attribute35 | Value (text) of this custom work attribute
attribute36 | Value (text) of this custom work attribute
attribute37 | Value (text) of this custom work attribute
attribute38 | Value (text) of this custom work attribute
attribute39 | Value (text) of this custom work attribute
attribute40 | Value (text) of this custom work attribute
additional_attribs | Value (text) of this custom work attribute

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® BPM Enterprise

Copyright © 2015-2024. Cloud Software Group, Inc. All Rights Reserved.