Jaspersoft Report - Trended Project Metrics - throws error message

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:

ERROR AsyncJasperPrintAccessor,pool-7-thread-14:321 [] - Error during report execution
net.sf.jasperreports.engine.JRException: Error executing SQL statement for: CSK_PRJ_TrendedMetrics.

Jasperserver.log shows (excerpt):

2022-09-30T07:02:48,150 ERROR AsyncJasperPrintAccessor,pool-7-thread-14:321 [] - Error during report execution
net.sf.jasperreports.engine.JRException: Error executing SQL statement for: CSK_PRJ_TrendedMetrics.
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:357) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "dwh_trd_inv_sum_facts" does not exist
  Position: 13358
2022-09-30T07:03:08,862 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-10:116 [] - Error filling report

Environment

Clarity PPM 15.8.1 and higher

Cause

Trending jobs are pending.

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.