Issues with downloading to excel OBIEE 12.2.1.2

Khalid Ibrahim

When downloading data that is more than about 1400 rows to excel I get a " There was an error processing your download, Please check with your Administrator" message. I am able to download to csv.

I configured my instanceconfig.xml in the <ServerInstance><Views><Table> area thus. (am unable to copy and paste here)

  <DefaultRowsDisplayedInDownload> 10000000 </DefaultRowsDisplayedInDownload>

Is there anything else I need to do?

Sherry George

Please check the javahost log to see if there are any additional error messages. You might need to increase the 'InputStreamLimitKB' parameter in <ORACLE_HOME>/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH/config.xml as well and give it a try.

Khalid Ibrahim

HI Sherry,

I did that too.. I did both, (in the XMLP section) changing it to zero (supposed to remove all limits) and increasing it to a very high number (2048000), all to no avail.

Sherry George

Did you check the jh logs? That might have some clue.  Also I believe the report is in table view (and not pivot table). I have below, my local instanceconfig.xml settings from 11.1.1.9 for reference.

<Table>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDelivery>100000</DefaultRowsDisplayedInDelivery>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDownload>500000</DefaultRowsDisplayedInDownload>

<MaxCells>1920000</MaxCells>

<MaxVisiblePages>1000</MaxVisiblePages>

<MaxVisibleRows>64000</MaxVisibleRows>

<MaxVisibleSections>25</MaxVisibleSections>

<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>

</Table>

<Cube>

    <CubeMaxRecords>500000</CubeMaxRecords>

    <CubeMaxPopulatedCells>500000</CubeMaxPopulatedCells>

</Cube>

[Deleted User]

Any chance you can fil this thread with some pertinent information as to what exactly was done to remedy the issue and why?

So far it's just random knob-twisting and guess work which doesn't help people in their own error finding process. Plus it's neither scientific nor reproducible.

Khalid Ibrahim

I haven't been able to resolve it yet. Was working on other issues.

If I do come up with a resolution, I will paste it here.

[Deleted User]

What point are you at? What's blocking? WHich component/config?

3410125

Please download the data in csv format in OBIEE and open it directly in excel.

[Deleted User]

That's a workaround but his problem is probably more due to limits in other parts of his config but since @Khalid Ibrahim does not provide and detailed input and seems to have given up we unfortunately can't help him on actually solving this issue.

Khalid Ibrahim

I am dealing with other issues at this point and will get back to this in a couple of days.