java.lang.OutOfMemoryError: Java heap space

[shahzad53]

Dear Erman,

 

We are using R12.1.3 with 11.2.0.4 database, when we are trying to fetch large records, the concurrent jobs are failed with warning message.

 

[1/16/20 12:07:20 PM] [UNEXPECTED] [1866100:RT49956888] java.lang.reflect.InvocationTargetException

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:677)

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

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

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

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)

at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)

at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)

at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)

at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)

at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:311)

at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:184)

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

 

Need your advice to fix the issue.

 

Regards,

khan

[ErmanArslansOracleBlog]

This is about heap space of that concurrent program.

Update the problematic concurrent program's arguments as;
-Xms2048M -Xmx3096M

Also read -> https://ermanarslan.blogspot.com/2014/12/ebs-122-late-charges-report-xdodtexe.html

[shahzad53]

Hi Ermaan,

I have read your mentioned link, kindly explain me in easy words, your note is little advance.

For my case , i have a problem after concurrent fetch a big records like more then 300,000 records it encountered a error and concurrent completed with warnings.

I found below query & output are attached.

SQL> select DEVELOPER_PARAMETERS from FND_CP_SERVICES
  2  where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
  3  where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

DEVELOPER_PARAMETERS
--------------------------------------------------------------------------------
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m


Also , for my production details are below:-

select CONCURRENT_QUEUE_NAME, ENABLED_FLAG, MAX_PROCESSES, RUNNING_PROCESSES

    from FND_CONCURRENT_QUEUES

    WHERE CONCURRENT_QUEUE_NAME='FNDCPOPP';

 


CONCURRENT_QUEUE_NAME          E MAX_PROCESSES RUNNING_PROCESSES
------------------------------ - ------------- -----------------
FNDCPOPP                       Y             8                 8


kindly advice me.

Regards,

[ErmanArslansOracleBlog]

This is a obvious error. It is related with java heap.

If you get this error in OPP log file, then increase the heap of OPP.

you can just update it to a higher value and retry ->

UPDATE fnd_cp_services
SET developer_parameters =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m'
WHERE service_id = (SELECT manager_type
FROM fnd_concurrent_queues
WHERE concurrent_queue_name = 'FNDCPOPP');

commit;

Also read my posts about this subject... You can find more info and recommendations  ->

https://ermanarslan.blogspot.com/2014/09/ebs-122-output-post-processor.html
https://ermanarslan.blogspot.com/2014/12/ebs-output-post-processoropp.html