Jaspersoft Report - Trended Project Metrics

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]
at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:181) ~[jasperserver-api-engine-impl-7.8.0.jar:?]
at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:115) ~[ji-datarator-7.8.0.jar:?]
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f]
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f]
at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f]
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:584) ~[jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f]
at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135) [jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f]
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:959) [jasperserver-api-engine-impl-7.8.0.jar:?]
at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:181) [jasperreports-6.14.0.jar:6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f]
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:910) [jasperserver-api-engine-impl-7.8.0.jar:?]
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1857) [jasperserver-api-engine-impl-7.8.0.jar:?]
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1162) [jasperserver-api-engine-impl-7.8.0.jar:?]
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1103) [jasperserver-api-engine-impl-7.8.0.jar:?]
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:981) [jasperserver-api-engine-impl-7.8.0.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
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.

Additional Information

Data Warehouse Trend Reporting