Process choreographer - structure of the audit trail database views

To read the content of the audit trail, use SQL or any other administration tool that supports the reading of database tables and views.

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:

For a list of the possible audit event type codes, see Process choreographer - audit event types.

The following table describes the structure of the AUDIT_LOG audit trail view. It lists the names of the columns, the event types, and gives a short description for the column. The BPEL column specifies whether the information is also shown in the AUDIT_LOG_B view.


Structure of the process choreographer audit trail database table AUDIT_LOG
Name BPEL PTE PIE AIE VAR CLE SIE Description
ALID x x x x x x x Internal ID and primary key for a row.
EVENT_TIME x 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 x For a list of audit event codes, see Process choreographer - audit event types
PTID x x x x x x x Process template ID of the process that is related to the current event.
PIID x   x x x x x Process instance ID of the process instance that is related to the current event.
PROCESS_TEMPL_NAME x   x x x x x Process template name of the process template that is related to the current event.
PROCESS_INST_NAME x   x x x x x Process instance name of the process template that is related to the current event.
TOP_LEVEL_PI_NAME     x x x x   Name of the top-level process that is related to the current event.
TOP_LEVEL_PIID x   x x x x x Identifier of the top-level process that is related to the current event.
PARENT_PI_NAME     x x x x x Name of the parent process instance.
PARENT_PIID x   x x x x x Process instance ID of the parent process, or null if no parent exists.
VALID_FROM x x x x x x x Valid-from date of the process template that is related to the current event.
ACTIVITY_NAME x     x       Name of the activity on which the event occurred.
ACTIVITY_KIND x   x         Kind of the activity on which the activity occurred. It can have the following values.

For V5-style (FDML) processes:

  • KIND_SUBPROCESS 1
  • KIND_BLOCK or KIND_LOOP 2
  • KIND_EMPTY 3
  • KIND_INVOKE or KIND_JAVA_SNIPPET 6
  • KIND_STAFF 8
  • KIND_EVENT 9

For BPEL processes:

  • KIND_INVOKE
  • KIND_RECEIVE 23
  • KIND_ REPLY 25
  • KIND_TERMINATE 26
  • KIND_WAIT 27
  • KIND_EMPTY 28
  • KIND_WHILE 34
  • KIND_PICK 36
  • KIND_SCRIPT 42
  • KIND_STAFF 43
  • KIND_ASSIGN 44

These are the constants defined for ActivityInstanceData.KIND_*

ACTIVITY_STATE x     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_*

CONTROL_LINK_NAME x         x   Name of the link that is related to the current link event.
IMPL_NAME       x       Name of the activity implementation. This is only applicable for elemental activities.
PRINCIPAL x   x x       Name of the principal that requested the API-call related to the event; applicable for these events (but only if directly called over the API).
TERMINAL_NAME       x       Name of the fault terminal that is set, applicable for ACTIVITY_SET_FAULT_MESSAGE
VARIABLE_DATA x     x       Data for variables for variable updated events.
EXCEPTION_TEXT x x x         Exception message that caused an activity or process to fail. Applicable for:
PROCESS_FAILED
ACTIVITY_FAILED
DESCRIPTION x   x x x x x Description of activity or process, containing potentially resolved replacement variables.
CORR_SET_INFOR x   x         The stringified form of the correlation set that was initialized at process start time.
USER_NAME x   x x       The name of the user whose work item has been changed, applicable for:
  • process instance work item deleted
  • activity instance work item deleted
  • process instance work item created
  • activity instance work item created
VARIABLE_NAME x           x The name of the variable related to the current event.
SIID x           x The ID of the scope instance related to the event.
ATID x   x         The ID of the activity template related to the current event.
OBJECT_META_TYPE   x x x x x x Specifies whether the audit log refers to a BPEL process or an V5-style (FDML) process:
  • 1 for a BPEL process
  • null for an V5-style (FDML) process





Searchable topic ID:   rg5attbl
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/workflow/ref/rg5attbl.html

Library | Support | Terms of Use | Feedback