This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

View Execution Logs & Details#

The View Execution Run Logs (VMEX) screen is used to show the executions of reports / update processes and any execution run logs that they had produced.

The MEX ID is indicated in the top left hand corner of the screen. Also indicated, is the name of the process, the user and the date when this process was run.

Each line is information written out by the system specifically for the purpose of debugging problems. The Message and Text contain the information required for deciphering and debugging the issues.

This function is for viewing purposes only; you may not edit the data. This is an important screen for debugging purposes. It allows you to verify whether or not a process ran correctly. Each time a process is run, a log is generated. If an error occurred, the log can be reviewed in VMEX to obtain the reason as to why the error occurred. The information written out here is often of a technical nature and may not be meaningful to the average user but is aimed at a more technical user who is trying to resolve a problem with a work flow.

Each line of the process is indicated, therefore by simply going through each line, one can identify where an error occurred.

Each time a process is run, an Execution ID is created (i.e. MEX ID 178309). This ID is important, so that when you go to VMEX, the correct Execution Log is being reviewed. For work flow tracing this is generated behind the scenes and you won't know it until opening VMEX.

To view the error in its entirety, click on the line and view the information contained in the "Message" field.

The definition data for the View Execution Run Logs screen is stored in the P2K_AM_EXECUTIONS, P2K_AM_EXECUTION_RUN_LOGS, P2K_AM_PARAMETER_VALUES and P2K_AM_EXECUTION_AUDITS tables.

MEX ID

This field provides the execution ID created when a process is run.

Process

This field indicates the process that was run (i.e. P2k_pmwrkflw this refers to a workflow action).

User

Status

Destination Format

Destination Type

Start Date

End Date

Report Mode

Job Name

Destination

Destination Name

Run Logs tab#

Log ID

The ID of the execution run log record.

Process

Context 1

Text

This field provides the actual details of what the process was trying to do.

Timestamp

This field is used to display the day and time of the run log.

Trace Level

Error Level

Context 1/Context 2

Message Code

This field provides the error in its entirety.

Run Log Text

This field that allows you to add notes for the run log.

Parameters tab#

Parameter Name

Prompt

Value

Tables Changed tab#

Table

DML Action

Reference

Changed

CLEANUP