A row is created in the WFTRANSACTIONMSG table under the following conditions:
- The SYS – Custom Log Entry Workflow Action has been executed.
- The Action, Task List, or Rule has the Log Execution check box selected, and the Action, Task List, or Rule is disabled.
The WFTRANSACTIONMSG table is located in DBSpace1.
| Column Name | Data Type | Data Length | Description |
|---|---|---|---|
| wftransactionnum | bigint | 8 | Relates to wftransactionnum column in WFTRANSACTIONLOG table. |
| flags | bigint | 8 | Not used, always zero. |
| wfmessage | char | 250 | Dependent upon the objecttype in the WFTRANSACTIONLOG table (see comments below). |
The index for the WFTRANSACTIONMSG table is located in DBSpace1.
| Index Name | Included Columns |
|---|---|
| wftransactionmsg1 | wftransactionnum, flags |
Comments
The value in the wfmessage column depends on the object type:
| Object Type | wfmessage Value |
|---|---|
| 31 (SYS - Custom Log Entry action) | The text specified in the action’s configuration. |
| 32 (Action execute) | If the action is disabled, the text reads: Action is disabled. |
| 33 (Task list execute) | If the task list is disabled, the text reads: Task list is disabled. |
| 34 (Rule execute) | If the rule is disabled, the text reads: Rule is disabled. |