OBIEE

OBIEE 12c: Error While Downloading To Excel – There was an error processing your download. Please check with your administrator

In OBIEE 12c version 12.2.1.1.0 and later, when you try to export a large dataset to excel, you got the following message:

Error While Downloading To Excel – There was an error processing your download. Please check with your administrator.

and the downloaded Excel is incomplete.

To solve this issue you must edit the  Config.xml located in the Domains/BI/config/fmwconfig/biconfig/OBIJH folder.

Check the tag <XMLP> and edit as follow:

<XMLP>
<InputStreamLimitInKB>2048000</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>
</XMLP>

Stop and restart BIEE services and retry to export the excel file.

3 Comments

  • Jagan Mohan

    Hi ,

    We had increased the input stream limit. Still we are facing the issue.

    Kindly suggest any other solution.

  • Srilatha Bollapally

    We are still facing similar issue after increasing the Inputstream size. Can you please suggest if this issue got fixed for you.

    • michele

      With which version are you working? Try to edit the instanceconfig.xml file located in

      /bi/domain/fmw/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/

      (or equivalent folder, depending on your version)
      and edit the “Pivot” section in the xml file:

      <Pivot>
      <DisableAutoPreview>false</DisableAutoPreview>
      <DefaultRowsDisplayedInDownload>25000</DefaultRowsDisplayedInDownload>
      <DefaultRowsDisplayedInDelivery>25000</DefaultRowsDisplayedInDelivery>
      <MaxCells>1000000</MaxCells>
      </Pivot>

      DefaultRowsDisplayedInDownload is the maximum number of row downloaded as excel file, MaxCells is the maximum number of rows downloaded at data file.
      Also change values in the “Table” section of your instanceconfig.xml:

      <Table>
      <DefaultRowsDisplayedInDownloadCSV>250000</DefaultRowsDisplayedInDownloadCSV><DefaultRowsDisplayedInDownload>25000</DefaultRowsDisplayedInDownload><DefaultRowsDisplayedInDelivery>25000</DefaultRowsDisplayedInDelivery><MaxCells>1000000</MaxCells>
      </Table>

      Stop and restart services.

      Regards.

Leave a Reply