Work with Execution Logs

Owned by Jawann Swislow
Last updated: Jul 09, 2024 by Jawann Swislow
3 min read

Execution logs provide access to summary level logging for Enrichment processing. These can be helpful for confirming Enrichment rules were processed successfully and troubleshooting if the case of errors.

There are three levels of logging as described in the following table. Click the plus sign on the left side of each row to drill down to the level below.

image-20240223-222849.png

Logging Level

Logging Information

Logging Level

Logging Information

Execution History
(Highest Level)

This is the default view when the Execution Log window is opened. Execution History logging provides the following information:

  • User name for submit

  • Start time

  • End time

  • Duration

  • Fund mode (all funds vs. user specified)

  • Categories (holdings, cash activity, both)

  • Effective date

  • Number of funds submitted

  • Type

  • Status

  • Number of failures

  • Number of successes

Execution Child History
(Middle Level)

Execution Child History logging provides summary information about the child engine, displayed by engine type: holdings, cash activity or roll forward.

  • Category

  • Start time

  • End time

  • Duration

  • Status

  • Number of funds

  • Number of failures

  • Number of successes

  • Number of rows inserted to database

Execution Job History
(Lowest Level)

Execution Job History provides detailed information about the child engines.

  • Entity ID

  • Number of items processed

  • Number of items enriched

  • Number of synthetic cash items created

  • Number of synthetic cash items enriched

  • Number of failures

  • Original and new position ID (roll forward only)

  • Errors (validation error for missing synthetic asset reference data)

  • Status

Filter Logs

You can filter execution logs.

To filter execution logs:

  1. In Portfolio Data Center, in the left navigation pane, click Portfolio Desk > Enrichment.
    You see the Eagle Enrichment workspace.

  2. Click Execution Log.

    Eagle Enrichment - Execution Log window

  3. Click the Filter link to view log information for a specific fund or effective date.
    You see the Filter Logs dialog box.

    Filter Logs dialog box

  4. Complete the settings on the Filter Logs dialog box. 
    Options include:
    - Funds. You can click All funds to display All funds, or click Specific funds to display specific funds. If you choose to display specific funds, click Add to select funds.
    - Run Dates. Select either an As Of run date, or a Between run date.

  5. Click OK to save your changes.

Purge Logs

Complete the following procedure to delete older execution logs.

To delete older execution logs:

  1. In Portfolio Data Center, in the left navigation pane, click Portfolio Desk > Enrichment.
    You see the Eagle Enrichment workspace.

  2. Click Execution Log.

  3. Click Purge.
    You see the Purge Logs dialog box.

    Purge Logs dialog box

  4. Click OK.
    The system purges logs prior to the selected date.

Refresh Logs

Complete the following procedure to refresh the execution logs.

To refresh the execution logs:

  1. In Portfolio Data Center, in the left navigation pane, click Portfolio Desk > Enrichment.
    You see the Eagle Enrichment workspace.

  2. Click Execution Log.

  3. Click Refresh.
    An updated list of logs appears in the main window.

Log Tables

Execution log data is stored in the tables listed below in the PACE_MASTER database.

  • DE_EXEC_CHILD

  • DE_EXEC_CHILD_ENTITIES

  • DE_EXEC_CHILD_RULES

  • DE_EXEC_ENTITY_PARAMS

  • DE_EXEC_JOB

  • DE_EXEC_JOB_ERRORS

  • DE_EXEC_MASTER

  • DE_EXEC_DIAGNOSTICS

Next Page

Create Enrichment Rules