ODMR_USER_WORKFLOW_ALL

You can query individual workflow node status after the workflow is complete by using the ODMR_USER_WORKFLOW_ALL repository view.

For example, you can query the nodes that failed along with the associated error details, in the last workflow run. Table 8-11 provides more information about this view.

Table 8-11 ODMR_USER-WORKFLOW_ALL Repository View

Column Data Type Description

WORKFLOW_ID

NUMBER

This is the ID of the workflow.

WF_JOB_NAME

VARCHAR2 (261)

This is the Scheduler Job that runs the workflow.

LOG_DATE

TIMESTAMP (6) WITH TIME ZONE

This is the log entry time stamp.

LOG_ID

NUMBER

This is the log entry ID.

NODE_ID

VARCHAR2 (261)

This is the workflow node ID.

SUBNODE_ID

VARCHAR2 (261)

This is the workflow sub node. For example, a Model node in a Build node.

NODE_STATUS

VARCHAR2 (11)

  • RUNNING: Indicates that the node is running.

  • SUCCEEDED: Indicates that the node run has completed successfully.

  • FAILED: Indicates that the node has failed to complete.

  • NOT_STARTED: Indicates that the node is waiting to run.

  • SCHEDULED: Indicates that the node is scheduled to run.

  • PAUSED: Indicates that the node is paused. This is an exception.

  • STOPPED: Indicates that the node run has stopped.

  • STALLED: Indicates that the node has stalled. This is an exception.

SUBNODE_STATUS

VARCHAR2 (30)

Same as Node status

NODE_START_TIME

TIMESTAMP (6) WITH TIME ZONE

This is the workflow node start time stamp.

NODE_RUN_TIME

INTERVAL DAY (9) TO SECOND (6)

This is the node run time.

ERROR_CODE

NUMBER

This is the error code returned by the node.

LOG_MESSAGE

VARCHAR2 (4000 CHAR)

This is the log message generated by the node.

Parent topic: Repository Views