Oracle Analytics Cloud and Server

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

Not able to export all records in Excel and PDF

Received Response
2
Views
5
Comments
Rank 3 - Community Apprentice

While exporting more than 2500 records in pdf and excel, getting below error

There was an error processing your download.

Please check with your administrator.

I changed instancconfig.xml but no luck. changed for all views

<Pivot>

  <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>

  <MaxVisibleColumns>300</MaxVisibleColumns>

  <MaxVisiblePages>1000</MaxVisiblePages>

  <MaxVisibleRows>500</MaxVisibleRows>

  <MaxVisibleSections>25</MaxVisibleSections>

  <DefaultRowsDisplayed>30</DefaultRowsDisplayed>

  <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>

  <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>

  </Pivot>

Can you plese help

Welcome!

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

Answers

  • Hi,

    Did you try searching on here in the forum and Google as well?

    Because this question come at least twice a week, and the answers are always the same ...

    I'm also quite sure MOS has a document or two about this.

  • Rank 3 - Community Apprentice

    I already tried the steps emntioned in Document provided by Oracle by changing instanceconfig.xml file.

    But its not working. Apart from that other workaround I am not able to find in google and MOS.

    Please help

  • Rank 2 - Community Beginner

    WHAT did you change and WHAT did not work?

    If you read the documentation you will see that there are dozens of instanceconfig entries and you can't hust randomly change things without knowing what you change and expect them to magically do what you expect.

  • Rank 3 - Community Apprentice

    I changed below parameter in instanceconfig

      <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>

    And added below parameters in instanceconfig as pe document available

    <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>

      <MaxVisibleColumns>300</MaxVisibleColumns>

      <MaxVisiblePages>1000</MaxVisiblePages>

      <MaxVisibleRows>500</MaxVisibleRows>

      <MaxVisibleSections>25</MaxVisibleSections>

    But its throwing error while exporting in pdf or excel format if record count more than 2500

    There was an error processing your download.

    Please check with your administrator.

    Please suggest then what parameter I suppose to change so that I can export report with more than 2500 records in pdf or excel format.

  • Rank 2 - Community Beginner

    Again - have you looked at the documentation?

    https://docs.oracle.com/middleware/12213/biee/BIESG/GUID-FF6954BA-2DE0-4422-BA58-05F32936F4FF.htm#BIESG1719

    That param exists for 3 view types BUT by far not the only one governing your "issue"

    It's not just about rows. It's also about columns, cells, JH throughput limits etc etc.

    As Gianni said we discuss this every single week in here since almost every single time peoplejust look for "set A to 42" answers and dont think about what actually happens when then DO set A to 42 and WHAT ELSE can influence their desired output.

Welcome!

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