Copyright © Cloud Software Group, Inc. All Rights Reserved

RETRY_OFF_FOR_RAC

WIS and WQS Process Configuration

This attribute is only applied on 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	Switches on the retry function.
1	Switches 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 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.

If the retry function is enabled, the WISMBD will retry to send message. Otherwise, the WIS will treat it as a withdrawn message and ignores the request. The 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

Copyright © Cloud Software Group, Inc. All Rights Reserved