Export to Excel error for large reports

3483987

I wonder if anyone could help. We are getting an error when trying to export large reports to Excel in one of our 11g environments. We know it was previously working, which is confusing us. We have checked the maximum number of rows to export settings in both EM and the instanceconfig.xml file, and the max rows is set to 300,000. We get the error when trying to export approx. 40k rows. The problem exists across multiple users, including weblogic. The instanceconfig file is exactly the same as the one we use in another environment, and we don't get the error there.

The error message is "There was an error processing your download. Please check with your administrator".

Export to csv is working fine. Can anyone offer any suggestions?

Many thanks

Charles M

Hi -

Can you provide details from the log: $MW_HOME/instances/{instance_name}/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1/sawlogn.log

Regards,

Charles

Thomas Dodds

Why OBIEE as a data pump?

[Deleted User]

+1000 to Thomas

And to your problem: You are aware that there are tons of different instanceconfig paramater for the whole issue, right?

It's been discussed dozens of time already

3483987

Thank you - I am trying to get access to the log

3483987

Thank you, yes I am aware there are different instanceconfig parameters but we are using the same parameters in instanceconfig in two different environments - one is working fine and one is getting the errors

3483987

I know... unfortunately this is a client requirement that I am unable to influence

[Deleted User]

Well the JH has paramters that go hand in hand with those....so maybe those are out of synch between the envs?

tl;dr - there is some config mismatch

asim cholas

If it is exporting from pivot the maximu number will vary , Even though you habve 30000 limit there you maynot be able to export may nbe 10k records.

<Pivot>

                <DefaultRowsDisplayedInDelivery>9999999</DefaultRowsDisplayedInDelivery>

                <DefaultRowsDisplayedInDownload>9999999</DefaultRowsDisplayedInDownload>

<MaxVisibleColumns>5000</MaxVisibleColumns>

<MaxVisiblePages>2500</MaxVisiblePages>

<MaxVisibleRows>500000</MaxVisibleRows>

<MaxVisibleSections>5000</MaxVisibleSections>

<MaxCells>5000000</MaxCells>

                <DisableAutoPreview>false</DisableAutoPreview>

            </Pivot>

            <Table>

                <DefaultRowsDisplayedInDelivery>9999999</DefaultRowsDisplayedInDelivery>

                <DefaultRowsDisplayedInDownload>9999999</DefaultRowsDisplayedInDownload>

<MaxVisiblePages>2500</MaxVisiblePages>

<MaxVisibleRows>500000</MaxVisibleRows>

<MaxVisibleSections>5000</MaxVisibleSections>

<MaxCells>5000000</MaxCells>

            </Table>