Table Description
Process Instance WDO Data Overflow: One element of a sequence that, when combined, form a complete instance of a Workflow Data Object for a Process Instance.

The Workflow Engine stores Workflow Data Object values in Process Instance WDO Data records. These records contain an XML string describing the Workflow Data Object, its attributes and the current values of those attributes for a given Process Instance. If the XML string exceeds 3900 characters, it is broken up into a sequence of strings, each with a maximum length of 3900 characters. These strings are then stored as overflow records.

When the Workflow Engine attempts to retrieve a Workflow Data Object value, it reads the XML string from a Process Instance WDO Data record and appends any associated overflow records.

Example

You define a workflow (Process Definition) to allow correspondence to be sent to customers whenever their payment details change. The activities defined in your workflow are:

  • system prints out a letter (automatic); and
  • User puts the letter in an envelope and posts it (manual).

Person John Smith's payment details change due to an increase in rates. This increase raises an event which causes the Workflow Engine to enact your workflow and create a Process Instance.

The Process Definition defines values that are required in order to enact a Process Instance. These provide initial values for some Workflow Data Objects. The system constructs an XML string for one of these Workflow Data Objects. The string is 8,000 characters long. The system breaks this string up into two blocks of 3900 characters and one of 200 characters. It persists the first block in a Process Instance WDO Data record. It then persists the second and third block as sequential overflow records.

The system transitions to the first activity definition in your workflow - printing out a letter. This activity calls a method that prints the letter. The method requires the Person's name (John Smith) to be passed in. The Workflow Engine reads the Process Definition and establishes that this information is held in the PersonInfo Workflow Data Object. It reads the first part of the PersonInfo XML string from the corresponding Process Instance WDO Data record. It then appends the two overflow records in sequence. This re-forms the original XML string, thereby allowing the Workflow Engine to access the PersonInfo Workflow Data Object and retrieve the value for the personName attribute.

Technical Notes

See the Workflow Reference Guide for further information.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Attributes (5)
AttributeKeyNullableDescriptionDDL Type
processInstanceIDYesNoThe unique identifier of a workflow process instance within the workflow engine.SVR_INT64
wdoNameYesNoThe name of a workflow data object.SVR_STRING<75>
sequenceNoYesNoThe sequence number used when compiling WDO snapshot data from the overflow table.SVR_INT32
wdoSnapshot  The XML string representing the WDO attributes and their values associated with this WDO.SVR_STRING<3900>
lastWritten   SVR_DATETIME
Foreign Keys (1)
ChildParent
ProcInstOverflow.processInstanceIDProcessInstance.processInstanceID
Related Pages (18)