Avoiding Excessive Records in the S_WF_PROP_VAL Table

The S_WF_PROP_VAL table stores the values of the process properties for a Workflow Process. When a Workflow Process runs, Siebel CRM creates records in the S_WF_PROP_VAL table along with a new S_WF_STEP_INST record.

The S_WF_PROP_VAL table might become very large over time because a Workflow Process typically contains five or more process properties. As a result, Siebel CRM might add five records to the S_WF_PROP_VAL table for each Workflow Process instance. If you enable Persistence on a large number of Workflow Processes, then the S_WF_PROP_VAL table might become very large. To avoid this situation, you can disable persistence on your custom Workflow Processes.

To avoid excessive records in the S_WF_PROP_VAL table

• To disable persistence, set the Auto Persist property to NO on your custom Workflow Processes.

  For more information, see Configuring Events.