Designer 10.7 | webMethods BPM Process Development Help | Process Engine Processing | Process Logging Behavior | About Process Audit Logging | Process Audit Log Database Component Tables
 
Process Audit Log Database Component Tables
The Process Engine writes process logging data to the Process Audit Log database component tables shown below. webMethods Monitor uses the information in these tables. For complete information about webMethods Monitor, see the PDF publication webMethods Monitor User’s Guide.
You specify the minimum level of logged data with the quality of service setting Minimum Logging Level for each process model, as described in Setting Quality of Service for a Process.
The following table describes the Process Audit Log database component tables.
Table
Description
WMPROCESS DEFINITION
When a webMethods Monitor user changes a process model version's status, the Process Engine writes a row containing a flag that indicates whether the model version is enabled or disabled.
 
PRA_PROCESS_
CUSTOM
Each time a process starts running, the Process Engine logs a row containing the process instance ID. If you specified a custom ID for a process using the service pub.prt.log:logCustomID, the Process Engine logs a row containing the custom ID.
PRA_PROCESS
If you are logging process statuses, the Process Engine logs a row for each process status.
 
PRA_PROCESS_
STEP
If you are logging step statuses, the Process Engine logs a row for each step status.
Note:
When host or port is changed, the SERVERID column in the PRA_PROCESS_STEP table must be updated manually.
 
PRA_PROCESS_
STEP_LOOP
If you are logging step statuses, the Process Engine logs a row for each step status, containing the process instance iteration, step iteration, and the loop iteration.
 
PRA_STEP_
TRANSITION
If you are logging transitions, the Process Engine logs a row for each transition between steps; that is, it logs the step ID for the beginning and ending step of each transition.
 
PRA_STEP_LOOP_
LOGGED_FIELD
If you are logging step statuses, the Process Engine logs a row for each looping step with its loop iteration (in addition to process instance iteration and step iteration). Logging of custom data and custom looped data are enabled by the values defined on the Logged Fields page in the Properties view in Designer and are not related to the logging level set for the process.
 
PRA_STEP_
LOGGED_FIELD
If you are logging run-time values for specified input or output document fields for process steps, the Process Engine logs a row for each value.
PRA_ERROR
If a step fails, the Process Engine logs a row for the error.
WMSERVICE
If a step calls a service and the service is set for logging, the Integration Server logs the service data.
 
PRA_STEP_
MESSAGE
If a step calls a service and you are logging user-defined messages for that service using the service pub.prt.log:logActivityMessages, the Process Engine logs a row for each message.
 
PRA_STEP_
LOGGED_FIELDS
If you have marked specific step inputs and outputs for logging, this information is stored in this table. The information logged here is not subject to the Minimum Logging Level setting of the process model, but is set on the process model’s Logged Fields page in the Properties view at design-time.
Related Topics