search cancel

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


Article ID: 242465


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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( at  ... 225 more Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling 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: 'ElapsedDays' is not a recognized built-in function name.


Release : 16.0.2

Component : Clarity Jaspersoft


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.