Clarity PPM1

Expand all | Collapse all

Jaspersoft Job Scheduler Error

Jump to Best Answer
  • 1.  Jaspersoft Job Scheduler Error

    Posted 07-26-2019 11:37 AM
    Edited by Matt Guercio 07-26-2019 12:05 PM
    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
    ------------------------------


  • 2.  RE: Jaspersoft Job Scheduler Error

    Posted 08-01-2019 02:14 PM
    Bump, would appreciate any help.


  • 3.  RE: Jaspersoft Job Scheduler Error

    Posted 09-02-2019 09:00 AM
    Edited by Sebastian Ryborz 09-02-2019 09:09 AM
    Hi Matthew,

    please check this: https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=116686

    We got the issue after upgrading from 15.1(js621) to 15.6 (js7.1) - user's permissions (role, folders, report) have not changed, though something seemed
    to get out of sync..we are evaluating the steps above - though we have custom roles in js which makes it tricky to understand what the proposed actions
    could cause.

    or.. just check the permissions on the standard beans (ca ppm bean) - execute was missing for some reason - that helped us.


    Cheers,
    Sebastian





  • 4.  RE: Jaspersoft Job Scheduler Error

    Posted 09-09-2019 11:36 AM
    Hello -
    The folder permissions are setup correctly, Enable Jaspersoft Role Synchronization is turned on, and jobs run nightly.  Do you have another idea?

    Thanks


  • 5.  RE: Jaspersoft Job Scheduler Error

    Posted 09-03-2019 06:59 AM
    Hi Matt

    Sorry missed out this thread, when you run reports from clarity reports and jobs it generates the report in Jaspersoft and gets copied over and if you Jaspersoft folder permission are changed for out of box folders you may get these issues.

    So at the 1st we need to ensure your permissions are set as per document https://docops.ca.com/ca-ppm/15-6-1/en/advanced-reporting-with-jaspersoft/pmo-accelerator-advanced-reporting-content/advanced-reporting-roles-and-permissions

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 6.  RE: Jaspersoft Job Scheduler Error

    Posted 09-09-2019 11:35 AM
    Hello Suman -
    The folder permissions are setup correctly, as CA Support just reset the permissions to OOTB by performing a Content Restore of Advanced Reporting last week.  However, that did not resolve the issue; we are still receiving the error.  Does anyone have any other ideas?  CA Support has not presented a solution yet and we've been discussing with them for months!

    Thank you,
    Matt


  • 7.  RE: Jaspersoft Job Scheduler Error
    Best Answer

    Posted 09-09-2019 11:39 AM
    Hi Matt

    Can you share the case number to me via email Suman.Pramanik@broadcom.com and i will have a look along with the engineer and come back to you

    Regards
    Suman Pramanik

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 8.  RE: Jaspersoft Job Scheduler Error

    Posted 09-09-2019 03:05 PM
    Hello Suman -
    I appreciate your prompt follow up.  I've emailed you the Case Number, and look forward to your response.

    Thanks​