Clarity

 View Only
Expand all | Collapse all

Tip: Troubleshooting "Access is denied" in CA PPM Jaspersoft Report

  • 1.  Tip: Troubleshooting "Access is denied" in CA PPM Jaspersoft Report

    Posted Nov 08, 2017 07:07 PM

    Hello Everyone,

     

    A quick example of troubleshooting one form of "Access is denied" when running a Jaspersoft Report.


    Scenario

    • An Administration user could run the report
    • The regular user could see the report, but not run it. They could run other reports.

     

    Steps to Reproduce the Error

    • Log in as the user
    • Advanced Reporting
    • Run New Resource Allocations Report and receive:


    Error Details

    The server has encountered an error. Please excuse the inconvenience.

    Error Message

    Access is denied

    • But log in as Administrator, and worked.


    Work Done

    The following Knowledge Document TEC1519137 had been consulted and the two causes it listed ruled out:

    What are the minimum access right(s) required for a CA PPM resource to view jaspersoft Reports?

     

    Checks:

    • ROLE_USER had same rights for the user as the administrator
    • The user was able to access Advanced Reporting and run other Reports successfully.
    • Setup in Reporting looked "essentially right."

     

    Troubleshooting

    1) Hovering with the mouse over the report, gave the path to where it was located, which was in:

     

       \resources\shared\

     

    This was same for both users.

     

    2) Right click and "Export" the non-working Report, AND a working one for the end user that was in the same location and right below it.

    • Non-working: New Resource Allocations Report
    • Working: New Resource Remaining Availability Report

     

    This creates two Zip files in your Downloads folder. You may rename each zip export for clarity.

     

    3) Open up both Exports and Review for differences.

     

    As per the screenshot, after everything was compared, there was a key difference.

    The Administrator had an extra ad_hoc component under their person "users" folder, which was missing from the "shared" folder. See screenshot.

     

     

    Resolution
    Moving this "Custom_Resource_and_Project_OBS_files" from the "users" folder to the "shared" folder allowed everyone with the current right to view this Report to also run it.

     

    This was confirmed by the user.

     

    I hope that this little walk-through may be useful to someone.


    Thanks, Kyle_R.



  • 2.  Re: Tip: Troubleshooting "Access is denied" in CA PPM Jaspersoft Report

    Broadcom Employee
    Posted Nov 09, 2017 02:10 AM

    Thanks Kyle_R for sharing the tip. The Access Denied is because of the way permission is set up at the folder as well as on the report instance too. So moving to different folder can help one customer but not a generic solution. 

     

    Also we recommend not to touch put of box roles provided in Jaspersoft rather create your own role and manage permissions.

     

    Regards

    Suman Pramanik