Correction: Title should be "Report Scheduler"
Hello -
Users are assigned to PMO Advanced Reporting group, and have Advanced Reporting - Navigate and Advanced Reporting - Report Create access rights. Users are able to run and view reports within Advanced Reporting UI,
however cannot run reports via "Reports and Jobs" page - receiving the error: "RPT-0020: Error downloading the report <Report Name>. Please contact your system administrator."
Jaspersoft is version 7.1, Clarity PPM version 15.6. I've been working with CA Support and we've re-synced the Jaspersoft server with PPM database, but did not resolve the issue. We believe this is due to users not having access to Advanced Reporting Job Scheduler, but we're a SaaS customer so rely on CA Support to troubleshoot log files. Would appreciate help from community as well. Please let me know if you require additional information or have questions.
Stack trace below obtained from "Messages" page in Advanced Reporting UI:
_________________________________________________________________
Subject:
The job failed to execute. Review its parameters.
Date:
Today
Component:
Report Scheduler
Message:
Job: Test schedule report (ID: 1126994208) Report unit: /ca_ppm/reports/project_management/CSK_PRJ_KPIsByProjectType Quartz Job: ReportJobs.job_1126994208 Quartz Trigger: ReportJobs.trigger_1126994205_0 Error Message: The job was not completed. A system error occurred while running it.
Exceptions: org.springframework.security.access.AccessDeniedException: Access is denied at org.springframework.security.access.vote.AffirmativeBased.decide(AffirmativeBased.java:83) at org.springframework.security.access.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:206) at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:60) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy68.getResource(Unknown Source) at com.jaspersoft.jasperserver.multipleTenancy.PathTransformationRepositoryService.getResource(PathTransformationRepositoryService.java:303) at sun.reflect.GeneratedMethodAccessor592.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy68.getResource(Unknown Source) at com.jaspersoft.ji.report.options.metadata.ReportOptionsFacade.loadReportOptions(ReportOptionsFacade.java:232) at sun.reflect.GeneratedMethodAccessor1205.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy91.loadReportOptions(Unknown Source) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.initJobExecution(ReportOptionsExecutionJob.java:57) at com.jaspersoft.ji.remote.dashboard.DashboardExecutionJob.initJobExecution(DashboardExecutionJob.java:59) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:475) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:245) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:46) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
------------------------------
Matt
------------------------------