Not able to export all records in Excel and PDF

1391185

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

Gianni Ceresa

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.

1391185

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

[Deleted User]

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.

1391185

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.

[Deleted User]

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.