Saturday, October 22, 2011

XML publisher completing in Warning when data size is big. One or more post processing actions failed java.lang.OutOfMemoryError

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 publisher completing in Warning when data size is big. One or more post processing actions failed java.lang.OutOfMemoryError

XML Publisher Report completes in Warning when data size is big with generic message, one or more post processing actions failed. Consult the opp log for details.

Using 11.5.10.2 RUP 6 , XML Publisher Report completes in Warning when data size is big with generic message,one or more post processing actions failed.consult the opp log for details.

REP-0151: Duplicate argument specification for keyword 'REPORT'.

 
Log files:
FILE NAME: FNDOPP80221.txt
--------------------------------------------------

[6/17/09 6:54:42 AM] [main] Starting GSF service with concurrent process id = 80221.
[6/17/09 6:54:42 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[6/17/09 6:54:42 AM] [Thread-12] Service thread starting up.
[6/17/09 6:54:42 AM] [Thread-13] Service thread starting up.
[6/17/09 8:32:38 AM] [OPPServiceThread1] Post-processing request 6012285.
[6/17/09 8:32:39 AM] [80221:RT6012285] Executing post-processing actions for request 6012285.
[6/17/09 8:32:39 AM] [80221:RT6012285] Starting XML Publisher post-processing action.
[6/17/09 8:32:39 AM] [80221:RT6012285]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
[061709_083239910][][EXCEPTION] [DEBUG] ------- Preferences defined PreferenceStore -------
[061709_083239911][][EXCEPTION] [DEBUG] ------- Environment variables stored in EnvironmentStore -------
[061709_083239911][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.LOW]:[-1]
[061709_083239911][][EXCEPTION] [DEBUG] [SECURITY_GROUP_ID]:[0]
[061709_083239911][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_INTERVAL]:[60]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_CHARACTERSET]:[UTF8]
[061709_083239912][][EXCEPTION] [DEBUG] [RESP_APPL_ID]:[-1]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_LANGUAGE]:[AMERICAN]
[061709_083239912][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
[061709_083239912][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
[061709_083239912][][EXCEPTION] [DEBUG] [NLS_NUMERIC_CHARACTERS]:[.,]
[061709_083239912][][EXCEPTION] [DEBUG] [APPS_JDBC_URL]:[jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=jaorddu1.dpa.co.ae)(PORT=1541)))(CONNECT_DATA=(SID=PTYD)))]
[061709_083239912][][EXCEPTION] [DEBUG] [RESP_ID]:[-1]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_MAX_JDBC_CONNECTIONS]:[500]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_USABLE_CHECK]:[true]
[061709_083239913][][EXCEPTION] [DEBUG] [USER_ID]:[-1]
[061709_083239913][][EXCEPTION] [DEBUG] [NLS_TERRITORY]:[AMERICA]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_PLSQL_RESET]:[false]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_CONTEXT_CHECK]:[true]
[061709_083239913][][EXCEPTION] [DEBUG] [NLS_DATE_FORMAT]:[DD-MON-RR]
[061709_083239913][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_SIZE]:[1]
[061709_083239914][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.HIGH]:[-1]
[061709_083239914][][EXCEPTION] [DEBUG] [NLS_SORT]:[BINARY]
[061709_083239914][][EXCEPTION] [DEBUG] [NLS_DATE_LANGUAGE]:[AMERICAN]
[061709_083239914][][EXCEPTION] [DEBUG] [LOGIN_ID]:[-1]
[061709_083239914][][EXCEPTION] [DEBUG] ------- Properties stored in Java System Properties -------
[061709_083239914][][EXCEPTION] [DEBUG] [APPLTMP]:[/u03/ptyd/ptydcomn/temp]
[061709_083239914][][EXCEPTION] [DEBUG] [java.runtime.name]:[Java(TM) 2 Runtime Environment, Standard Edition]
[061709_083239914][][EXCEPTION] [DEBUG] [sun.boot.library.path]:[/opt/java1.4/jre/lib/PA_RISC2.0]
[061709_083239915][][EXCEPTION] [DEBUG] [java.vm.version]:[1.4.2 1.4.2.09-050713-05:46-PA_RISC2.0 PA2.0 (aCC_AP)]
[061709_083239915][][EXCEPTION] [DEBUG] [OVERRIDE_DBC]:[true]
[061709_083239916][][EXCEPTION] [DEBUG] [dbcfile]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vm.vendor]:[Hewlett-Packard Company]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vendor.url]:[http://www.hp.com/go/Java]
[061709_083239916][][EXCEPTION] [DEBUG] [path.separator]:[:]
[061709_083239916][][EXCEPTION] [DEBUG] [APPLCSF]:[/u03/ptyd/ptydcomn/admin]
[061709_083239916][][EXCEPTION] [DEBUG] [java.vm.name]:[Java HotSpot(TM) Server VM]
[061709_083239916][][EXCEPTION] [DEBUG] [file.encoding.pkg]:[sun.io]
[061709_083239916][][EXCEPTION] [DEBUG] [sun.os.patch.level]:[unknown]
[061709_083239917][][EXCEPTION] [DEBUG] [user.dir]:[/u03/ptyd/ptydcomn/admin/log/PTYD_jaoradu1]
[061709_083239917][][EXCEPTION] [DEBUG] [java.vm.specification.name]:[Java Virtual Machine Specification]
[061709_083239917][][EXCEPTION] [DEBUG] [java.runtime.version]:[1.4.2.09-050713-03:34]
[061709_083239917][][EXCEPTION] [DEBUG] [java.awt.graphicsenv]:[sun.awt.X11GraphicsEnvironment]
[061709_083239917][][EXCEPTION] [DEBUG] [java.endorsed.dirs]:[/opt/java1.4/jre/lib/endorsed]
[061709_083239917][][EXCEPTION] [DEBUG] [os.arch]:[PA_RISC2.0]
[061709_083239917][][EXCEPTION] [DEBUG] [JTFDBCFILE]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239917][][EXCEPTION] [DEBUG] [java.io.tmpdir]:[/var/tmp/]
[061709_083239918][][EXCEPTION] [DEBUG] [line.separator]:[
]
[061709_083239918][][EXCEPTION] [DEBUG] [java.vm.specification.vendor]:[Sun Microsystems Inc.]
[061709_083239918][][EXCEPTION] [DEBUG] [os.name]:[HP-UX]
[061709_083239918][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
[061709_083239918][][EXCEPTION] [DEBUG] [sun.java2d.fontpath]:[]
[061709_083239918][][EXCEPTION] [DEBUG] [cpid]:[80221]
[061709_083239918][][EXCEPTION] [DEBUG] [runtime]:[aCC_AP]
[061709_083239918][][EXCEPTION] [DEBUG] [java.library.path]:[/opt/java1.4/jre/lib/PA_RISC2.0:/opt/java1.4/jre/lib/PA_RISC2.0/server:/opt/java1.4/jre/../lib/PA_RISC2.0:/u03/ptyd/ptydora/iAS/lib:/u03/ptyd/ptydora/8.0.6/network/jre11/lib/PA_RISC/native_threads:/u03/ptyd/ptydappl/cz/11.5.0/bin::/u03/ptyd/ptydora/8.0.6/lib:/usr/lib:/usr/lib]
[061709_083239919][][EXCEPTION] [DEBUG] [java.specification.name]:[Java Platform API Specification]
[061709_083239919][][EXCEPTION] [DEBUG] [java.class.version]:[48.0]
[061709_083239919][][EXCEPTION] [DEBUG] [java.util.prefs.PreferencesFactory]:[java.util.prefs.FileSystemPreferencesFactory]
[061709_083239919][][EXCEPTION] [DEBUG] [os.version]:[B.11.23]
[061709_083239919][][EXCEPTION] [DEBUG] [LONG_RUNNING_JVM]:[true]
[061709_083239919][][EXCEPTION] [DEBUG] [user.home]:[/home/applptyd]
[061709_083239919][][EXCEPTION] [DEBUG] [user.timezone]:[GMT+04:00]
[061709_083239920][][EXCEPTION] [DEBUG] [java.awt.printerjob]:[sun.print.PSPrinterJob]
[061709_083239920][][EXCEPTION] [DEBUG] [file.encoding]:[8859_1]
[061709_083239920][][EXCEPTION] [DEBUG] [java.specification.version]:[1.4]
[061709_083239920][][EXCEPTION] [DEBUG] [CACHEMODE]:[DISTRIBUTED]
[061709_083239920][][EXCEPTION] [DEBUG] [user.name]:[applptyd]
[061709_083239920][][EXCEPTION] [DEBUG] [java.class.path]:[/opt/java1.4/lib/dt.jar:/opt/java1.4/lib/tools.jar:/opt/java1.4/jre/lib/rt.jar:/opt/java1.4/jre/lib/charsets.jar:/u03/ptyd/ptydcomn/java/appsborg2.zip:/u03/ptyd/ptydcomn/java/apps.zip:/u03/ptyd/ptydora/8.0.6/forms60/java:/u03/ptyd/ptydcomn/java]
[061709_083239920][][EXCEPTION] [DEBUG] [DBCFILE]:[/u03/ptyd/ptydappl/fnd/11.5.0/secure/PTYD_jaoradu1/jaorddu1_ptyd.dbc]
[061709_083239921][][EXCEPTION] [DEBUG] [java.vm.specification.version]:[1.0]
[061709_083239921][][EXCEPTION] [DEBUG] [java.home]:[/opt/java1.4/jre]
[061709_083239921][][EXCEPTION] [DEBUG] [sun.arch.data.model]:[32]
[061709_083239921][][EXCEPTION] [DEBUG] [user.language]:[en]
[061709_083239922][][EXCEPTION] [DEBUG] [java.specification.vendor]:[Sun Microsystems Inc.]
[061709_083239922][][EXCEPTION] [DEBUG] [java.vm.info]:[mixed mode]
[061709_083239922][][EXCEPTION] [DEBUG] [logfile]:[/u03/ptyd/ptydcomn/admin/log/PTYD_jaoradu1/FNDOPP80221.txt]
[061709_083239922][][EXCEPTION] [DEBUG] [java.version]:[1.4.2.09]
[061709_083239922][][EXCEPTION] [DEBUG] [java.ext.dirs]:[/opt/java1.4/jre/lib/ext]
[061709_083239922][][EXCEPTION] [DEBUG] [sun.boot.class.path]:[/opt/java1.4/jre/lib/rt.jar:/opt/java1.4/jre/lib/i18n.jar:/opt/java1.4/jre/lib/sunrsasign.jar:/opt/java1.4/jre/lib/jsse.jar:/opt/java1.4/jre/lib/jce.jar:/opt/java1.4/jre/lib/charsets.jar:/opt/java1.4/jre/classes]
[061709_083239922][][EXCEPTION] [DEBUG] [java.vendor]:[Hewlett-Packard Co.]
[061709_083239923][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
[061709_083239923][][EXCEPTION] [DEBUG] [file.separator]:[/]
[061709_083239923][][EXCEPTION] [DEBUG] [java.vendor.url.bug]:[http://www.hp.com/go/Java]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.io.unicode.encoding]:[UnicodeBig]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.cpu.endian]:[big]
[061709_083239923][][EXCEPTION] [DEBUG] [APPLOUT]:[out/PTYD_jaoradu1]
[061709_083239923][][EXCEPTION] [DEBUG] [sun.cpu.isalist]:[pa2.0 pa1.2 pa1.1 pa1.0]
[6/17/09 8:37:44 AM] [UNEXPECTED] [80221:RT6012285] 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:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
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:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: java.lang.OutOfMemoryError

[6/17/09 8:37:45 AM] [80221:RT6012285] Completed post-processing actions for request 6012285.
[6/17/09 10:47:54 AM] [OPPServiceThread1] Post-processing request 6012954.
[6/17/09 10:47:55 AM] [80221:RT6012954] Executing post-processing actions for request 6012954.
[6/17/09 10:47:55 AM] [80221:RT6012954] Starting XML Publisher post-processing action.
[6/17/09 10:47:55 AM] [80221:RT6012954]
Template code: XXFINPLXXNOFFEM
Template app: PN
Language: en
Territory: US
Output type: PDF
[6/17/09 10:48:04 AM] [80221:RT6012954] XML Publisher post-processing action complete.
[6/17/09 10:48:04 AM] [80221:RT6012954] Completed post-processing actions for request 6012954.
[6/17/09 1:52:58 PM] [OPPServiceThread1] Post-processing request 6043871.
[6/17/09 1:52:58 PM] [80221:RT6043871] Executing post-processing actions for request 6043871.
[6/17/09 1:52:58 PM] [80221:RT6043871] Starting XML Publisher post-processing action.
[6/17/09 1:52:58 PM] [80221:RT6043871]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
java.lang.OutOfMemoryError
java.lang.OutOfMemoryError
[6/17/09 1:54:54 PM] [UNEXPECTED] [80221:RT6043871] 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:324)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(XSLT10gR1.java:517)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:224)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
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:1657)
at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:967)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5888)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3438)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3527)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:247)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: java.lang.OutOfMemoryError

