Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Dhaval Shah
    BI Publisher - Interactive report timeout
    Topic posted July 31, 2018 by Dhaval Shah, last edited September 11, 2019, tagged Packaging & Licensing, Reporting 
    796 Views, 7 Comments
    Title:
    BI Publisher - Interactive report timeout
    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?

    Comment

     

    • Fernando Ponte

      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

      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

       

    • Dhaval Shah

      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

        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

      • Fernando Ponte

        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

    • Mark daynes

      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