Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.