Concurrent program-RTF

[satish]

Dear erman,

I have a general question rtf template.

We are facing intermittent issues with a custom report where few runs are completing normal and few runs are completing with warning with specific arguments.Opp throwing out of memory message in logs.The xml generated is less than 1MB.

We are on R2.1.3 instance with 2GB heapspace defined and we have 3 processes for opp manager with 5 threads each.Many long running requests with large output files are completing without any issues but we are facing issue only with this custom report which runs less than a minute and output file is small.

Have you faced this kind of intermittent issue with any report?what all we can check from dba point of view or is this something a developer can optimize the rtf?

Thank you.

[satish]

Dear erman,

Same intermittent issue with few other programs which ran successfully before.Facing this issue since last 3 days, no recent changes done.

I can see all the out of memory errors thrown in one specific opp process log and rest of other 2 processes have no errors in their logfile.

Thank you

[ErmanArslansOracleBlog]

It may be related with the OPP's heap size and a couple of other configurables.

Check the following blog posts ->

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

[satish]

Hi Erman,

You said "updated 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".

For R12.1.3,can we set the xmx to 3096M?

Thanks you

[ErmanArslansOracleBlog]

Yes.

For instance;

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

commit;

Check the following MOS note for further details;

Tuning Output Post Processor (OPP) to Improve Performance (Doc ID 1399454.1)