Siebel Business Process Designer Administration Guide for Financial Services > Monitoring and Tuning Performance > Monitoring Workflow Policies >

Understanding the S_ESCL_STATE Table

Figure 7 shows the S_ESCL_STATE time-based table.

Figure 7. S_ESCL_STATE Table

Click for full size image

The S_ESCL_STATE time-based table contains all the rows that have been executed (all conditions are true) and are waiting for the time duration element to expire.

Use your database tools to monitor the size and efficiency of the S_ESCL_STATE table. If the table becomes very large, this could indicate that the number of policies being monitored is too large for the current number of Workflow Policies processes and a new Workflow Policies process needs to be created to share the load.

If rows are being monitored, but are not being removed after the time interval is met, this could indicate that a policy was deactivated without removing the database triggers. The triggers are continuing to send data that is not being acted on by a Workflow Policies process.

NOTE:  If you expire or delete any active Workflow Policies, confirm that no outstanding records are in the S_ESCL_REQ, S_ESCL_ACTN_REQ, or S_ESCL_STATE tables.

 Siebel Business Process Designer Administration Guide for Financial Services 
 Published: 22 May 2003