XML report ends with java.lang.outOfMemory error in OPP log “memory issue with large XLMP reports”

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    XML report ends with java.lang.outOfMemory error in OPP log “memory issue with large XLMP reports”

 

Log files:

FNDOPP78648.txt
-------------------------
[053109_082320341][][EXCEPTION] [DEBUG] [java.version]:[1.4.2.09]

[5/31/09 8:37:56 AM] [UNEXPECTED] [78648:RT5708718] java.lang.OutOfMemoryError

LOG FILE
----------
[3/1/09 3:32:24 PM] [main] Starting GSF service with concurrent process id = 58675.
[3/1/09 3:32:24 PM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[3/1/09 3:32:24 PM] [Thread-14] Service thread starting up.
[3/1/09 3:32:24 PM] [Thread-15] Service thread starting up.
[3/1/09 3:32:24 PM] [GSMServiceController:58675] Received shutdown request.
[3/1/09 3:32:24 PM] [GSMServiceController:58675] Preparing to shutdown service.
[3/1/09 3:32:24 PM] [GSMServiceController:58675] Stopping all Service Threads.
[3/1/09 3:32:25 PM] [OPPServiceThread0] Oracle error 17002: java.sql.SQLException: Io exception: Socket closed has been detected in CPAppsDatabaseContext.loadEnvironment.
[3/1/09 3:32:25 PM] [OPPServiceThread0] APPLTMP environment variable is not set
[3/1/09 3:32:26 PM] [UNEXPECTED] [OPPServiceThread1] java.lang.InterruptedException
at oracle.apps.fnd.cp.opp.OPPServiceThread.init(OPPServiceThread.java:95)
at oracle.apps.fnd.cp.gsf.BaseServiceThread.run(BaseServiceThread.java:124)

[3/1/09 3:32:26 PM] [OPPServiceThread0] Preparing to shut down service threa

Solution:

Check the parameter APPSJREOPT in $APPL_TOP/admin/adovars.env 

Set it to: -Xmx1024M -Xms512M or to  -Xmx2048M -Xms512M


and also allow the OPP process to get more memory by this update:

update FND_CP_SERVICES
set DEVELOPER_PARAMETERS = 'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

References:

Note 315477.1 XML Report Publisher Fails With java.lang.OutOfMemoryError:
Note 563945.1 Large XML Reports Take a Long Time Or Fail

Note 760437.1 Excel Output File Size Generated By BI Publisher Is Very Large

Get Oracle Certifications for all Exams
Free Online Exams.com