Categories
Export to Excel error for large reports

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
Answers
-
Hi -
Can you provide details from the log: $MW_HOME/instances/{instance_name}/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1/sawlogn.log
Regards,
Charles
0 -
Why OBIEE as a data pump?
0 -
+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
0 -
Thank you - I am trying to get access to the log
0 -
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
0 -
I know... unfortunately this is a client requirement that I am unable to influence
0 -
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
0 -
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>
0