Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

BI Publisher - Interactive report timeout

Received Response
227
Views
7
Comments
Dhavalshah-Oracle
Dhavalshah-Oracle Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

how to increase interactive report timeout in bi publisher

Content

We have a customer with an interactive report that sometimes runs longer than 5 mins.  However, we see BI publisher always returns "ERROR OCCURRED ON RETRIEVING DATA XML" after exactly 5 mins.  how do we bump this timeout value to a higher number?

Tagged:

Answers

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Dhaval.

    I believe you should investigate this issue in more detail. May not be a timeout issue but "bad data" (formatting, invalid number,...)

    You may try to edit the Data Model, go to View Data and run with the same parameters the user is running. If you are lucky, and there is and issue, the error may be on the first 200 rows and you will be able to download the Engine Log.

    Otherwise you may go to Diagnosing and Resolving Issues in Oracle BI Publisher 

    Hope this helps.

    Fernando

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Hello Dhaval,

     

    Without any disregard to Fernando´s reply (cause you should see the logs about the exact cause of the error, and start from there), you have option in Data Model Properties to adjust query execution timeout (default is 600s).

    Here are the links (https://blogs.oracle.com/saas-fusion-app-performance/bi-publisher-data-model-time-out , https://blogs.oracle.com/saas-fusion-app-performance/bi-publisher-data-model-time-out) that you should look and take special atenttion to the notes(warnings) when editing that.

     

    Regards,

     

    Carlos

     

  • Dhavalshah-Oracle
    Dhavalshah-Oracle Rank 1 - Community Starter

    Thank you both for your help and suggestions.  I should have mentioned that we did bump the sql query timeout to a higher value already, and the report does return data in other views (eg. html, pdf, etc) after 6.5 mins.   The issue is that the Interactive View is what the customer wants to use, and it errors out after 5 mins.

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Hello,

     

    And what does the log have regarding that error?

    Can you do another template with bip editor and add one item per turn and test it each time you add a component until you find when it errors? It can be more exhausting than picking with the error stack.

    Regards,

     

    Carlos

  • Mark_Daynes
    Mark_Daynes Rank 6 - Analytics Lead

    If you have an interactive report taking more than five minutes to return data to the screen, then perhaps consider adding additional restrictions to the BIP report.  Can you restict the number of rows being processed somehow to speed it up based on some additional prompts rather than extending the timeout.   

    Regards,

    Mark

  • FPonte
    FPonte Rank 6 - Analytics Lead

    All good Carlos. smiley

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Dhaval.

    If it works on other view then is not "bad data".

    Do you have any formatting on any attribute? 

    I faced similar issues when using some format in dates and numbers (even in the URL property) that caused errors in interactive mode. I didn't spend much time on that to investigate why.

    You will be able to identify the culprit following the steps mentioned by Carlos.

    Regards.

    Fernando