This topic applies only to the IBM Business Automation Workflow Advanced configuration.

AUDIT_LOG_B view

Use this predefined Business Process Choreographer database view for queries on audit log information for BPEL processes.

Inline tasks are logged in both the AUDIT_LOG_B view and in the TASK_AUDIT_LOG view. For example, claiming an inline participating task results in a TASK_CLAIMED event and an ACTIVITY_CLAIMED event. All other task types are only logged in the TASK_AUDIT_LOG view. Depending on the choices made in IBM® Integration Designer, inline human tasks can also trigger Common Event Infrastructure (CEI) events to be emitted for Business Flow Manager staff activity events and Human Task Manager task events.

Audit events are related to process entities. The audit event types depend on the entity to which the event refers. The audit event types include:

  • Process template events (PTE)
  • Process instance events (PIE)
  • Activity instance events (AIE)
  • Events related to variables (VAR)
  • Control link events (CLE)
  • Scope-related events (SIE).

The following table describes the AUDIT_LOG_B view. It lists the names of the columns, the event types, and gives a short description for the column.

Table 1. Structure of the AUDIT_LOG_B audit trail view
Name PTE PIE AIE VAR CLE SIE Description
AIID x       The ID of the activity instance that is related to the current event.
ALID x x x x x x Identifier of the audit log entry.
EVENT_TIME x x x x x x Timestamp of when the event occurred in Coordinated Universal Time (UTC) format.
EVENT_TIME_UTC x x x x x x Timestamp of when the event occurred in Coordinated Universal Time (UTC) format.
AUDIT_EVENT x x x x x x The type of event that occurred.
ACTIVITY_KIND   x Kind of the activity on which the event occurred. Possible values are:
KIND_EMPTY 3
KIND_INVOKE 21
KIND_RECEIVE 23
KIND_REPLY 24
KIND_THROW 25
KIND_TERMINATE 26
KIND_WAIT 27
KIND_COMPENSATE 29
KIND_SEQUENCE 30
KIND_SWITCH 32
KIND_WHILE 34
KIND_PICK 36
KIND_FLOW 38
KIND_SCRIPT 42
KIND_STAFF 43
KIND_ASSIGN 44
KIND_CUSTOM 45
KIND_RETHROW 46
KIND_FOR_EACH_SERIAL 47
KIND_FOR_EACH_PARALLEL 49
KIND_REPEAT_UNTIL 52

These are the constants defined for ActivityInstanceData.KIND_*
ACTIVITY_NAME     x x Name of the activity on which the event occurred.
ACTIVITY_STATE x State of the activity that is related to the event. Possible values are:
STATE_INACTIVE 1
STATE_READY 2
STATE_RUNNING 3
STATE_SKIPPED 4
STATE_FINISHED 5
STATE_FAILED 6
STATE_TERMINATED 7
STATE_CLAIMED 8
STATE_TERMINATING 9
STATE_FAILING 10
STATE_WAITING 11
STATE_EXPIRED 12
STATE_STOPPED 13

These are the constants defined for ActivityInstanceData.STATE_*
ADDITIONAL_INFO   x x     x The contents of this field depends on the type of the event:
ACTIVITY_WORKITEM_ TRANSFERRED, PROCESS_WORK_ITEM_ TRANSFERRED
The name of the user that received the work item.
ACTIVITY_WORKITEM_ CREATED, ACTIVITY_WORKITEM_ REFRESHED, ACTIVITY_ESCALATED
The list of all of the users for which the work item was created or refreshed, separated by ','. If the list contains only one user, the USER_NAME field is filled with the user name of this user and the ADDITIONAL_INFO field will be empty (null).
PROCESS_EVENT_RECEIVED, SCOPE_EVENT_RECEIVED
If available, the type of operation that was received by an event handler. The following format is used: '{' port type namespace '}' port type name ':' operation name. This field is not set for 'onAlarm' events.
ACTIVITY_CHILD_ PROCESS_TERMINATING

The substate of the activity when the process instance was migrated. Possible values are:

SUB_STATE_NONE (0)
SUB_STATE_EXPIRING (1)
SUB_STATE_SKIPPING (2)
SUB_STATE_RESTARTING (3)
SUB_STATE_FINISHING (4)
SUB_STATE_FAILING (5)
ATID   x The ID of the activity template related to the current event.
CONTROL_LINK_NAME x Name of the link that is related to the current link event.
CORR_SET_INFO x The string representation of the correlation set that was initialized at process start time. Provided with the processCorrelationSetInitialized event (42027).
DESCRIPTION x x x x x Description of activity or process, containing potentially resolved replacement variables.
EXCEPTION_TEXT   x x x Exception message that caused an activity or process to fail. Applicable for:
PROCESS_FAILED
ACTIVITY_FAILED
SCOPE_FAILED
PARENT_PIID x x x x x Process instance ID of the parent process, or null if no parent exists.
PIID x x x x x Process instance ID of the process instance that is related to the current event.
PRINCIPAL x x x x x Name of the principal. This is not set for PROCESS_DELETED events.
PROCESS_APP_ACRONYM x x x x x x The acronym of the process application if the root container is a process application. This is only set if the BPEL process is deployed from the Workflow Center.
PROCESS_TEMPL_NAME x x x x x x Process template name of the process template that is related to the current event.
PTID x x x x x x Process template ID of the process that is related to the current event.
SIID x The ID of the scope instance related to the event.
SNAPSHOT_ID x x x x x x The snapshot ID of the root container, which can be either a process application or a toolkit. This is only set if the BPEL process is deployed from the Workflow Center.
SNAPSHOT_NAME x x x x x x The snapshot name of the root container. This is only set if the BPEL process is deployed from the Workflow Center.
TOP_LEVEL_PIID   x x x x x Identifier of the top-level process that is related to the current event.
USER_NAME x x The name of the user whose work item has been changed. This is applicable for the following events:
  • Process instance work item deleted
  • Activity instance work item deleted
  • Process instance work item created
  • Activity instance work item created
VALID_FROM x x x x x x Valid-from date of the process template that is related to the current event.
VALID_FROM_UTC x x x x x x Valid-from date of the process template that is related to the current event in Coordinated Universal Time (UTC) format.
VARIABLE_DATA   x Data for variables for variable updated events.
VARIABLE_NAME x   The name of the variable related to the current event.