OBIEE 11g Error: "Excel found unreadable content" When Exporting to Excel 2007+ (Doc ID 1567582.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.
**Updated 16-Oct-2014**

Symptoms

Exporting a report with a large amount of rows to Excel 2003 works fine
However, when trying to export the same analysis to Excel 2007+ the following error occurs when you try to open the Excel file:

Error: "Excel found unreadable content in 'Untitled Analysis.xlsx'. Do you want to recover the contents of this workbook?"


When clicking 'Yes' file opens but data is missing.

The following error is reported in the sawlog.log:

oracle.xdo.XDOIOException: com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException
at oracle.xdo.template.fo.FOProcessingEngine.process(FOProcessingEngine.java:417)
at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1220)
at com.siebel.analytics.web.javahostrpccalls.xmlp.XmlpAbstractRpcCall.processMessageInternal(XmlpAbstractRpcCall.java:71)
at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:251)
at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:193)
at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)
at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:207)
at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:155)
at java.lang.Thread.run(Thread.java:662)  

An error log file is created in C:\Documents and Settings\eyorav\Local Settings\Temp that contains the following:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLogxmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error090080_01.xml</logFileName>
<summary>Errors were detected in file 'D:\Temp\BigTable.xlsx'</summary>
<additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info></additionalInfo></recoveryLog>  

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