Synopsis
Records multiple messages in the Error/Detail Log.
Description
Adds the specified multiple messages to the WS_WRK_ERROR_LOG workflow metadata table, which is referred to as the Error Log or Detail Log. A variety of message types are supported such as Information, Warning, and Error that are included in the "detail" message counts for the task and job (viewable via the "Scheduler" tab/window). Error/Detail Log messages are accessible via the "Scheduler" tab/window and/or the WS_ADMIN_V_ERROR view of the WS_WRK_ERROR_LOG table.
Both the Audit Log and Error/Detail Log support similar information and in user-defined custom procedures either or both logs can be used. However in RED-generated procedures/scripts, the Audit Log is used for higher-level or summary messages while the Error/Detail Log is used for more detailed supporting information.
Input
Input | Description |
|---|---|
Common Input | Includes all 5 inputs of the Callable Routines Common Input. |
Error/Detail Message Type Code | Error/Detail Message Type Code:
|
Error/Detail Message(s) Text | Custom message(s) text to be recorded in the WhereScape RED Error/Detail Log. Multiple messages can be specified but each is limited to 256 characters. Each message must be separated by either a new-line (ASCII 10) or tilde (~) character. e.g. Message1~Message2~Message3 will create 3 messages. |
RDBMS Code | RDBMS-specific message code. It is optional but recommended to populate this when an error occurs. |
RDBMS Message | RDBMS-specific message. It is optional but recommended to populate this when an error occurs. |
Custom Message Type Code | Custom Message Type Code. For custom usage and has no meaning within the WhereScape RED metadata. |
Output
Output | Description |
|---|---|
Result Number | Output Result Number:
|