Posted by: Edi Yanto on: February 7, 2009
Three possible errors can occur as below:
…
+————- 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:
- Via the Oracle Application Manager
...
+------------- 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‘.
…
+————- 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:
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‘.
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
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
Hi Raj,
Thanks for sharing the BI Publisher debugging and logging article.
Thanks,
Edi
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
+—————————————————————————+
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.
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.
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
+————————————–+