WIS_CHECK_STAFFO_RETRY_COUNT

WIS and WQS Process Configuration

Note: This attribute is only applied on configured Oracle RAC.

Summary

This attribute defines the number of times the WIS process attempts to retrieve the unfound work items from the staffo database table because a delay occurred between two Oracle RAC instances.

Applies To

This attribute can be set for the WIS process.

Permissible Values

This attribute must be an integer.

Default Value

The attribute is assigned the following default value when the iProcess Engine node is installed.

Machine ID

Process

Instance

Value

0

WIS

0

3

The default value means the WIS process will retry 3 times if it failed to find the work items from the staffo database table.

Notes

With configured Oracle RAC, a commit transaction is divided into two actions: dequeue the REQUEST instruction by WISMBD and insert the new work items into the staffo table. These two actions are on two Oracle RAC instances. If the dequeue action completes before the committed the new work items to the table is replicated to the second node, the WIS process may not be able to read the work items from the staffo table. To find the new records in the table, you can configure this attribute to define the maximum number of retry times to retrieve the newly added work items.

See Also

RETRY_OFF_FOR_RAC