Error while exporting the dashboard in to excel — Oracle Analytics

Oracle Analytics Cloud and Server

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

Error while exporting the dashboard in to excel

Received Response
22
Views
6
Comments
3018071
3018071 Rank 4 - Community Specialist

While trying to export the report in excel format it is showing the following error.

A fatal error occurred while processing the request.

The server responded with: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException.

Answers

  • Lamin J
    Lamin J Rank 4 - Community Specialist

    Hi!

    Have a look at this

    Oracle reference: https://docs.oracle.com/cd/E23943_01/bi.1111/e10541/psconfigset.htm#BIESG103

    Have you checked your logs ?

    B/R Lamin

  • Joel
    Joel Rank 8 - Analytics Strategist

    Approximately how many rows are you trying to export to Excel? By the way, you made no mention of the OBIEE version you're running.

  • 3018071
    3018071 Rank 4 - Community Specialist

    Yes I have done that. and in the log it is showing the same error there.

    the thing is that In UAT it is not showing any error ,only in production the error is there.

    both config files are similar in structure.

  • 3018071
    3018071 Rank 4 - Community Specialist

    Hi Joel,

    OBIEE 11g

    The no of rows wont extend 2-3 lakhs

  • Joel
    Joel Rank 8 - Analytics Strategist

    You say it works in your UAT environment, how many rows does the report generate in your UAT environment compared to Production where you say it generates between 200000 & 300000 rows.

  • Lamin J
    Lamin J Rank 4 - Community Specialist

    What is your current setting for

    <XMLP>

        <InputStreamLimitInKB> ?</InputStreamLimitInKB>

    </XMLP>

    antother test is to set to 0 (Unlimited),restart and then try.

    //Lamin