My Oracle Support Banner

OBIEE 12c: Export to Excel Fails When the Report Displayed As Link On the Dashboard Page (Doc ID 2505930.1)

Last updated on OCTOBER 29, 2019

Applies to:

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

Symptoms

When trying to export certain dashboard page to Excel, the following error returns:

There was an error processing this download.
Please check with your administrator


STEPS TO REPRODUCE
-------------------------
1. Edit the dashboard page. Reports are aligned horizontally within the same section.
2. Click the properties of the reports.
3. "Display Result" > "Link in Separate Window"
    The report links aligned horizontally.
4. Export to Excel

When "Display Result" set as "Embedded in Section" or "Link within the Dashboard" then, the issue does not reproduce.
Also, when report links are aligned vertically, the issue does not reproduce.

 

LOG
------------
You can also see the errors in java host log: <DOMAIN_HOME>/servers/obijh1/logs/jh.log
----------------------------------------------------------------------------------------------------
[2018-11-12T17:01:11.267+09:00] [xmlp] [WARNING] [] [saw.xmlp] [tid: <TID>] [ecid: <ECID>] Error[[
java.lang.ClassCastException: oracle.xdo.template.fo.elements.table.FOTableRow cannot be cast to oracle.xdo.template.fo.elements.table.FOTableCell
at oracle.xdo.template.fo.elements.table.TableColumnInfoServer.countCells(TableColumnInfoServer.java:680)
at oracle.xdo.template.fo.elements.table.TableColumnInfoServer.fillColumnInfo(TableColumnInfoServer.java:595)
at oracle.xdo.template.fo.elements.table.TableColumnInfoServer.rowInit(TableColumnInfoServer.java:90)
at oracle.xdo.template.fo.elements.table.FOTableRow.doLayout(FOTableRow.java:136)
at oracle.xdo.template.fo.elements.table.FOTableBody.doLayout(FOTableBody.java:107)
at oracle.xdo.template.fo.elements.table.FOTableBody.doLayout(FOTableBody.java:84)
at oracle.xdo.template.fo.elements.table.FOTable.doLayout(FOTable.java:170)
at oracle.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:379)
at oracle.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:268)
at oracle.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:379)
at oracle.xdo.template.fo.elements.table.FOTableCell.cellDoLayout(FOTableCell.java:160)
at oracle.xdo.template.fo.elements.table.FOTableCell.doLayout(FOTableCell.java:111)
at oracle.xdo.template.fo.elements.table.FOTableRow.doLayout(FOTableRow.java:163)
at oracle.xdo.template.fo.elements.table.FOTableBody.doLayout(FOTableBody.java:107)
at oracle.xdo.template.fo.elements.table.FOTableBody.doLayout(FOTableBody.java:84)
at oracle.xdo.template.fo.elements.table.FOTable.doLayout(FOTable.java:170)
at oracle.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:379)
at oracle.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:268)
at oracle.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:379)
at oracle.xdo.template.fo.elements.table.FOTableCell.cellDoLayout(FOTableCell.java:160)
at oracle.xdo.template.fo.elements.table.FOTableCell.doLayout(FOTableCell.java:111)
at oracle.xdo.template.fo.elements.table.FOTableRow.doLayout(FOTableRow.java:163)
at oracle.xdo.template.fo.elements.table.FOTableBody.doLayout(FOTableBody.java:107)
at oracle.xdo.template.fo.elements.table.FOTableBody.doLayout(FOTableBody.java:84)
at oracle.xdo.template.fo.elements.table.FOTable.doLayout(FOTable.java:170)
at oracle.xdo.template.fo.elements.FOBlock.doLayout(FOBlock.java:181)
at oracle.xdo.template.fo.elements.FOFlow.doLayout(FOFlow.java:111)
at oracle.xdo.template.fo.elements.FormattingEngine.startLayout(FormattingEngine.java:274)
at oracle.xdo.template.fo.elements.FormattingEngine.run(FormattingEngine.java:165)
at oracle.xdo.template.fo.FOHandler.endElement(FOHandler.java:606)
at oracle.xdo11g.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:211)
at oracle.xdo11g.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1352)
at oracle.xdo11g.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:366)
at oracle.xdo11g.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:312)
at oracle.xdo11g.parser.v2.XMLParser.parse(XMLParser.java:218)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.xdo.common.xml.XDOSAXParser.invokeParse(XDOSAXParser.java:300)
at oracle.xdo.common.xml.XDOSAXParser.parse(XDOSAXParser.java:149)
at oracle.xdo.template.fo.FOProcessingEngine.process(FOProcessingEngine.java:449)
at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1291)
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:200)
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:748)

]]

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
References


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