Getting n error when executing large xml data report in oracle apps R12

Vinay A Sawant

Summary

Getting n error when executing large xml data report in oracle apps R12

Content

Template code: ERP_DEBTORS_LEDGERNEW_1 Template app:  ONT Language:      en Territory:    IN Output type:  PDF Exception in thread "REQTMGR:8249314" java.lang.OutOfMemoryError: Java heap space                 at java.util.Arrays.copyOf(Arrays.java:2882)                 at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:100)                 at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390)                 at java.lang.StringBuilder.append(StringBuilder.java:119)                 at oracle.apps.fnd.cp.opp.OPPRequestThreadManager.checkThreads(OPPRequestThreadManager.java:290)                 at oracle.apps.fnd.cp.opp.OPPRequestThreadManager.run(OPPRequestThreadManager.java:99)                 at java.lang.Thread.run(Thread.java:682) [5/30/18 10:15:11 PM] [Exception in thread "OPPServiceThread0" java.lang.OutOfMemoryError: Java heap space Exception in thread "OPPAQMON:8249314" java.lang.OutOfMemoryError: Java heap space UNEXPECTED] [OPPServiceThread1] java.lang.OutOfMemoryError: Java heap space

Venkat Thota - BIP

it clearly says java.lang.OutOfMemoryError: Java heap space   , increase memory for the server where report server is running

Venkat Thota - BIP

https://docs.oracle.com/middleware/12212/bip/BIPAD/GUID-A9AF337A-7A62-4BCB-B22A-7ECBCCB2869E.htm#BIPAD4858

Vinay A Sawant

Already 2.5GB is there How much size required

Shakher Sharma

If it is  a custom report, you can rename XML tags and make them smaller, that should help reducing the size of XML file. Also, Try to break down output into multiple smaller chunks for example, instead of running report for a whole year, run it for each period, or quarter instead at one time.

 

Brajesh Shukla-95078

Due to exhausted heap size sometime this happened when you try to generate the pdf output for big xml data. To solve this in the concurrent program window > Option you can specify dedicated heap size as -Xms1024m -Xmx1024m this should solve the problem. Many standard xml report in R12 uses the same thing.