EXCEL: java.lang.OutOfMemoryError: Java heap space Excel output is much larger than the PDF output

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    EXCEL: java.lang.OutOfMemoryError: Java heap space

Excel output is much larger than the PDF output.

Symptoms:

Template Viewer, PC with java 1.6.0_14 and -Xmx1024m:
PDF: successfully generated 1341 pages
RTF: java.lang.OutOfMemoryError: Java heap space
HTML: java.lang.OutOfMemoryError: Java heap space
(after more than an hour rendering)
EXCEL: java.lang.OutOfMemoryError: Java heap space
(after more than an hour rendering)


Template Builder, PC with java 1.6.0_14 and -Xmx1024m:
PDF: successfully generated 1341 pages
EXCEL: error

Log files:

Solution:

1. Download and review the readme and pre-requisites for Patch 7350414.
2. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Retest the issue.
5. Migrate the solution as appropriate to other environments.

----------------- 
Patch Description: 
----------------- 
This patch contains the consolidated performance fixes for Excel report output. 

This patch also includes the feature which enables Report Manager to publish content set to multiple worksheets and publish reports using complex content sets (combinations of PE and PT) in Report Manager. 

ExpansionValue LOV in Report Display will list concatenated accounts which corresponds to the expanded report. Customer can view individual reports by selecting the expansion value or entire report using 'ALL' expansion value. The output type drop down in report display page has been replaced with images. 

References:

Note 760437.1 Excel Output File Size Generated By BI Publisher Is Very Large

Note 751948.1 Unable To View Published Large FSG Reports - It Times Out

Get Oracle Certifications for all Exams
Free Online Exams.com