1 2 Previous Next 23 Replies Latest reply: May 27, 2010 12:03 AM by Hussein Sawwan-Oracle RSS

    Concurrent Manager (Output Post Processor) down

    762809
      Hi,

      EBS 11i
      RHEL 4.6

      I checked the status of our Concurrent Manager > Output Post Processor

      and the status is actual=0 target=1

      I run cmclean.sql but still the status not changing.

      What other solutions to resolve this issue?


      Thanks a lot,

      Ms K
        • 1. Re: Concurrent Manager (Output Post Processor) down
          mdtaylor
          Check the profile option Concurrent:GSM Enabled. It needs to be Y at the site.

          Click on Output Post Processor in Concurrent Administer Manager form, and press Restart. If it does not start, click on Processes, select the top line, and View Manager Log. Post the contents in this thread.

          Regards,
          -Michael
          • 2. Re: Concurrent Manager (Output Post Processor) down
            762809
            Thanks ,

            I done the profile, but to no avail.
            I restart it but it just hanged.

            Wait, i send the log...
            • 3. Re: Concurrent Manager (Output Post Processor) down
              762809
              Hi :)

              Heres the output of Manager Log
              [4/28/10 6:33:15 AM] [main] Starting GSF service with concurrent process id = 18152.
              [4/28/10 6:33:15 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
              [4/28/10 6:33:15 AM] [Thread-13] Service thread starting up.
              [4/28/10 6:33:15 AM] [Thread-14] Service thread starting up.
              [4/28/10 8:09:46 AM] [OPPServiceThread0] Post-processing request 1579523.
              [4/28/10 8:09:46 AM] [18152:RT1579523] Executing post-processing actions for request 1579523.
              [4/28/10 8:09:46 AM] [18152:RT1579523] Starting XML Publisher post-processing action.
              [4/28/10 8:09:46 AM] [18152:RT1579523] 
              Template code: ARXAGE
              Template app:  AR
              Language:      en
              Territory:     PH
              Output type:   PDF
              [4/28/10 8:09:52 AM] [18152:RT1579523] XML Publisher post-processing action complete.
              [4/28/10 8:09:52 AM] [18152:RT1579523] Completed post-processing actions for request 1579523.
              [4/28/10 12:01:42 PM] [OPPServiceThread0] Post-processing request 1579641.
              [4/28/10 12:01:42 PM] [18152:RT1579641] Executing post-processing actions for request 1579641.
              [4/28/10 12:01:42 PM] [18152:RT1579641] Starting XML Publisher post-processing action.
              [4/28/10 12:01:42 PM] [18152:RT1579641] 
              Template code: INVTRREG
              Template app:  INV
              Language:      en
              Territory:     PH
              Output type:   PDF
              [4/28/10 12:01:42 PM] [18152:RT1579641] XML Publisher post-processing action complete.
              [4/28/10 12:01:42 PM] [18152:RT1579641] Completed post-processing actions for request 1579641.
              [4/28/10 12:02:40 PM] [OPPServiceThread0] Post-processing request 1579643.
              [4/28/10 12:02:40 PM] [18152:RT1579643] Executing post-processing actions for request 1579643.
              [4/28/10 12:02:40 PM] [18152:RT1579643] Starting XML Publisher post-processing action.
              [4/28/10 12:02:40 PM] [18152:RT1579643] 
              Template code: INVTRREG
              Template app:  INV
              Language:      en
              Territory:     PH
              Output type:   PDF
              [4/28/10 12:02:41 PM] [18152:RT1579643] XML Publisher post-processing action complete.
              [4/28/10 12:02:41 PM] [18152:RT1579643] Completed post-processing actions for request 1579643.
              [4/28/10 9:49:28 PM] [EXCEPTION] [OPPAQMON:18152] ORA-01089: immediate shutdown in progress - no operations are permitted
              [4/28/10 9:49:28 PM] [UNEXPECTED] [GSMServiceController:18152] oracle.apps.fnd.cp.gsm.GenCartSetStatusException: ORA-01089: immediate shutdown in progress - no operations are permitted
              
                   at oracle.apps.fnd.cp.gsm.GenCartComm.setQueueStatus(GenCartComm.java:148)
                   at oracle.apps.fnd.cp.gsf.GSMStateMonitor.setNewStatus(GSMStateMonitor.java:123)
                   at oracle.apps.fnd.cp.gsf.GSMServiceController.updateQueueInfo(GSMServiceController.java:391)
                   at oracle.apps.fnd.cp.gsf.GSMServiceController.mainLoop(GSMServiceController.java:234)
                   at oracle.apps.fnd.cp.gsf.BaseServiceController.run(BaseServiceController.java:71)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:49:28 PM] [UNEXPECTED] [GSMServiceController:18152] oracle.apps.fnd.cp.gsm.GenCartGetMessageException: ORA-01089: immediate shutdown in progress - no operations are permitted
              
                   at oracle.apps.fnd.cp.gsm.GenCartComm.getQueueMessage(GenCartComm.java:200)
                   at oracle.apps.fnd.cp.gsf.GSMStateMonitor.waitForNextEvent(GSMStateMonitor.java:95)
                   at oracle.apps.fnd.cp.gsf.GSMServiceController.mainLoop(GSMServiceController.java:236)
                   at oracle.apps.fnd.cp.gsf.BaseServiceController.run(BaseServiceController.java:71)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:49:28 PM] [UNEXPECTED] [GSMServiceController:18152] oracle.apps.fnd.cp.gsm.GenCartSetStatusException: ORA-01089: immediate shutdown in progress - no operations are permitted
              
                   at oracle.apps.fnd.cp.gsm.GenCartComm.setQueueStatus(GenCartComm.java:148)
                   at oracle.apps.fnd.cp.gsf.GSMStateMonitor.setNewStatus(GSMStateMonitor.java:123)
                   at oracle.apps.fnd.cp.gsf.GSMServiceController.updateQueueInfo(GSMServiceController.java:391)
                   at oracle.apps.fnd.cp.gsf.GSMServiceController.stop(GSMServiceController.java:303)
                   at oracle.apps.fnd.cp.gsf.GSMServiceController.mainLoop(GSMServiceController.java:251)
                   at oracle.apps.fnd.cp.gsf.BaseServiceController.run(BaseServiceController.java:71)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:49:28 PM] [GSMServiceController:18152] CONC-GSF-SERVICE EXITING
              [4/28/10 9:49:28 PM] [GSMServiceController:18152] CONC-GSF-STOPPING THREADS
              [4/28/10 9:49:28 PM] [OPPServiceThread0] CONC-OPP-ST EXITING
              [4/28/10 9:49:28 PM] [OPPServiceThread1] CONC-OPP-ST EXITING
              [4/28/10 9:49:28 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: ORA-01089: immediate shutdown in progress - no operations are permitted
              
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
                   at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
                   at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
                   at oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Protocol.java:977)
                   at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2199)
                   at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2059)
                   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2976)
                   at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
                   at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:734)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:412)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:49:48 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: No more data to read from socket
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
                   at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:961)
                   at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
                   at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:382)
                   at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
                   at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
                   at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2185)
                   at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2059)
                   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2976)
                   at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
                   at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:734)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:412)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:50:08 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Io exception: Broken pipe
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
                   at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3664)
                   at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1985)
                   at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
                   at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2185)
                   at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2059)
                   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2976)
                   at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
                   at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:734)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:412)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:50:28 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:402)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:50:48 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:402)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:51:08 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:402)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:51:28 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:402)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:51:48 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:402)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:52:08 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:402)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:52:28 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:402)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:52:48 PM] [UNEXPECTED] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.waitForMessage(OPPAQMonitor.java:402)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:110)
                   at java.lang.Thread.run(Thread.java:534)
              
              [4/28/10 9:52:48 PM] [UNEXPECTED] [OPPAQMON:18152] Too many SQL errors, shutting down AQ monitor
              [4/28/10 9:52:48 PM] [EXCEPTION] [OPPAQMON:18152] java.sql.SQLException: Closed Connection
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
                   at oracle.jdbc.driver.OracleConnection.privatePrepareCall(OracleConnection.java:1163)
                   at oracle.jdbc.driver.OracleConnection.prepareCall(OracleConnection.java:1075)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.unsubscribeFromAQ(OPPAQMonitor.java:574)
                   at oracle.apps.fnd.cp.opp.OPPAQMonitor.run(OPPAQMonitor.java:131)
                   at java.lang.Thread.run(Thread.java:534)
              Why is that the latest log date is april 28? and not May 21?

              Thanks again
              • 4. Re: Concurrent Manager (Output Post Processor) down
                Helios-GunesEROL
                Hi;

                Did you have this error today? If yes please search as in log 21 May

                Regard
                Helios
                • 5. Re: Concurrent Manager (Output Post Processor) down
                  Helios-GunesEROL
                  Hi again;

                  Please also check for how you can check OPP log

                  Re: Problems in Output Post processor : it stops on its own

                  Regard
                  Helios
                  • 6. Re: Concurrent Manager (Output Post Processor) down
                    Hussein Sawwan-Oracle
                    Hi,
                    [EXCEPTION] [OPPAQMON:18152] ORA-01089: immediate shutdown in progress - no operations are permitted
                    Please see these documents.

                    Note: 780505.1 - OPP Does Not Start After Bouncing The Database
                    Note: 751652.1 - Output Post Processor Not Coming Up After R12.0.4 Upgrade
                    Note: 779873.1 - BI Publisher Report Generates The Output As XML Instead Of Excel

                    Thanks,
                    Hussein
                    • 7. Re: Concurrent Manager (Output Post Processor) down
                      762809
                      Thanks a lot everyone,

                      I just am confused, After running cmclean.sql the status is still actual=0 target=1
                      but the user said "Inventory transaction register report" which has PDF out is ok now, before with error
                      it becomes turns to XML format? I just can not get it.
                      Maybe it is again the result of data inconsistencies on the side of "monitoring" page? the page does not get the actual value from the database? just like I encountered in OAM dashboard. :(

                      How can I clean the form page status?

                      Edited by: user_unlimited on May 23, 2010 5:58 PM
                      • 8. Re: Concurrent Manager (Output Post Processor) down
                        Hussein Sawwan-Oracle
                        Hi,
                        I just am confused, After running cmclean.sql the status is still actual=0 target=1
                        Any errors in the CM log files?
                        but the user said "Inventory transaction register report" which has PDF out is ok now, before with error
                        it becomes turns to XML format? I just can not get it.
                        Do you mean the format is correct and you are able to run/view the concurrent program?

                        Thanks,
                        Hussein
                        • 9. Re: Concurrent Manager (Output Post Processor) down
                          762809
                          Yeah, well the users said it :) I dont know how to run the report becoz i ask lots of parameters :D
                          But I can not understand why the OP has still status actual=0 target=1.

                          Or are they related to the concurrent program "Inventory Transaction Register Report"?
                          Or does this report uses "Output Post Processor'?

                          Edited by: user_unlimited on May 23, 2010 6:01 PM
                          • 10. Re: Concurrent Manager (Output Post Processor) down
                            Hussein Sawwan-Oracle
                            Hi,
                            yeah, well the users said it
                            So, there should be no issue! Please confirm.
                            I dont know how to run the report becoz i ask lots of parameters
                            You can get the list of parameters you need to pass to this concurrent program from the same concurrent program which was submitted by the user and completed successfully.

                            Thanks,
                            Hussein
                            • 11. Re: Concurrent Manager (Output Post Processor) down
                              762809
                              The issue is how can I make OPP status actual=1 target=1 :(
                              Its misleading. There is something I need to clean on the database side.

                              Edited by: user_unlimited on May 23, 2010 6:05 PM
                              • 12. Re: Concurrent Manager (Output Post Processor) down
                                Hussein Sawwan-Oracle
                                Hi,
                                The issue is how can I make OPP status actual=1 target=1 :(
                                Its misleading. There is something I need to clean on the database side.
                                You have been already requested to check the OPP log file.

                                Thanks,
                                Hussein
                                • 13. Re: Concurrent Manager (Output Post Processor) down
                                  762809
                                  Is it the one I posted above? the one michael asked.

                                  How do I get the OPP log again?
                                  • 14. Re: Concurrent Manager (Output Post Processor) down
                                    Hussein Sawwan-Oracle
                                    Hi,

                                    Check the log file after running the cmclean.sql script.

                                    The OPP log file can be found under APPLCSF/$APPLLOG directory (search for FNDOPP*).

                                    Thanks,
                                    Hussein
                                    1 2 Previous Next