Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

executeUpdateTemplateForReport Failure: user has no access to report

Received Response
11
Views
3
Comments
BarryB
BarryB Rank 1 - Community Starter
edited Oct 10, 2024 1:13PM in Oracle Analytics Publisher

My use case is that I'm creating a way to download a template (which I can do), but then user can make changes to the RTF and update the template. The download is fine.

I'm trying to use ExternalReportWSSService to update a template

image.png

The response, below is "user has no access to report".

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope"><env:Header/><env:Body><env:Fault><env:Code xmlns:env="http://www.w3.org/2003/05/soap-envelope"><env:Value>env:Receiver</env:Value></env:Code><env:Reason><env:Text xml:lang="en-US">PublicReportService::executeUpdateTemplateForReport Failure: user has no access to report["/Custom/Human Capital Management/HR Letters/All Sche Procs Report.xdo"] due to [Ljava.lang.StackTraceElement;@7d3a0abb</env:Text></env:Reason><env:Detail/></env:Fault></env:Body></env:Envelope>

Serina.singh is not a real user..

But when I access the URL with the same Serina.singh account, https://[Our instance]/xmlpserver/, I can browse through.

Doesn't this imply that I DO have access to the report?

image.png

What am I doing wrong?

Tagged:

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @BarryB

    Sometimes cache will play the role , try to clear the cache and try again and see are you able to call with out any Error message.

    1. Navigator -> Report & analytics -> Administration -> Manage BI Publisher > Oracle BI Presentation Services .
    2. Click on the 'Clear' button under BI Subject Area Metadata Cache.

    C. Reload Files and Metadata
    1. Navigator -> Report & analytics -> Administration
    2. From Administrator tab, click on Reload Files and Metadata

    After 22A ExternalReportWSSService?WSDL Is Erring: User *** Does Not Have Permission To Run The Report (Doc ID 2852982.1)

    Regards,

    Arjun

  • BarryB
    BarryB Rank 1 - Community Starter

    Doesn't look like I have permission to do that either.

    image.png

    So what I'm hearing is that what I'm doing is correct (seems improbable!), but there is a fault with the cache on the system and I need to raise a SR with Oracle to sort it out?

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @BarryB

    You can work with your Admin to clear the same.

    Regards,

    Arjun