6 Replies Latest reply on Mar 23, 2020 7:24 PM by Aldrich

    OPP intermittently times out, but rerun does not

    Aldrich

      We submit OPP (Output Post Processor) concurrent manager jobs that intermittently times out, but a rerun of the same job while the original is still "running" will complete in a couple seconds.

       

      Any thoughts as to why?

       

      We are on Oracle EBS 12.1.3.

       

      We have 1 OPP process with 10 threads, we have also tried 2 OPP with 5 threads.  Same result.  No substantive errors.  THe message in the log is:

      "Post-processing of request 56437935 failed at 27-JAN-2020 09:27:41 with the error message:

      The concurrent manager has timed out waiting for the Output Post-processor to finish this request."

        • 1. Re: OPP intermittently times out, but rerun does not
          Aldrich

          We updated the "UTL_FILE Mode" profile option to "Use PUT_RAW" and it seemed to reduce the frequency of issues.  But issue still exists (just not as frequent).

          • 2. Re: OPP intermittently times out, but rerun does not
            Aldrich

            Enabling strace on the PID seemed to get rid of issue, but still do not know why.  Submitted SR with Oracle and still sits there.

            • 3. Re: OPP intermittently times out, but rerun does not
              Maaz Khan

              Hello Aldrich,

               

              Please let us know if you are facing this issue for particular program or all programs that require OPP to process them.

              Also let us know exact error details in concurrent program log file.

               

              Please share output for below query -

              select DEVELOPER_PARAMETERS from FND_CP_SERVICES

              where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES

              where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

               

              profile options:

               

              Concurrent:OPP Process Timeout

              Concurrent:OPP Response Timeout

               

               

               

              Regards,

              Maaz

              • 4. Re: OPP intermittently times out, but rerun does not
                Aldrich

                It happens for all/most programs that use OPP.  It doesn't occur everytime.  It is at random.  Maybe less than 20% of the time.  (never occurs when strace is enabled)

                 

                Error/Warning (it shows timeout, but take note, this takes 3 seconds to finish when it finishes and there are no other OPP processes running at the time...):

                +--------- 1) POST-PROCESSING ---------+

                Beginning post-processing of request 56837925 on node <redacted> at 27-FEB-2020 12:47:14.

                -- Publishing output

                 

                 

                Post-processing of request <redacted> failed at 27-FEB-2020 14:27:14 with the error message:

                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.

                 

                CONC-POST-PROCESSING RESULTS

                +---------------------------------------+

                 

                DEVELOPER_PARAMETERS

                ----------------------------------------------------------------------------------------------------------------

                J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx5120m -Djava.awt.headless=true

                 

                Concurrent:OPP Process Timeout=5400

                Concurrent:OPP Response Timeout=600

                • 5. Re: OPP intermittently times out, but rerun does not
                  lmu

                  two things I would check.

                   

                  1.  Check what you have set as the tmp directory and the size of it.

                   

                  XML Publisher Administrator -> Administrator -> General -> Temporary directory

                   

                  2.  How many processes do you have set and how many threads?

                   

                  System Administrator -> OAM -> Site Map -> Application Services -> Generic Services -> Output Post Processor ->click on it.

                  Select Output Post Processor -> Edit

                  Check what is set for processes and thread.  You can also see this without clicking Edit.  It is under Target Processes and Threads per Process.

                   


                  We have this set for

                  Concurrent:OPP Process Timeout =86400

                  Concurrent:OPP Response Timeout = 3600

                  • 6. Re: OPP intermittently times out, but rerun does not
                    Aldrich

                    I wanted to update the issue goes away when we circumvent the firewall between DB nodes and Concurrent Manager node and connect via Layer 2.  We have stuff to look into on our side.