Custom Jaspersoft Reports are not working after new install of JS Report 7.8

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We have installed JS Report 7.8 and imported custom Ad Hoc reports from 7.1 environment . These custom Ad Hoc reports are throwing following error SQL exception error:

com.jaspersoft.jasperserver.api.CacheDatasetException: exception getting dataset from cache at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:144) at  ... 225 more Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select top 200001 concat(case when ((DATEPART(month, "DWH_INV_INVESTMENT"."SCHEDULE_FINISH") >= 10 and DATEPART(month, "DWH_INV_INVESTMENT"."SCHEDULE_FINISH") <= 12)) then ((DATEPART(year,

 

The error log in JS server shows following error:

com.microsoft.sqlserver.jdbc.SQLServerException: 'ElapsedDays' is not a recognized built-in function name.

Environment

Release : 16.0.2

Component : Clarity Jaspersoft

Resolution

The issue is related to only in Ad-Hoc Views that using "nested elapsed days function" and it break after we import/export the reports

Other Ad-Hoc views that are not using the "nested elapsed days function" can be import/export successfully.

--------------------------------------------------------------------------------------------------------------------------------------------

Tibco Update:

we had an issue in the 7.8 JRS which has been fixed in the 7.9 and later versions 

 

Workaround: Rebuild the affected ad-hoc views in your 7.8 JRS to overcome the issue.