CASE1:
While we run an XML publisher report while testing, sometimes we see that the expected output in PDF/EXCEL format has not generated while the report completed with warning and also the XML got generated properly. Log file message is as given below:
LOG FILE message:
————–
+------------- 1) PUBLISH -------------+Beginning post-processing of request 32749775 on node FIJICRP1APP01 at 13-MAR-2012 03:13:15.Post-processing of request 32749775 failed at 13-MAR-2012 03:33:16 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 markedwith Warning status.Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.+--------------------------------------+
Basically the Post-processor is not picking up the report generated XML for converting that to PDF. For fixing this we need to increase the number of the output Post Processor by following below steps:
Increase the number of Output Post Processors as follows:
- Logon to Applications with “System Administrator” responsibility.
- Navigate to Concurrent -> Manager -> Define.
- Query for the “Output Post Processor” service.
- Click on “Work Shifts” and increase the number of processes.
For example: If there is currently a setting of 2 processes then increase it to 4.Note: Ensure there is a setting of: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5 under Parameters.
Also better if you increase the Post processor timeout time from the profile option
Increase the value of the profile option “Concurrent: OPP Process Timeout” as follows:
- Logon to Applications with “System Administrator” responsibility.
- Navigate to Profile -> System.
- Query for “Concurrent:OPP Response Timeout” profile option.
For example: If the value of the Concurrent:OPP Response Timeout profile option is 120 then increase it to 10800.Query for “Concurrent:OPP Process Timeout” profile option.
Increase the setting to a higher value:
Set the value to 10800
sec (3 hours)
You should get your report output in PDF format now and report status should be completed successfully.
———-
CASE2:
Sometimes I have seen cases where the report is completed successfully but still the output is coming in XML format not in the PDF format. It happens specially, if you are in the process of upgrading an 11i report to R12 version. Here is the solution for that.
While submitting the concurrent program from SRS, check the LAYOUT > Options check if it is as below or not:
Format column value should be PDF as shown above. If it is not, then that is the reason for the problem. To fix this, go to ‘XML Publisher Administrator’ responsibility and query for that template.
Update the’ Default Output Type’ for that template to ‘PDF’.
0 comments