Designer 10.7 | webMethods BPM Process Development Help | Process Engine Processing | About Process Execution | Process Execution Table
 
Process Execution Table
The following table lists the Process Engine database component tables in which the Process Engine stores process execution data, assuming you are not storing these data in server memory.
Table
Contents
PRTINSTANCEITER
Each time a new iteration of a process starts running, the Process Engine writes a row containing the process iteration count.
PRTPROCESS
For each process, the Process Engine writes a row containing the process status and step pipeline. The Process Engine updates the process status after a step or webMethods Monitor user changes the status, and updates the pipeline after each step.
PRTQUEUECONTENT
After each step that produces a process transition document or referenced process document, the Process Engine writes a row containing the contents of the document, minus the pipeline.
PRTSTEPSTATE
For each step, the Process Engine writes a row containing the step status and the external documents, process transition documents, or referenced process documents the Process Engine has received so far, excluding the pipelines.
PRTSTEPSUSPENSION
For each step a webMethods Monitor user suspends, the Process Engine writes a row containing the step ID.
PRTTIMERENTRY
For each timeout configured for a process, the Process Engine writes a row containing the date and time indicating when the affected step or process will time out.
Note:
When host or port is changed, the SERVERID column in the PRTTIMERENTRY table must be updated manually.
PRTUUIDPIDXREF
This table provides persistent storage of document identifiers that Process Engine uses to detect duplicate published input or transition documents. The key for this table is the document UUID. The Process Engine inserts entries into this table when it receives an input or transition document and the user has enabled the duplicate event detection feature.
WMPRTSTORE
After each step, the Process Engine updates a row containing the process thread count.
WMPRTXREF
For each process that uses a correlation ID, the Process Engine writes a row containing the correlation ID. If the process also uses a Trading Networks conversation ID, the row also contains that ID.
Related Topics