[6/17/09 1:54:54 PM] [80221:RT6043871] Completed post-processing actions for request 6043871.
[6/17/09 2:53:31 PM] [OPPServiceThread1] Post-processing request 6049888.
[6/17/09 3:04:15 PM] [OPPServiceThread0] Post-processing request 6050871.
[6/17/09 3:27:26 PM] [OPPServiceThread1] Post-processing request 6056871.
[6/17/09 3:27:26 PM] [80221:RT6056871] Executing post-processing actions for request 6056871.
[6/17/09 3:27:26 PM] [80221:RT6056871] Starting XML Publisher post-processing action.
[6/17/09 3:27:26 PM] [80221:RT6056871]
Template code: XXFINARXAGE
Template app: XXFIN
Language: en
Territory: US
Output type: PDF
[6/17/09 3:27:34 PM] [80221:RT6056871] XML Publisher post-processing action complete.
[6/17/09 3:27:34 PM] [80221:RT6056871] Completed post-processing actions for request 6056871.
[6/17/09 3:30:16 PM] [OPPServiceThread0] Post-processing request 6057871.
[6/17/09 3:36:09 PM] [OPPServiceThread0] Post-processing request 6056874.

Solution:


1. Determine what the heap size per OPP process is currently:
select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

2. The default should be: J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

3. Increase the Heap Space per Process to 1024:
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');
4. Increase the values for these profiles for at least 2 hours each:
Concurrent:OPP Process Timeout
Concurrent:OPP Response Timeout
5.Run cmclean.sql and bounce the concurrent managers

References:
Note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i
Note 401561.1 Using J2SE Version 6.0 with Oracle E-Business Suite 11i
Note 315477.1 Ext/Pub XML Report Publisher Fails With java.lang.OutOfMemoryError:This note could work for this since they are on BIP 5.6.1
Note 371303.1 Ext/Pub Xml Publisher Receives Out Of Memory Java Error After Running A Number Of Jobs:
Note 387190.1 Ext/Pub Output Post Processor Fails with java.lang.OutOfMemoryError for Large Reports:
Note 549990.1 Int/Pub Java.Lang.Out of memoryerror Java Heap Space When Running Large Bi Pub Reports:
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: