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

Last updated on MARCH 01, 2023

Applies to:

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

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