Oracle Analytics Cloud and Server

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

Export to Excel error for large reports

Received Response
104
Views
8
Comments
Rank 2 - Community Beginner

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

Welcome!

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

Answers

  • Rank 6 - Analytics Lead

    Hi -

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

    Regards,

    Charles

  • Rank 8 - Analytics Strategist

    Why OBIEE as a data pump?

  • Rank 2 - Community Beginner

    +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

  • Rank 2 - Community Beginner

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

  • Rank 2 - Community Beginner

    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

  • Rank 2 - Community Beginner

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

  • Rank 2 - Community Beginner

    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

  • Rank 6 - Analytics Lead

    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>

Welcome!

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