The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)
Posted February 7, 2009
on:- In: Oracle
- 24 Comments
Three possible errors can occur as below:
- The Output Post Processor is not running or does not pick up the request
…
+————- 1) PUBLISH ————-+
Unable to find an Output Post Processor service to post-process request [request_id].Check that the Output Post Processor service is running.
+————————————–+
…
Solutions:
* Verify that the Output Post Processor is enabled and active.
* If confirmed, retrieve the OPP log file either via the Forms application or via the Oracle Application Manager.
– Via the Forms application:
- Login to the application as SYSADMIN
- Responsibility: System Administrator
- Function: Concurrent –> Manager –> Administration
- Select the Output Post Processor
- Click on the Processes button
- Select the Concurrent Process which was active during the time that the request ran
- Click on the Manager Log button to open the Output Post Processor log file
– Via the Oracle Application Manager
- Login to the application as SYSADMIN
- Responsibility: System Administration
- Function: Oracle Applications Manager –> Concurrent Managers
- Select the Output Post Processor Service and click on View Details
- Click on View Processes
- Select the Concurrent Process which was active during the time that the request ran
- Click on the Log button to open the Output Post Processor log file
- The Output Post Processor is running but has not picked up the request
...
+------------- 1) PUBLISH -------------+
The Output Post-processor is running but has not picked up
this request.No further attempts will be made to post-process
this request, and the request will be marked with Warning status.
Setting the profile option Concurrent: OPP Response Timeout
to a higher value may be necessary.
+--------------------------------------+
...
By default a timeout will occur if it takes longer then 120 seconds (2 min.) for the Output Post Processor to pick up the request from the Concurrent Manager process. In that case, the Concurrent Request will complete with status Warning and the Request log file will contain error message like above.
Solutions:
* Increase the value (in seconds) for the profile option ‘Concurrent:OPP Response Timeout‘.
- The concurrent manager has timed out waiting for the Output Post-processor to finish this request
…
+————- 1) PUBLISH ————-+
The concurrent manager has timed out waiting for the Output Post-processor
to finish this request.Check that there are enough Output Post-processor service processes running.
More information may be found in the service process logfile.
+————————————–+
…
The concurrent manager process has successfully invoked the OPP but it a timeout is encountered as the OPP takes too long to complete the job.
The time that this takes will depends on various elements such as:
- size of the XML Data File
- complexity of the template
- performance of the server
- ….
By default a timeout will occur if it takes longer then 300 seconds (5 min.) for the XML Publisher engine to generate the output file. The Concurrent Request will complete with status Warning and the Request log file will contain error message like above.
Solutions:
* Increase the value (in seconds) for the profile option ‘Concurrent:OPP Process Timeout‘.
- Output Post Processor (OPP) Log Contains Error “java.lang.OutOfMemoryError: Java heap space”
java.lang.reflect.InvocationTargetException Caused by: java.lang.OutOfMemoryError: Java heap space at oracle.xdo.parser.v2.XMLDocument.createNodeFromType(XMLDocument.java:2869) at oracle.xdo.parser.v2.XMLDocument.createNodeFromType(XMLDocument.java:3000)
Solutions:
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. Bring the managers down.
5. Run cmclean.sql script from Note 134007.1 – CMCLEAN.SQL Non-Destructive Script to Clean Concurrent Manager Tables.
6. Bring the managers up again.
OR
1. Log into applications with the System Administrator responsibility.
2. Navigate to Concurrent -> Program -> Define
3. Query the XML Publisher Template Re-Generator program
4. Set the following value for the Executable Options : -Xmx1024m
5. Save changes.
6. Retest the program.
OR
Configure the XML Publisher Administrator Configuration settings.
1. As XML Publisher Administrator navigate to Administration->Configuration.
2. Under Temporary Directory pick a temporary file location on your concurrent processing node. This should be at least 5GB or 20x larger than largest XML data file you generate
3. Under FO Processing, set:
o Use XML Publisher’s XSLT processor set to True
o Enable scalable feature of XSLT processor set to False
o Enable XSLT runtime optimization set to True
24 Responses to "The XML Publisher Concurrent Request Fails Due to the Output Post Processing (OPP)"
xml view output to excel
ORA-01403: no data found
————————————————————–
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.
all set..data definition, tempalte, etc. but view output error on excel, on pdf no problem
need advice
LikeLike
Hi Edi,
Nice article on checking the log file from OPP log for XML Publisher OPP process. However, we need to turn on the XDO / XML Publisher debug log to get meaningful information and detailed logging.
I would like to share this article on how to turn on the debug log.
BI Publisher debugging and logging
Thanks
-Raj
http://www.adivaconsulting.com
LikeLike
When i run Journal voucher within Oracle EBS 12.0.4 i am getting Phase “Completed” Status “Warning” , following are the log for this request.
+—————————————————————————+
General Ledger: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLRXVCJ module: Journals – Voucher
+—————————————————————————+
Current system time is 04-JUL-2011 12:18:05
+—————————————————————————+
+—————————–
| Starting concurrent program execution…
+—————————–
Arguments
————
P_ACCESS_SET_ID=’1001′
P_ACTUAL_FLAG=’A’
P_LEDGER_ID=’2024′
P_STATUS=’U’
P_CURRENCY=’PKR’
P_START_DATE=’2011/06/30 00:00:00′
P_END_DATE=’2011/07/04 00:00:00′
P_BATCH_NAME=’HO Voucher- 861 – Greenstar’
P_COA=’50329′
P_JOURNALS_LINE_FLAG=’L’
P_PAGEBREAK=’1′
P_CONTRA_FLAG=’N’
P_REPORT_NAME=’VOUCHER’
————
APPLLCSP Environment Variable set to :
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
‘.,’
Enter Password:
Report Builder: Release 10.1.2.0.2 – Production on Mon Jul 4 12:18:06 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
Executing request completion options…
+————- 1) PUBLISH ————-+
Beginning post-processing of request 4866350 on node APPSPROD at 04-JUL-2011 12:18:08.
Post-processing of request 4866350 failed at 04-JUL-2011 12:23:08 with the error message:
The Output Post-processor is running but has not picked up this request.
No further attempts will be made to post-process this request, and the request will be marked
with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.
+————————————–+
+————- 2) PRINT ————-+
Not printing the output of this request because post-processing failed.
+————————————–+
Finished executing request completion options.
+—————————————————————————+
Concurrent request completed
Current system time is 04-JUL-2011 12:23:08
+—————————————————————————+
LikeLike
Hi Edi,
Can you help me in the following case. I am getting the following error while running the report:-
Custom Account Receivable: Version : UNKNOWN
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
ARFORM module: Report For AR Transaction Form
+—————————————————————————+
Current system time is 06-DEC-2011 02:23:44
+—————————————————————————+
+—————————–
| Starting concurrent program execution…
+—————————–
Arguments
————
P_TRX_NUMBER=’2142777′
————
APPLLCSP Environment Variable set to :
XML_REPORTS_XENVIRONMENT is :
/gpsescs1/erpapp/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XENVIRONMENT is set to /gpsescs1/erpapp/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
‘.,’
Report Builder: Release 6.0.8.28.0 – Production on Tue Dec 6 02:23:52 2011
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter Username:
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
Executing request completion options…
+————- 1) PUBLISH ————-+
Beginning post-processing of request 45247461 on node TSGSD4902 at 06-DEC-2011 02:23:55.
Post-processing of request 45247461 failed at 06-DEC-2011 02:24:00 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+————————————–+
+————- 2) PRINT ————-+
Not printing the output of this request because post-processing failed.
+————————————–+
Finished executing request completion options.
+—————————————————————————+
Concurrent request completed
Current system time is 06-DEC-2011 02:24:01
please help me if you can..
Thanks in Advance..
Saurabh.
LikeLike
hi
My concurrent requests are completed with warnings
in opp file i got cause:
Caused by: oracle.xdo.parser.v2.XSLException: No space left on device
i have checkted all tablespace free spaces no problem with them, how can i resolve.
LikeLike
Hi I am getting this error with the same issue, i.e. running concurrent program that gives XML data and template is attached with the program.
The error is:
One or more post-processing actions failed. Consult the OPP service log for details.
And the log file has this errors:
[7/13/16 7:01:37 AM] [main] Starting GSF service with concurrent process id = 1867690.
[7/13/16 7:01:37 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
[7/13/16 7:01:37 AM] [Thread-32] Service thread starting up.
[7/13/16 7:01:37 AM] [Thread-33] Service thread starting up.
[7/13/16 7:02:14 AM] [OPPServiceThread1] Post-processing request 37599331.
[7/13/16 7:02:14 AM] [1867690:RT37599331] Executing post-processing actions for request 37599331.
[7/13/16 7:02:14 AM] [1867690:RT37599331] Starting XML Publisher post-processing action.
[7/13/16 7:02:14 AM] [1867690:RT37599331]
Template code: XXCUSTTTRY
Template app: PO
Language: en
Territory: 00
Output type: EXCEL
[071316_070215242][][EXCEPTION] [DEBUG] ——- Preferences defined PreferenceStore ——-
[071316_070215243][][EXCEPTION] [DEBUG] ——- Environment variables stored in EnvironmentStore ——-
[071316_070215243][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
[071316_070215243][][EXCEPTION] [DEBUG] [FND_JDBC_USABLE_CHECK]:[true]
[071316_070215243][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.HIGH]:[-1]
[071316_070215243][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_SIZE]:[5]
[071316_070215244][][EXCEPTION] [DEBUG] [FND_MAX_JDBC_CONNECTIONS]:[500]
[071316_070215244][][EXCEPTION] [DEBUG] [RESP_APPL_ID]:[-1]
[071316_070215244][][EXCEPTION] [DEBUG] [USER_ID]:[-1]
[071316_070215244][][EXCEPTION] [DEBUG] [SECURITY_GROUP_ID]:[0]
[071316_070215244][][EXCEPTION] [DEBUG] [LOGIN_ID]:[-1]
[071316_070215244][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.LOW]:[-1]
[071316_070215244][][EXCEPTION] [DEBUG] [APPS_JDBC_URL]:[jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=ssserpd-scan.corporate.ge.com)(PORT=1550)))(CONNECT_DATA=(SERVICE_NAME=scd4.corporate.ge.com)))]
[071316_070215244][][EXCEPTION] [DEBUG] [RESP_ID]:[-1]
[071316_070215244][][EXCEPTION] [DEBUG] [FND_JDBC_CONTEXT_CHECK]:[true]
[071316_070215244][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
[071316_070215244][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_INTERVAL]:[300]
[071316_070215245][][EXCEPTION] [DEBUG] [FND_JDBC_PLSQL_RESET]:[false]
[071316_070215245][][EXCEPTION] [DEBUG] ——- Properties stored in Java System Properties ——-
[071316_070215245][][EXCEPTION] [DEBUG] [APPLTMP]:[/sssdshr/appllog/ccm/scd4/tmp]
[071316_070215245][][EXCEPTION] [DEBUG] [java.runtime.name]:[Java(TM) SE Runtime Environment]
[071316_070215245][][EXCEPTION] [DEBUG] [sun.boot.library.path]:[/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/sparc]
[071316_070215245][][EXCEPTION] [DEBUG] [java.vm.version]:[24.80-b11]
[071316_070215245][][EXCEPTION] [DEBUG] [OVERRIDE_DBC]:[true]
[071316_070215245][][EXCEPTION] [DEBUG] [user.country.format]:[US]
[071316_070215245][][EXCEPTION] [DEBUG] [dbcfile]:[/d74/oracle/apps/scd4/appl/fnd/12.0.0/secure/scd4.dbc]
[071316_070215245][][EXCEPTION] [DEBUG] [java.vm.vendor]:[Oracle Corporation]
[071316_070215245][][EXCEPTION] [DEBUG] [java.vendor.url]:[http://java.oracle.com/]
[071316_070215246][][EXCEPTION] [DEBUG] [path.separator]:[:]
[071316_070215246][][EXCEPTION] [DEBUG] [APPLCSF]:[/sssdshr/appllog/ccm/scd4]
[071316_070215246][][EXCEPTION] [DEBUG] [java.vm.name]:[Java HotSpot(TM) Server VM]
[071316_070215246][][EXCEPTION] [DEBUG] [file.encoding.pkg]:[sun.io]
[071316_070215246][][EXCEPTION] [DEBUG] [sun.java.launcher]:[SUN_STANDARD]
[071316_070215246][][EXCEPTION] [DEBUG] [sun.os.patch.level]:[unknown]
[071316_070215246][][EXCEPTION] [DEBUG] [java.vm.specification.name]:[Java Virtual Machine Specification]
[071316_070215246][][EXCEPTION] [DEBUG] [user.dir]:[/sssdshr/appllog/ccm/scd4/log]
[071316_070215246][][EXCEPTION] [DEBUG] [java.runtime.version]:[1.7.0_80-b15]
[071316_070215246][][EXCEPTION] [DEBUG] [CLIENT_PROCESSID]:[26942]
[071316_070215246][][EXCEPTION] [DEBUG] [java.awt.graphicsenv]:[sun.awt.X11GraphicsEnvironment]
[071316_070215247][][EXCEPTION] [DEBUG] [java.endorsed.dirs]:[/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/endorsed]
[071316_070215247][][EXCEPTION] [DEBUG] [os.arch]:[sparc]
[071316_070215247][][EXCEPTION] [DEBUG] [JTFDBCFILE]:[/d74/oracle/apps/scd4/appl/fnd/12.0.0/secure/scd4.dbc]
[071316_070215247][][EXCEPTION] [DEBUG] [java.io.tmpdir]:[/var/tmp/]
[071316_070215247][][EXCEPTION] [DEBUG] [line.separator]:[
]
[071316_070215247][][EXCEPTION] [DEBUG] [java.vm.specification.vendor]:[Oracle Corporation]
[071316_070215247][][EXCEPTION] [DEBUG] [os.name]:[SunOS]
[071316_070215247][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
[071316_070215247][][EXCEPTION] [DEBUG] [cpid]:[1867690]
[071316_070215247][][EXCEPTION] [DEBUG] [sun.jnu.encoding]:[ISO8859-1]
[071316_070215247][][EXCEPTION] [DEBUG] [oracle.apps.fnd.common.Pool.leak.mode]:[stderr:off]
[071316_070215247][][EXCEPTION] [DEBUG] [java.library.path]:[/sssdshr/oraapp18/tech_st/10.1.3/lib32:/sssdshr/oraapp18/tech_st/10.1.3/lib:/sssdshr/oraapp18/apps_st/scd4appl/cz/12.0.0/bin:/sssdshr/oraapp18/apps_st/scd4appl/iby/12.0.0/bin:/sssdshr/oraapp18/apps_st/scd4appl/pon/12.0.0/bin:/sssdshr/oraapp18/apps_st/scd4appl/sht/12.0.0/lib:/usr/jdk/packages/lib/sparc:/lib:/usr/lib]
[071316_070215248][][EXCEPTION] [DEBUG] [java.specification.name]:[Java Platform API Specification]
[071316_070215248][][EXCEPTION] [DEBUG] [java.class.version]:[51.0]
[071316_070215248][][EXCEPTION] [DEBUG] [sun.management.compiler]:[HotSpot Tiered Compilers]
[071316_070215248][][EXCEPTION] [DEBUG] [queue_appl_id]:[0]
[071316_070215248][][EXCEPTION] [DEBUG] [os.version]:[5.10]
[071316_070215248][][EXCEPTION] [DEBUG] [LONG_RUNNING_JVM]:[true]
[071316_070215248][][EXCEPTION] [DEBUG] [user.home]:[/sssdshr/oraapp18]
[071316_070215248][][EXCEPTION] [DEBUG] [user.timezone]:[US/Eastern]
[071316_070215248][][EXCEPTION] [DEBUG] [java.awt.printerjob]:[sun.print.PSPrinterJob]
[071316_070215248][][EXCEPTION] [DEBUG] [file.encoding]:[ISO8859-1]
[071316_070215248][][EXCEPTION] [DEBUG] [java.specification.version]:[1.7]
[071316_070215248][][EXCEPTION] [DEBUG] [CACHEMODE]:[DISTRIBUTED]
[071316_070215249][][EXCEPTION] [DEBUG] [conc_queue_id]:[6272]
[071316_070215249][][EXCEPTION] [DEBUG] [java.class.path]:[/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/sssdshr/oraapp18/apps_st/scd4comn/java/lib/appsborg2.zip:/sssdshr/oraapp18/apps_st/scd4comn/java/classes:/sssdshr/oraapp18/apps_st/scd4appl/gecss/common/java/classes]
[071316_070215249][][EXCEPTION] [DEBUG] [user.name]:[applmgr3]
[071316_070215249][][EXCEPTION] [DEBUG] [DBCFILE]:[/d74/oracle/apps/scd4/appl/fnd/12.0.0/secure/scd4.dbc]
[071316_070215249][][EXCEPTION] [DEBUG] [java.vm.specification.version]:[1.7]
[071316_070215249][][EXCEPTION] [DEBUG] [sun.java.command]:[oracle.apps.fnd.cp.gsf.GSMServiceController]
[071316_070215249][][EXCEPTION] [DEBUG] [java.home]:[/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre]
[071316_070215249][][EXCEPTION] [DEBUG] [sun.arch.data.model]:[32]
[071316_070215249][][EXCEPTION] [DEBUG] [user.language]:[en]
[071316_070215250][][EXCEPTION] [DEBUG] [java.specification.vendor]:[Oracle Corporation]
[071316_070215250][][EXCEPTION] [DEBUG] [awt.toolkit]:[sun.awt.X11.XToolkit]
[071316_070215250][][EXCEPTION] [DEBUG] [java.vm.info]:[mixed mode]
[071316_070215250][][EXCEPTION] [DEBUG] [logfile]:[/sssdshr/appllog/ccm/scd4/log/FNDOPP1867690.txt]
[071316_070215250][][EXCEPTION] [DEBUG] [java.version]:[1.7.0_80]
[071316_070215250][][EXCEPTION] [DEBUG] [java.ext.dirs]:[/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/ext:/usr/jdk/packages/lib/ext]
[071316_070215250][][EXCEPTION] [DEBUG] [sun.boot.class.path]:[/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/resources.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/sunrsasign.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/jsse.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/jce.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/charsets.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/lib/jfr.jar:/sssdshr/oraapp18/tech_st/10.1.3/appsutil/jdk/jre/classes]
[071316_070215250][][EXCEPTION] [DEBUG] [java.vendor]:[Oracle Corporation]
[071316_070215250][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
[071316_070215251][][EXCEPTION] [DEBUG] [file.separator]:[/]
[071316_070215251][][EXCEPTION] [DEBUG] [java.vendor.url.bug]:[http://bugreport.sun.com/bugreport/]
[071316_070215251][][EXCEPTION] [DEBUG] [sun.io.unicode.encoding]:[UnicodeBig]
[071316_070215251][][EXCEPTION] [DEBUG] [sun.cpu.endian]:[big]
[071316_070215251][][EXCEPTION] [DEBUG] [APPLOUT]:[out]
[071316_070215251][][EXCEPTION] [DEBUG] [sun.cpu.isalist]:[]
[7/13/16 7:02:16 AM] [1867690:RT37599331] Output file was found but is zero sized – Deleted
[7/13/16 7:02:16 AM] [UNEXPECTED] [1867690:RT37599331] 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.invokeNewXSLStylesheet(XSLT10gR1.java:611)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:239)
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:302)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
Caused by: org.xml.sax.SAXException: Namespace prefix ‘ref’ used but not declared.
oracle.xdo.parser.v2.XPathException: Namespace prefix ‘ref’ used but not declared.
at oracle.xdo.parser.v2.XSLProcessor.reportException(XSLProcessor.java:806)
at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:571)
… 17 more
[7/13/16 7:02:16 AM] [1867690:RT37599331] Completed post-processing actions for request 37599331.
[7/13/16 7:10:47 AM] [OPPServiceThread0] Post-processing request 37599382.
[7/13/16 7:10:47 AM] [1867690:RT37599382] Executing post-processing actions for request 37599382.
[7/13/16 7:10:47 AM] [1867690:RT37599382] Starting XML Publisher post-processing action.
[7/13/16 7:10:47 AM] [1867690:RT37599382]
Template code: XXCUSTTRY
Template app: PO
Language: en
Territory: 00
Output type: EXCEL
[7/13/16 7:10:48 AM] [1867690:RT37599382] XML Publisher post-processing action complete.
[7/13/16 7:10:48 AM] [1867690:RT37599382] Completed post-processing actions for request 37599382.
Thanks. Please reply.
LikeLike
Hi Edi,
I have shifted my EBS from Test node to PROD Node, after the cloning on prod server i am getting the following error.
+————- 1) PUBLISH ————-+
Beginning post-processing of request 4113097 on node AR-TEST at 18-AUG-2016 15:58:58.
Post-processing of request 4113097 failed at 18-AUG-2016 16:02:58 with the error message:
The Output Post-processor is running but has not picked up this request.
No further attempts will be made to post-process this request, and the request will be marked
with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.
+————————————–+
kindly suggest the solution.
Thanks
LikeLike
Hi Edi,
getting following error ,could you plz help me on this …
lp: Too many active jobs.
Pasta: Error: Print failed. Command=lp -c -dnoprint /usr/tmp/PROD/pasta32093_0.tmp
Pasta: Error: Check printCommand/ntPrintCommand in pasta.cfg
Pasta: Error: Preprocess or Print command failed!!!
APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN. Program exited with status 1
Cause: AFPPRN received a return code of failure from the OSD routine FDUPRN. Program exited with status 1.
LikeLike
Hi Edi,
Can you please help me with the below error
+—————————————————————————+
Receivables: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
ARXCOBLX: Customer Open Balance Letter
+—————————————————————————+
Current system time is 17-MAY-2018 02:25:09
+—————————————————————————+
+—————————–
| Starting concurrent program execution…
+—————————–
Arguments
————
P_AS_OF_DATE=’2006/01/01 00:00:00′
P_CUSTOMER_NAME_FROM=’A. C. Networks’
P_CUSTOMER_NAME_TO=’A. C. Networks’
P_DEBUG_FLAG=’N’
P_TRACE_FLAG=’N’
————
Forcing NLS_NUMERIC_CHARACTERS to: ‘.,’ for XDO processing
APPLLCSP Environment Variable set to :
Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are :
American_America.AL32UTF8
‘.,’
BINARY
Enter Password:
Report Builder: Release 10.1.2.3.0 – Production on Thu May 17 02:25:16 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
Executing request completion options…
Output file size:
9719
+——— 1) POST-PROCESSING ———+
Beginning post-processing of request 7823071 on node EBSOL at 17-MAY-2018 02:25:18.
— Publishing output
Post-processing of request 7823071 failed at 17-May-2018 02:25:18 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
CONC-POST-PROCESSING RESULTS
— PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException
+—————————————+
Finished executing request completion options.
+—————————————————————————+
Concurrent request completed
Current system time is 17-MAY-2018 02:25:18
+—————————————————————————+
Thanks in advance !
LikeLike
Hi Edi,
I am creating multi tab xml report using xml publisher. Program is completed with warning.
+—————————————————————————+
XXC Custom Application: Version : 12.1
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
XXCIDCAR: Informa Daily Checking Activity Report
+—————————————————————————+
Current system time is 04-JUL-2019 13:38:39
+—————————————————————————+
XDO Data Engine Version No: 5.6.3
Resp: 55892
Org ID : 82
Request ID: 23796113
All Parameters:
Data Template Code: XXCIDCAR
Data Template Application Short Name: XXC
Debug Flag: N
{}
Calling XDO Data Engine…
[070419_133841681][][STATEMENT] Start process Data
[070419_133841683][][STATEMENT] Process Data …
[070419_133841683][][STATEMENT] Writing Data …
[070419_133841684][][STATEMENT] Sql Query :Q_1_1: select SYDOCO, SYAN8, SYDEL2, SYDEL1, STATUS, PROCESS_FLAG,to_char(CREATION_DATE, ‘DD-MON-YYYY’), to_char(LAST_UPDATE_DATE, ‘DD-MON-YYYY’)
from xxc_ubm_p1_int002_ordimph_stg
where sydoco in (select sydoco from xxc_ubm_p1_int002_ordimph_stg
minus
select attribute6 from oe_order_headers_all)
and status is not null
[070419_133842218][][STATEMENT] Sql Query :Q_1_2: select count(*) CNT from xxc_ubm_p1_int002_ordimph_stg
where SYDOCO IS NULL
[070419_133842229][][STATEMENT] Sql Query :Q_1_3: select count(*) CNT1 from xxc_ubm_p1_int002_ordimpl_stg
where SZDOCO IS NULL
[070419_133842290][][STATEMENT] Sql Query :Q_1_4: select count(*) CNT2 from xxc_ubm_p1_int002_ordimph_stg
where SYDOCO NOT IN ( select SZDOCO from xxc_ubm_p1_int002_ordimpl_stg)
[070419_133842368][][STATEMENT] Sql Query :Q_1_5: select count(*) CNT3 from xxc_ubm_p1_int002_ordimpl_stg
where SZDOCO NOT IN ( select SYDOCO from xxc_ubm_p1_int002_ordimph_stg)
[070419_133842455][][STATEMENT] Sql Query :Q_2_1: select INTERFACE_LINE_ID
,INTERFACE_LINE_CONTEXT
,INTERFACE_LINE_ATTRIBUTE1
,BATCH_SOURCE_NAME
,CURRENCY_CODE
,AMOUNT
,ORIG_SYSTEM_BATCH_NAME
,ORIG_SYSTEM_BILL_CUSTOMER_REF
,ORIG_SYSTEM_BILL_CUSTOMER_ID
,ORIG_SYSTEM_BILL_ADDRESS_REF
,ORIG_SYSTEM_BILL_ADDRESS_ID
,ORIG_SYSTEM_BILL_CONTACT_REF
,ORIG_SYSTEM_BILL_CONTACT_ID
,ORIG_SYSTEM_SHIP_CUSTOMER_REF
,ORIG_SYSTEM_SHIP_CUSTOMER_ID
,ORIG_SYSTEM_SHIP_ADDRESS_REF
,ORIG_SYSTEM_SHIP_ADDRESS_ID
,ORIG_SYSTEM_SHIP_CONTACT_REF
,ORIG_SYSTEM_SHIP_CONTACT_ID
,ORIG_SYSTEM_SOLD_CUSTOMER_REF
,ORIG_SYSTEM_SOLD_CUSTOMER_ID
,ORG_ID
,TAX_RATE
,TAX_CODE
,TAX_PRECEDENCE
,VAT_TAX_ID
,TAX_EXEMPT_FLAG
,TAX_EXEMPT_REASON_CODE
,TAX_EXEMPT_REASON_CODE_MEANING
,TAX_EXEMPT_NUMBER
,SALES_TAX_ID
,AMOUNT_INCLUDES_TAX_FLAG
,SOURCE_TRX_DETAIL_TAX_LINE_ID
,HISTORICAL_FLAG
,TAX_REGIME_CODE
,TAX
,TAX_STATUS_CODE
,TAX_RATE_CODE
,TAX_JURISDICTION_CODE
,TAXABLE_AMOUNT
,TAXABLE_FLAG
,LEGAL_ENTITY_ID
,TAX_INVOICE_DATE
,TAX_INVOICE_NUMBER
from RA_INTERFACE_LINES_ALL
WHERE ORG_ID IN (’82’,’84’,’101′)
AND INTERFACE_STATUS IS NULL
AND interface_line_attribute2 not like ‘BR%’
AND INTERFACE_LINE_CONTEXT ‘EMS’
–AND INTERFACE_LINE_CONTEXT ‘UBM_ADV_ELAN’
AND CREATION_DATE >= ’01-SEP-2017′
[070419_133842523][][STATEMENT] Sql Query :Q_2_2: Select INTERFACE_LINE_ID INTERFACE_LINE_ID1, INTERFACE_SALESCREDIT_ID, INTERFACE_DISTRIBUTION_ID, MESSAGE_TEXT from apps.RA_INTERFACE_ERRORS_ALL where INTERFACE_LINE_ID in (select INTERFACE_LINE_ID from RA_INTERFACE_LINES_ALL
WHERE ORG_ID IN (’82’,’84’,’101′)
AND INTERFACE_STATUS IS NULL
AND interface_line_attribute2 not like ‘BR%’
AND INTERFACE_LINE_CONTEXT ‘EMS’
–AND INTERFACE_LINE_CONTEXT ‘UBM_ADV_ELAN’
AND CREATION_DATE >= ’01-SEP-2017′)
[070419_133842526][][EVENT] Data Generation Completed…
[070419_133842526][][EVENT] Total Data Generation Time 1.0 seconds
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
Executing request completion options…
Output file size:
75347
+——— 1) POST-PROCESSING ———+
Beginning post-processing of request 23796113 on node DLOUBEBA6P at 04-JUL-2019 13:38:42.
— Publishing output
Post-processing of request 23796113 failed at 04-JUL-2019 13:38:42 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
CONC-POST-PROCESSING RESULTS
— PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException: This file is not an MS OLE compound file.
+—————————————+
Finished executing request completion options.
+—————————————————————————+
Concurrent request completed
Current system time is 04-JUL-2019 13:38:42
+—————————————————————————+
LikeLike
1 | bhasker
May 27, 2009 at 1:45 AM
Hi,
I am getting the following error when using the xml publisher report. Can anyone help in this issue.
+————- 1) PUBLISH ————-+
Beginning post-processing of request 6970140 on node AZ18U532 at 26-MAY-2009 10:01:32.
Post-processing of request 6970140 failed at 26-MAY-2009 10:06:05 with the error message:
java.lang.NoClassDefFoundError: org/xml/sax/Attributes
+————————————–+
LikeLike