OPP java heap space
Locked
 
|
Hello,
Below is the error in the process request log when running a report. A note that this report would normally be returning around 482 000 rows each for the specified range which is quite a lot. Do I need to increase the java heap size of OPP? What is the maximum size of Java Heap for OPP? FNDOPP16135.txt Output type: EXCEL [2/29/16 12:39:34 PM] [16135:RT1299439] Output file was found but is zero sized - Deleted [2/29/16 12:39:34 PM] [UNEXPECTED] [16135:RT1299439] java.lang.reflect.InvocationTargetException Caused by: java.lang.OutOfMemoryError: Java heap space at oracle.xdo.parser.v2.XMLText.addText(XMLText.java:357) at oracle.xdo.parser.v2.XMLDocument.createTextNode(XMLDocument.java:736) at oracle.xdo.parser.v2.DocumentBuilder.characters(DocumentBuilder.java:553) at oracle.xdo.parser.v2.NonValidatingParser.reportCharacters(NonValidatingParser.java:1680) at oracle.xdo.parser.v2.NonValidatingParser.parseText(NonValidatingParser.java:1391) at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1268) at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338) at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285) at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(Unknown Source) at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source) at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source) at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source) at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source) at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5984) at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3475) at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3564) at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:311) at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:185) [2/29/16 12:39:34 PM] [OPPServiceThread0] Post-processing request 1299442. [2/29/16 12:39:34 PM] [16135:RT1299439] Completed post-processing actions for request 1299439. [2/29/16 12:39:34 PM] [16135:RT1299442] Executing post-processing actions for request 1299442. [2/29/16 12:39:34 PM] [16135:RT1299442] Starting XML Publisher post-processing action. [2/29/16 12:39:34 PM] [16135:RT1299442] Template code: SRL_GL_ACCT_ANALYSIS Template app: SQLGL Language: en Territory: 00 Output type: EXCEL Exception in thread "OPPAQMON:16135" [2/29/16 12:40:36 PM] [java.lang.OutOfMemoryError: Java heap space UNEXPECTED] [OPPServiceThread0] java.lang.OutOfMemoryError: Java heap space [2/29/16 12:40:36 PM] [16135:RT1299442] Output file was found but is zero sized - Deleted [2/29/16 12:40:36 PM] [UNEXPECTED] [16135:RT1299442] java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(Unknown Source) at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source) at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source) at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source) at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source) at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source) at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5984) at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3475) at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3564) at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:311) at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:185) Caused by: java.lang.OutOfMemoryError: Java heap space [2/29/16 12:40:36 PM] [16135:RT1299442] Completed post-processing actions for request 1299442. [2/29/16 12:41:35 PM] [Thread-631] Service thread starting up. [2/29/16 2:21:39 PM] [GSMServiceController:16135] Received shutdown request. [2/29/16 2:21:39 PM] [GSMServiceController:16135] Preparing to shutdown service. [2/29/16 2:21:39 PM] [GSMServiceController:16135] Stopping all Service Threads. [2/29/16 2:21:39 PM] [OPPServiceThread2] Preparing to shut down service thread. [2/29/16 2:21:39 PM] [OPPServiceThread1] Preparing to shut down service thread. Rgds, Roshan |
Re: OPP java heap space
Administrator
|
Yes 29 Şub 2016 15:20 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:
Hello, |
|
|
I have done:
select DEVELOPER_PARAMETERS from FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP'); J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m stilll same issue. How will I know which program report is running? Maybe I need to tune the program's memory The report is report SRL_GL_ACCT_ANALYSIS (SRL Account Analysis Report). |
Re: OPP java heap space
|
Administrator
|
Find the name of the concurrent request using the request id stored in OPP log file.
As I saw from your OPP log , it is 1288471, so use request id -> "1288471" and query the fnd_concurrent_requests and program tables. Read the documents for creating a query for this. |
|
|
Hi,
the concurrent program was SRL Account Analysis. I set the Options value to -Xmx2048. Restarted concurrent Manager. Now I am getting the error below: Execution options -Xmx2048M Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are : American_America.US7ASCII '.,' REP-0151: Duplicate argument specification for keyword 'REPORT'. Report Builder: Release 10.1.2.3.0 - Production on Wed Mar 2 17:14:22 2016 Copyright (c) 1982, 2005, Oracle. All rights reserved. +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ End of log messages from FND_FILE +---------------------------------------------------------------------------+ Program exited with status 1 Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 1312138. Review your concurrent request log and/or report output file for more detailed information. I have checked metalink doc (Doc ID 856562.1) Do you think I will get the same Java Heap error after doing this? Rgds, Roshan |
Re: OPP java heap space
|
Administrator
|
Note is good. It says set the Xmx parameters only.
also update fnd_cp_services for opp But note that: Update the fnd_cp_services for opp as follows; J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx3096m -XXtlasize1024k -XXlargeobjectlimit1024k Also update the problematic concurrent program's arguments as; -Xms2048M -Xmx3096M Note that : different jvm versions uses different argument names for the same thing. You will see that some arguments become obsoleted when you use a higher level jdk.. Note that: The JVM used in EBS 12.2 was 32 bits. Even if the EBS is 64 bit, it uses 32 bit jvm for these processes. The Java version used by OPP in this environment is 1.6.. So you may encounter errors if using the above params in 1.7. Note that -> these XX parameters are for Jrockit only. /u01/oracle/TEST/fs2/FMW_Home/jrockit32/bin/java -version java version "1.6.0_29" Java(TM) SE Runtime Environment (build 1.6.0_29-b11) Oracle JRockit(R) (build R28.2.0-79-146777-1.6.0_29-20111005-1807-linux-ia32, compiled mode) |
Re: OPP java heap space
|
Administrator
|
Re: OPP java heap space
|
Administrator
|
Also read this one:
http://ermanarslan.blogspot.com.tr/2014/12/ebs-output-post-processoropp.html Read this notes carefully. |
«
Return to EBS 12.2
|
1 view|%1 views
| Free forum by Nabble | Edit this page |