Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Last_Run.prpt report is unable to show the value of field "EXECUTION_TIMESTAMP" when connecting to Oracle database

Description

The Last_Run.prpt report under "/public/Pentaho Operation Mart/DI Audit Reports" is not able to show the Date/Time of Execution. This issue happens when Pentaho is configured with Oracle database for repository and for Ops Mart. Please refer the screenshot showing the issue.

Steps to Reproduce

Steps to replicate the issue:

  1. Do a fresh installation of Pentaho 8.0 or 8.1 archive based installation configured with Oracle database for repository.

  2. Configure Operations Mart for DI by following the below link:
    https://help.pentaho.com/Documentation/8.1/Setup/Administration/Performance_Monitoring/Monitor_System_Performance_Using_Pentaho_Operations_Mart/Install_DI_Operations_Mart

  3. Upload a simple transformation and execute it on the server.

  4. Now Update the DI mart by running Public > Pentaho Operations Mart > DI Ops Mart ETL > Update_Dimensions_then_Logging_Datamart job. Because of the issue in jira PDI-17334, you will not be able to run this job directly on the server as this job uses the step "Get Repository Name". To run this job to load the Ops Mart tables successfully, connect to the repository from Spoon and run this job locally.

  5. Run the Last_Run report under "/public/Pentaho Operation Mart/DI Audit Reports"

Workaround

None

Attachments

6

Activity

Show:

Details

Assignee

Reporter

Edit Screen Preamble

<div class="notify info" style="margin-bottom: 10px;">
If you are a Pentaho customer, please use the <a href="http://support.pentaho.com">Customer Support portal</a> to log issues.
<p />
This system is used for logging bugs and enhancement requests only. Please use our <a href="https://community.pentaho.com">community at https://community.pentaho.com</a> if you have questions, configuration issues, or have an issue with a marketplace plugin as Pentaho does not support marketplace plugins unless written by Pentaho.
<p />
Lastly, when creating a bug, please provide as much detail as possible. To prevent unnecessary delays in reviewing your issue, please attach complete server logs, SQL/MDX logs where applicable, schemas, etc. Also, screen-shots and screen-cams are especially helpful in demonstrating the issue.
<p />
Thank-you so much,<br />
The Pentaho Team
</div>

Notice

<div class="notify info" style="margin-bottom: 10px;">
When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
</div>

Story Points

Components

Fix versions

Affects versions

Priority

Created June 25, 2018 at 11:53 AM
Updated March 3, 2023 at 6:45 PM