Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The following error occurs when a user tries to schedule a Dashboard in Advance Reporting.

ERROR SecureExceptionHandlerImpl,JasperServerScheduler_Worker-2:125 [] - There was an error on the server. Try again or contact site administrators.. Byte data not found at: repo:/temp/8c552b76-ffca-4125-a91d-5283efb8b20d.
com.jaspersoft.jasperserver.api.JSException: Error filling report
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1362)

Steps To Reproduce:

In Advanced Reporting - click 'Create' - 'Dashboard'
In 'Existing Content' filter for 'Project Schedule' and drag and drop to the right of the page to create dashlet.
Save the newly created dashboard to a folder
Click on menu 'View' - 'Repository' and navigate to the folder that the dashboard got saved to
Right click on the dashboard and select 'Schedule...'.
Click on 'Create Schedule' and set 'Start Date' to 'Immediately' in the 'Schedule' tab.
Click on 'Save' button to start execution.

Expected Results: Dashboard to schedule successfully
Actual Results: Dashboard scheduling errors out with below stack trace

ERROR SecureExceptionHandlerImpl,JasperServerScheduler_Worker-2:125 [] - There was an error on the server. Try again or contact site administrators.. Byte data not found at: repo:/temp/8c552b76-ffca-4125-a91d-5283efb8b20d.
com.jaspersoft.jasperserver.api.JSException: Error filling report
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1362)

Environment

Clarity 16.1.x, 16.2.x

Cause

DE80944

Resolution

Workaround to fix issue in earlier clarity versions is to follow steps below:

Jaspersoft 8.x

Run Below Query in Jaspersoft Database

update JIObjectPermission set permissionMask = 32 where recipientobjectclass = 'com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole'and recipientobjectid =  (select id from jirole where rolename = 'ROLE_USER') and uri = 'repo:/public/Dashboards/Templates'

update JIObjectPermission set permissionMask = 32 where recipientobjectclass = 'com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole' and recipientobjectid =(select id from jirole where rolename = 'ROLE_USER') and uri = 'repo:/public/Dashboards';

Stop Jaspersoft Tomcat.
Delete Temp and Work Directory in Jaspersoft Tomcat
Go to <Jaspersoft Tomcat>/webapps/reportservice/WEB-INF, Open js.config.properties and provide Jaspersoft URL as deploy.base.local.url. (Ex: https://example.com/reportservice)
Start Jaspersoft Tomcat

Jaspersoft 9.x (Release Announcement)

Run Below Query in Jaspersoft Database

update JIObjectPermission set permissionMask = 32 where recipientobjectclass = 'com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole' and recipientobjectid =(select id from jirole where rolename = 'ROLE_USER') and uri = 'repo:/public/Dashboards/Templates';

update JIObjectPermission set permissionMask = 32 where recipientobjectclass = 'com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole' and recipientobjectid =(select id from jirole where rolename = 'ROLE_USER') and uri = 'repo:/public/Dashboards';

Stop Jaspersoft Tomcat.
Delete Temp and Work Directory in Jaspersoft Tomcat
Go to <Jaspersoft Tomcat>/webapps/reportservice/WEB-INF, Open js.config.properties and provide Jaspersoft URL as deploy.base.local.url. (Ex: https://example.com/reportservice)
Start Jaspersoft Tomcat

Additional Information

Note: Post upgrade to Jaspersoft 9.x running please execute the steps mentioned under Jaspersoft 9.x

Jaspersoft Dashboard schedule is failed with Byte Data not found

Article ID: 369656

Updated On: