RETRY_OFF_FOR_RAC

WIS and WQS Process Configuration

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

Summary

This attribute determines whether to enable the retry function that retrieves work items from the staffo database table for configured Oracle RAC.

Applies To

This attribute can be set for WIS and WISMBD process.

Permissible Values

This attribute must be one of the following:

Value

Meaning

0

Switch on the retry function.

1

Switch off the retry function.

Default Value

This attribute is not defined on a newly installed iProcess Engine node. In this case, the default value is:

Machine ID

Process

Instance

Value

0

ALL

0

0

This attribute only appears in the output of the SHOW_ALL_ATTRIBUTES command if you have explicitly assigned a value to it using the SET_ATTRIBUTE command. The default setting is not displayed.

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 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.

If the retry function is enabled, the WISMBD will retry sending messages. Otherwise, the WIS treats it as a withdrawn message and ignores the request. A message similar to the following will be displayed in the WIS log:

1631-WARNING: <no matching entry found in the STAFFO table when the REQUEST message is processed>

In this case, you can set this attribute to 1 to switch on the retry function.

By default, the retry function is enabled. If you need to create many work items that are quickly withdrawn either by the withdraw action or closing case, the work items cannot be retrieved from the staffo database table. To expedite the WIS Mbox processing, you can configure this attribute to switch off the retry function.

See Also

WIS_CHECK_STAFFO_RETRY_COUNT