Use the Retry Errored Workflow Activities (FNDWFRET) concurrent program to retry activities with a status of ERROR for a particular item type. You can retry all errored activities for that item type, or you can choose to retry only activities for a particular work item of that item type, activities for a particular process within the item type, or instances of a particular activity node within the item type. You can also choose to retry only activities that encountered errors during a particular range of dates.
The program calls the WF_ENGINE.HandleError API to reexecute each errored activity and continue execution of the process from that activity. See: HandleError.
Use Standard Request Submission to run this program, specifying the following parameters.
Item Type - Select the item type to which the activities to retry belong.
Item Key - Optionally, to retry only activities that belong to a particular work item, select the item key that identifies that work item within the item type. The list of values includes only item keys for work items that have activities with a status of ERROR.
Process Name - Optionally, to retry only activities that belong to a particular process within the specified item type, select the process name. The list of values includes only processes that have activities with a status of ERROR.
Activity Label - Optionally, to retry only instances of a particular activity node, select the label name of that activity node. The list of values includes only activity nodes that have instances with a status of ERROR.
Errored On or After - Optionally specify the earliest error date for the activities to retry.
Errored On or Before - Optionally specify the latest error date for the activities to retry.
Note: If you previously retried an activity and that attempt still encountered an error, then the error date for the activity is the date when it was most recently retried, rather than the date of the original error.
Maximum Retries - Optionally specify the maximum number of times that the Retry Errored Workflow Activities program can retry a particular activity. For example, if you schedule this program as a recurring request, then you can set this parameter to limit automatic retries for activities that may need manual intervention to resolve the errors. The highest value you can specify for this parameter is 99. The default value is 5.
Note: You can still retry an activity manually using the Status Monitor, Workflow Manager, or WF_ENGINE.HandleError API, even after the Retry Errored Workflow Activities program reaches its maximum number of retries.
Perform Commit - Optionally select Yes or No to indicate whether to commit data while retrying activities. If you want the program to commit data as it retries activities to reduce rollback size and improve performance, select Yes. If you do not want to perform automatic commits, select No. The default value is Yes.
See: Running Reports and Programs, Accessing the Administrator Monitor, Errored Work Items, and Wfretry.sql.