Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Getting n error when executing large xml data report in oracle apps R12
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
Answers
-
-
Already 2.5GB is there How much size required
0 -
-
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.
0 -
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.
0