BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"

Dhanuka Chamal

Summary

BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"

Content

Hello Everyone,

 

We are on Oracle Cloud Application 20B. I was trying to run a BIP excel report and it completed successfully but when I tried to open it somehow it crashed. So I downloaded the xml file and tried to run it on my local PC, but it failed with "java.lang.OutOfMemoryError: Java heap space" error. I found few support documents regarging the issue, but all of them are for Oracle E-Business Suite. Any help/ pointer is appreciated. 

 

The complete error message I got is;

 

Start Excel Preview

only open: false

mTemplate: C:\Users\Dhanuka\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\tmp\tmp.xls

mTmpTemplate: C:\Users\Dhanuka\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp/tmp.xls

java.lang.reflect.InvocationTargetException

Caused by: java.lang.OutOfMemoryError: Java heap space

at oracle.xdo11g.parser.v2.XMLText.addText(XMLText.java:466)

at oracle.xdo11g.parser.v2.XMLDocument.createTextNode(XMLDocument.java:894)

at oracle.xdo11g.parser.v2.DocumentBuilder.characters(DocumentBuilder.java:633)

at oracle.xdo11g.parser.v2.NonValidatingParser.reportCharacters(NonValidatingParser.java:1752)

at oracle.xdo11g.parser.v2.NonValidatingParser.parseText(NonValidatingParser.java:1454)

at oracle.xdo11g.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1338)

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:311)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at oracle.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:755)

at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:310)

at oracle.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:187)

at oracle.xdo.template.excel.ExcelController.processActionLanguage(ExcelController.java:338)

at oracle.xdo.template.excel.ExcelController.process(ExcelController.java:240)

at oracle.xdo.template.ExcelProcessor.process(ExcelProcessor.java:244)

at ExcelPreview.runXDO(ExcelPreview.java:110)

at ExcelPreview.main(ExcelPreview.java:87)

 

 

Regards,

Dhanuka

Version

20B

Dimple-Nagesh-Support-Oracle

Hi Dhanuka,

 Please log a service request .

Sandeep S. Chauhan-Oracle

Hi,

Are you able to generate report using template viewer?

try generating the report output using template viewer, you can launch from program files (ex: C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\TemplateViewer)

Regards,

Sandeep S. Chauhan

Dhanuka Chamal

Hi Sandeep,

There must have been an issue in the excel template, because after we re-created it, it worked without a problem. Anyhow thank you very much for the information regarding the template viewer.

Regards,
Dhanuka

Dhanuka Chamal

Hi Dimple,

Will do.

Regards,
Dhanuka