Oracle Analytics Cloud and Server

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

Error when executing the BIP report

Received Response
102
Views
8
Comments
Rank 2 - Community Beginner

Summary

Error when executing the BIP report

Content

Hi All,

 

I have created a BIP report with RTF template, which works fine most of the time but suddenly stops working with the below error:

 

image

Checked the log but it contains the same Warning with not much details. Any pointers to why and when we get this error?

 

The template is validated and contains no Errors. Sources used in Data Model are SQL and Analysis. The BIP report is placed on a Dashboard and a presentation variable is passed as parameter to the data model and all the reports.

 

Any pointers will really be helpful. Thank you.

 

Version: Oracle Business Intelligence 11.1.1.9.160719

Oracle BI Publisher 11.1.1.9.160719  (build:20160622.0617)

 

 

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    Hello,

    try downloading just the data (XML) files for the same parameters that errored out and run the template locally and check if you get an error ..

    check the bipublisher.log which may shed more light ..

    Hope this helps

    --YG

  • Rank 6 - Analytics Lead

    Use the query builder in BI publisher and see if u can see the data. if you can see the result then it would be a different if u can not see the data results the access to the table should be problem

    also try using different browser which might help you

  • Rank 6 - Analytics Lead

    what is variable your passing and share the sample query of ur report and xml. that would help

  • Rank 6 - Analytics Lead

    Please check the bipublisher.log to get more info on the error. .

  • Rank 2 - Community Beginner

    Hello YG,

    Exporting XML and running locally works fine, generates the output as expected.

  • Rank 2 - Community Beginner

    Thank you. I am able to see the results. Same error on other browsers as well.

  • Rank 6 - Analytics Lead

    any luck with the log file ?

  • Rank 5 - Community Champion

    just try to re-create again report or just delete template rtf file and upload it again.

Welcome!

It looks like you're new here. Sign in or register to get started.