My Oracle Support Banner

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

Last updated on JANUARY 11, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.9.0 [Release 11g]
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.9.0 [Release 11g]
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.