OBIEE 11g: Download | Export To Excel Via A Load Balancer Fails With "There was an error processing your download. Please Check with your administrator"

(Doc ID 2167506.1)

Last updated on AUGUST 02, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading from OBIEE 11.1.1.7.x to OBIEE 11.1.1.9.x, when downloading an analysis with 150,000 rows and 33 columns (4,950,000 cells) the following error occurs:

"There was an error processing your download. Please Check with your administrator"

XLSX temporary files are being generated during Analysis export to Excel 2007.
XLSX temporary files keep on changing during the period of download and old XLSX temporary (TMP) entry gets replaced with a new entry.
The export process eventually fails with the following error in the JavaHost log:

Unexpected exception. Connection will be closed java.io.IOException: Broken pipe

Changes

OBIEE upgraded from 11.1.1.7.x to 11.1.1.9.x.

Additional information about the environment:

You have tried the solutions in the following notes with no success:

1595671.1 OBIEE 11g: How To Improve the Functionality of Exporting Data from Analyses, Dashboards, and other Oracle BI Presentation Catalog Objects into Microsoft Excel with OBIEE 11.1.1.7.131017 and Later
1333049.1 OBIEE 11g Infrastructure Performance Tuning Guide Document
1558070.1 OBIEE 11.1.1.7 - New Features, Export Guidance And Recommendations For Working With Microsoft Office
1999106.1 OBIEE 11g - Not Able To Export All Rows From a Report "<div>" Message in the .CSV File And "Maximum total number of cells exceeded" Error in Sawlog.log
1487839.1 OBIEE 11g: Error: "Exceeded configured maximum number of allowed input records. Error Codes: EKMT3FK5:OI2DL65" when Exporting or Opening a Large Report
2128350.1 OBIEE 11g: Active Users are Logged Out One Hour After SSO Authentication via SAML

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms