Locating Workflow Policies That Are Deleted or Expired

The examples in this topic can help you determine if rows in the S_ESCL_REQ table exist that are related to a deleted or expired Workflow Policy. For more information, see Tables That Workflow Monitor Agent Uses.

You can enter a query that locates deleted Workflow Policies, for example, as shown in the following procedure.

To locate deleted Workflow Policies

• Run the following query:

  select RULE_ID, count(RULE_ID) from S_ESCL_REQ a
  where not exists (select row_id from S_ESCL_RULE b where a.RULE_ID = b.ROW_ID) 
  group by RULE_ID

You can enter a query that locates expired Workflow Policies, for example, as shown in the following procedure.

To locate expired Workflow Policies

1. Run the following query:

   select a.RULE_ID, b.NAME, count (a.RULE_ID), b.EXPIRE_DT, b.SUB_TYPE_CD 
   from S_ESCL_REQ a, S_ESCL_RULE b
   where a.RULE_ID = b.ROW_ID
   and b.EXPIRE_DT < sysdate
   group by a.RULE_ID, b.NAME, b.EXPIRE_DT, b.SUB_TYPE_CD
   

   Note that sysdate is the Oracle current date and time function. Replace sysdate with the appropriate date and time and time identifier for your database platform.

2. Determine if the Workflow Policies unintentionally expired.

   An example of a Workflow Policy that unintentionally expires is someone forgetting to extend the dates but nobody changed the database triggers since the policy expired.

3. If you determine a Workflow Policy unintentionally expired, and if Siebel CRM must process the rows, then do the following:

   • If the Workflow Monitor is running, and if it is not necessary for you to shut it down, then reverse the expiration of the Workflow Policy. To do this, enter a new date and time in the Expiration Date field for policy. Make sure this date and time is greater than the current date and time.

     The Workflow Policy goes into effect after 10 minutes. This delay occurs because the default for the Reload Policy parameter of Workflow Monitor is 600 seconds.

   • If you require the Workflow Policy to go into effect immediately, then shut down Workflow Monitor if it is running, reverse expiration of the policy, and then start Workflow Monitor.

   You can also do this with a Workflow Policy that includes a duration.