ODMR_USER_WORKFLOW_LOG

You can query the logs of workflow run by using the ODMR_USER_WORKFLOW_LOG repository view.

Oracle Data Miner uses this view to extract and display the workflow event log. Table 8-12 provides more information about this view.

Table 8-12 ODMR_USER_WORKFLOW_LOG Repository Views

Column Data Type Description

LOG_ID

NUMBER

This is the log entry ID.

JOB_NAME

VARCHAR2 (30 CHAR)

This is the Scheduler Job that runs the workflow.

PROJ_NAME

VARCHAR2 (30 CHAR)

This is the project in which the workflow was created in.

PRO_ID

NUMBER

This is the project ID in which the workflow was created in.

WF_NAME

VARCHAR2 (30 CHAR)

This is the workflow name.

WF_ID

NUMBER

This is the workflow ID.

NODE_NAME

VARCHAR2 (30 CHAR)

This is the name of the node in the workflow.

NODE_ID

VARCHAR2 (30)

This is the node ID.

SUBNODE_NAME

VARCHAR2 (30 CHAR)

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

SUBNODE_ID

VARCHAR2 (30)

This is the workflow sub node ID. for example, the Model ID in a Build Node.

LOG_TIMESTAMP

TIMESTAMP (6) WITH TIME ZONE

This is the log entry time stamp.

LOG_DURATION

INTERVAL DAY (3) TO SECOND (0)

This is the log entry duration in days and seconds.

LOG_TYPE

VARCHAR2 (30 CHAR)

WARN: Indicates warning.

ERR: Indicates error.

INFO: Indicates informational content.

LOG_SUBTYPE

VARCHAR2(30 CHAR)

START: Indicates start of a task.

END: Indicates end of a task.

LOG_MESSAGE

NVARCHAR2 (2000)

This is the log message generated by the node.

LOG_MESSAGE_DETAILS

VARCHAR2 (4000 CHAR)

This is the log message details generated by the node.

LOG_TASK

VARCHAR2 (30 CHAR)

When a node is running, it performs one or more of the following tasks:

  • PROJECT

  • WORKFLOW

  • NODE

  • SUBNODE

  • VALIDATE

  • SAMPLE

  • CACHE

  • STATISTICS

  • FEATURES

  • DATAPREP

  • BUILD

  • TEST

  • APPLY

  • TRANSFORM

  • TEXT

  • BUILDTEXT

  • APPLYTEXT

  • OUTPUT

  • CLEANUP

  • CREATE EXPLORE STATISTICS

  • CREATE HISTOGRAM

  • CREATE SAMPLE DATA

  • CREATE HISTOGRAM SAMPLE

  • CREATE DATA GUIDE

  • CREATE PROJECT

  • DELETE PROJECT

  • RENAME PROJECT

  • SET COMMENT

  • CREATE WORKFLOW

  • RUN WORKFLOW

  • RENAME WORKFLOW

  • DELETE WORKFLOW

  • IMPORT WORKFLOW

  • EXPORT WORKFLOW

Parent topic: Repository Views