Report (Trended Project Metrics) throws RPT-0020 error message

book

Article ID: 197533

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When attempting to run the Trended Project Metrics report, end-users see the following error message:

RPT-0020: Error occurred while downloading the report Trended Project Metrics.  Please contact your system administrator.

Jasperserver.log shows (excerpt):

2020-07-24 14:19:21,519 ERROR ReportExecutionJob,quartzScheduler_Worker-2:363 [] - The report was not completed. An error occurred while executing it.
com.jaspersoft.jasperserver.api.JSException: Error filling report

Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: CSK_PRJ_TrendedMetrics.

Caused by: org.postgresql.util.PSQLException: ERROR: relation "dwh_trd_inv_sum_facts" does not exist

2020-07-24 14:19:21,521 ERROR ReportExecutionJob,quartzScheduler_Worker-2:363 [] - error.generating.report
org.quartz.JobExecutionException: Did not find report result for {paginated: null, maxPageHeight: null, maxPageWidth: null}

Cause

Trending jobs are pending.

Environment

Clarity PPM 15.8.1

Resolution

To configure your own trending data, use the following three jobs:

Create Data Warehouse Trend: To define parameters that establish your new trend, run this initial job. For example, you could create a trend to analyze monthly changes in spending for a particular year.

Update Data Warehouse Trend: To refresh an existing snapshot with new data, run or schedule this job.

Delete Data Warehouse Trend: This job deletes your previous snapshots. You can delete snapshots by specifying a named trend or by entering a specific date or relative date. The job deletes all snapshots in that trend or all snapshots from all trends prior to your selected date.

IMPORTANT: The data warehouse creates all the necessary trending tables only after you run the Load Data Warehouse and Create Data Warehouse Trend jobs.

Additional Information

Data Warehouse Trend Reporting