1 2 Previous Next 28 Replies Latest reply: Oct 26, 2012 9:41 AM by Hussein Sawwan-Oracle Go to original post RSS
      • 15. Re: Workflow error
        dkoracle
        Hi Hussein,

        This note was really helpful " Database Initialization Parameters for Oracle E-Business Suite Release 12 [ID 396009.1] "












        Regards,
        dkoracle
        • 16. Re: Workflow error
          Hussein Sawwan-Oracle
          But please help me to understand how job_queue_process parameter linked with Notification mailer. Also please provide me some metalink note to understand the architecture of this workflow. I really understand there are lot of challenges involved here need to know about workflow configurations, setups and troubleshooting technique tips
          Need your guidance to move in right way..
          Please see these docs.

          Health Check Alert: Set the database parameter 'JOB_QUEUE_PROCESSES' greater than or equal to 10 [ID 957493.1]
          Reprice_Line Deferred Is Not Picked Up by Workflow Background Process [ID 1079682.1]
          Troubleshooting Workflow Agent Listener's Failure To Start [ID 469009.1]
          bde_wf_bkg.sql - Workflow Background Process Related Data (Advanced Queues) [ID 255039.1]

          Thanks,
          Hussein
          • 17. Re: Workflow error
            Hussein Sawwan-Oracle
            dkoracle wrote:
            Hi Hussein,

            This note was really helpful " Database Initialization Parameters for Oracle E-Business Suite Release 12 [ID 396009.1] "
            Thanks!
            • 18. Re: Workflow error
              dkoracle
              Thanks Hussein...


              Need a help from you. I would like to automate this process using shell script.. Like if this mailer comes down again it should be made up and running from backend not through OAM again.. Is there any oracle sql script to update corresponding values in table if workflow Notification mailer goes down



              Regards,
              Dkoracle
              • 19. Re: Workflow error
                Srini Chavali-Oracle
                Pl see these MOS Docs

                How to Check if the Workflow Mailer is Running [ID 1054215.1]
                How to Stop/Start Workflow Service Containers From Command Line [ID 743264.1]

                HTH
                Srini
                • 20. Re: Workflow error
                  Hussein Sawwan-Oracle
                  Need a help from you. I would like to automate this process using shell script.. Like if this mailer comes down again it should be made up and running from backend not through OAM again.. Is there any oracle sql script to update corresponding values in table if workflow Notification mailer goes down
                  Yes.

                  How to Troubleshoot when the Workflow Services Go Down [ID 564394.1] -- A. How to determine if the workflow services are up and running?
                  Workflow Java Mailer & Notifications FAQ [ID 562551.1] -- 2. Restart the Workflow Mailer and Agent Listener services

                  Thanks,
                  Hussein
                  • 21. Re: Workflow error
                    dkoracle
                    Hi Hussein,

                    In PROD all my workflow services are working fine and running. But users are complaining they are not receiving any notifications.. Please help on this..

                    I read your previous older posts and did successful telnet connections too.. Cant able to find out why this is happening

                    Saw in wf_notifications table by this query
                     select BEGIN_DATE,END_DATE,MESSAGE_TYPE,MESSAGE_NAME,RECIPIENT_ROLE,STATUS,MAIL_STATUS from wf_notifications where MAIL_STATUS='FAILED' and BEGIN_DATE > '10-OCT-2012' order by BEGIN_DATE 
                    Got some output.. so error is there..pls guide me


                    Regards,
                    dkoracle
                    • 22. Re: Workflow error
                      Hussein Sawwan-Oracle
                      Hi dkoracle,
                      Hi Hussein,

                      In PROD all my workflow services are working fine and running. But users are complaining they are not receiving any notifications.. Please help on this..

                      I read your previous older posts and did successful telnet connections too.. Cant able to find out why this is happening

                      Saw in wf_notifications table by this query

                      select BEGIN_DATE,END_DATE,MESSAGE_TYPE,MESSAGE_NAME,RECIPIENT_ROLE,STATUS,MAIL_STATUS
                      from wf_notifications
                      where MAIL_STATUS='FAILED' and BEGIN_DATE > '10-OCT-2012' order by BEGIN_DATE

                      Got some output.. so error is there..pls guide me
                      Can you find any errors in the Workflow log file?

                      Is the issue with all notifications or with specific ones only?

                      Thanks,
                      Hussein
                      • 23. Re: Workflow error
                        dkoracle
                        Hi Hussien,

                        Error in Log file took it from OAM:
                        JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062226200:3250:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.opened(ConnectionEvent)]:Store connection has been opened
                        [Oct 12, 2012 12:17:06 PM CDT]:1350062226646:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062226646:3251:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.opened(ConnectionEvent)]:INBOX connection has been opened
                        [Oct 12, 2012 12:17:07 PM CDT]:1350062227526:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.read()]:Reading message
                        [Oct 12, 2012 12:17:07 PM CDT]:1350062227527:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Reading new messages
                        [Oct 12, 2012 12:17:07 PM CDT]:1350062227573:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Message list is empty
                        [Oct 12, 2012 12:17:07 PM CDT]:1350062227573:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.performClose()]:BEGIN
                        [Oct 12, 2012 12:17:07 PM CDT]:1350062227573:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.close()]:Closing connection
                        [Oct 12, 2012 12:17:08 PM CDT]:1350062228620:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062226646:3251:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:INBOX connection has been closed
                        [Oct 12, 2012 12:17:09 PM CDT]:1350062229622:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062226200:3250:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:Store connection has been closed
                        [Oct 12, 2012 12:17:10 PM CDT]:1350062230578:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN
                        [Oct 12, 2012 12:17:10 PM CDT]:1350062230578:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 35 seconds (35000 ms)
                        [Oct 12, 2012 12:17:43 PM CDT]:1350062263083:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.
                        [Oct 12, 2012 12:17:43 PM CDT]:1350062263083:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)
                        [Oct 12, 2012 12:17:43 PM CDT]:1350062263084:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.
                        [Oct 12, 2012 12:17:43 PM CDT]:1350062263084:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.process()]:BEGIN
                        [Oct 12, 2012 12:17:43 PM CDT]:1350062263084:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read]:BEGIN
                        [Oct 12, 2012 12:17:43 PM CDT]:1350062263084:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.read()]:BEGIN [default implementation]
                        [Oct 12, 2012 12:17:43 PM CDT]:1350062263084:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[fnd.wf.bes.QueueHandlerInvoker]:dequeue() BEGIN
                        [Oct 12, 2012 12:17:43 PM CDT]:1350062263084:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :BEGIN
                        [Oct 12, 2012 12:17:45 PM CDT]:1350062265586:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.
                        [Oct 12, 2012 12:17:45 PM CDT]:1350062265587:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)
                        [Oct 12, 2012 12:17:45 PM CDT]:1350062265587:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.
                        [Oct 12, 2012 12:17:45 PM CDT]:1350062265587:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.process()]:BEGIN
                        [Oct 12, 2012 12:17:45 PM CDT]:1350062265587:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.performOpen()]:BEGIN
                        [Oct 12, 2012 12:17:46 PM CDT]:1350062266588:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Connecting to store.
                        [Oct 12, 2012 12:17:47 PM CDT]:1350062267271:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062267271:3252:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.opened(ConnectionEvent)]:Store connection has been opened
                        [Oct 12, 2012 12:17:47 PM CDT]:1350062267701:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062267701:3253:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.opened(ConnectionEvent)]:INBOX connection has been opened
                        [Oct 12, 2012 12:17:48 PM CDT]:1350062268593:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.read()]:Reading message
                        [Oct 12, 2012 12:17:48 PM CDT]:1350062268593:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Reading new messages
                        [Oct 12, 2012 12:17:48 PM CDT]:1350062268639:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Message list is empty
                        [Oct 12, 2012 12:17:48 PM CDT]:1350062268639:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.performClose()]:BEGIN
                        [Oct 12, 2012 12:17:48 PM CDT]:1350062268639:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.close()]:Closing connection
                        [Oct 12, 2012 12:17:49 PM CDT]:1350062269687:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062267701:3253:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:INBOX connection has been closed
                        [Oct 12, 2012 12:17:50 PM CDT]:1350062270689:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062267271:3252:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:Store connection has been closed
                        [Oct 12, 2012 12:17:51 PM CDT]:1350062271645:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN
                        [Oct 12, 2012 12:17:51 PM CDT]:1350062271645:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 40 seconds (40000 ms)
                        [Oct 12, 2012 12:17:53 PM CDT]:1350062273093:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Read timed out.
                        [Oct 12, 2012 12:17:53 PM CDT]:1350062273093:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read]:No pending messages. super.read returned NULL.
                        [Oct 12, 2012 12:17:53 PM CDT]:1350062273093:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN
                        [Oct 12, 2012 12:17:53 PM CDT]:1350062273093:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 50 seconds (50000 ms)
                        [Oct 12, 2012 12:18:31 PM CDT]:1350062311654:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.
                        [Oct 12, 2012 12:18:31 PM CDT]:1350062311654:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)
                        [Oct 12, 2012 12:18:31 PM CDT]:1350062311654:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.
                        [Oct 12, 2012 12:18:31 PM CDT]:1350062311654:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.process()]:BEGIN
                        [Oct 12, 2012 12:18:31 PM CDT]:1350062311654:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.performOpen()]:BEGIN
                        [Oct 12, 2012 12:18:32 PM CDT]:1350062312656:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Connecting to store.
                        [Oct 12, 2012 12:18:33 PM CDT]:1350062313344:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062313344:3254:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.opened(ConnectionEvent)]:Store connection has been opened
                        [Oct 12, 2012 12:18:33 PM CDT]:1350062313777:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062313777:3255:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.opened(ConnectionEvent)]:INBOX connection has been opened
                        [Oct 12, 2012 12:18:34 PM CDT]:1350062314660:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.read()]:Reading message
                        [Oct 12, 2012 12:18:34 PM CDT]:1350062314660:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Reading new messages
                        [Oct 12, 2012 12:18:34 PM CDT]:1350062314709:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Message list is empty
                        [Oct 12, 2012 12:18:34 PM CDT]:1350062314709:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.performClose()]:BEGIN
                        [Oct 12, 2012 12:18:34 PM CDT]:1350062314709:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.close()]:Closing connection
                        [Oct 12, 2012 12:18:35 PM CDT]:1350062315757:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062313777:3255:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:INBOX connection has been closed
                        [Oct 12, 2012 12:18:36 PM CDT]:1350062316759:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:1798236383:65424:1350062313344:3254:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:Store connection has been closed
                        [Oct 12, 2012 12:18:37 PM CDT]:1350062317715:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN
                        [Oct 12, 2012 12:18:37 PM CDT]:1350062317715:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:1798236383:65424:1350047388485:2449:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 45 seconds (45000 ms)
                        [Oct 12, 2012 12:18:43 PM CDT]:1350062323103:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.
                        [Oct 12, 2012 12:18:43 PM CDT]:1350062323103:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)
                        [Oct 12, 2012 12:18:43 PM CDT]:1350062323103:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.
                        [Oct 12, 2012 12:18:43 PM CDT]:1350062323103:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.process()]:BEGIN
                        [Oct 12, 2012 12:18:43 PM CDT]:1350062323103:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read]:BEGIN
                        [Oct 12, 2012 12:18:43 PM CDT]:1350062323103:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.read()]:BEGIN [default implementation]
                        [Oct 12, 2012 12:18:43 PM CDT]:1350062323103:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[fnd.wf.bes.QueueHandlerInvoker]:dequeue() BEGIN
                        [Oct 12, 2012 12:18:43 PM CDT]:1350062323103:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :BEGIN
                        [Oct 12, 2012 12:18:53 PM CDT]:1350062333128:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Read timed out.
                        [Oct 12, 2012 12:18:53 PM CDT]:1350062333128:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read]:No pending messages. super.read returned NULL.
                        [Oct 12, 2012 12:18:53 PM CDT]:1350062333128:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:PROCEDURE:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN
                        [Oct 12, 2012 12:18:53 PM CDT]:1350062333128:-1:-1:fcpgapps01.ameron.com:192.168.40.100:-1:-1:1:20420:SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:1798236383:65424:1350047388507:2450:STATEMENT:[SVC-GSM-WFMLRSVC-600397-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 55 seconds (55000 ms)
                        Few group of users are complaining they are not getting the requests which got approved..

                        NOTE: I bounced workflow services too and all the components are running fine

                        Regards,
                        Dilip
                        • 24. Re: Workflow error
                          Hussein Sawwan-Oracle
                          Few group of users are complaining they are not getting the requests which got approved..
                          Have you compared the preferences settings for those users with the users that receive emails?

                          Thanks,
                          Hussein
                          • 25. Re: Workflow error
                            dkoracle
                            Hi Hussein,

                            Preferences are not disabled for active users.. worked with SR support and they gave some suggestions. But id dint apply any of these below steps now workflow is going normal i am testing their suggestions on TEST instance first
                            This is what is most likely changing your notification preferences.
                            
                            1. You are running the concurrent program Synchronize WF LOCAL tables
                            This is obsolete and can cause issues with users email preferences.
                            Unschedule this program. It was replaced by the Workflow Directory Services User/Role Validation program
                            which you are running.
                            
                            The follow the instructions in note 578574.1 EXTERNAL/PUBLISHED How To Set Email Style Preference For All Users At On 
                            
                            2, Your Workflow Background Processes are scheduled incorrectly.
                            
                            WF Development recommends that users run the he Workflow Background Engine with these basic settings:
                            =========================================================== 
                            
                            
                            A. Schedule one concurrent request to process deferred activities: Every 5 minutes from the COMPLETION of the prior run.
                            
                            1. Item Type : 
                            2. Min Threshold : 
                            3. Max Threshold :
                            4. Process Deferred : Yes
                            5. Process Timeout : No
                            6. Process Stuck : No
                            
                            B. Schedule one concurrent request to process timeout activities: Every 4 hours
                            
                            1. Item Type : 
                            2. Min Threshold : 
                            3. Max Threshold :
                            4. Process Deferred : No
                            5. Process Timeout : Yes
                            6. Process Stuck : No
                            
                            
                            C. Run for stuck activities periodically (monthly or weekly):
                            
                            
                            1. Item Type : 
                            2. Min Threshold : 
                            3. Max Threshold :
                            4. Process Deferred : No
                            5. Process Timeout : No
                            6. Process Stuck : Yes
                            
                            
                            
                            NEVER run the Workflow Background Process with Yes, Yes, Yes. This slows everything down.
                            
                            Now bounce the Workflow Services: 
                            Regards,
                            dkoracle
                            • 26. Re: Workflow error
                              Hussein Sawwan-Oracle
                              Have you tried the suggested solution in the TEST instance? If yes, did it help to resolve the issue?

                              Thanks,
                              Hussein
                              • 27. Re: Workflow error
                                dkoracle
                                Yes hussein,

                                I tried the steps on TEST and it given results.



                                Regards,
                                dkoracle
                                • 28. Re: Workflow error
                                  Hussein Sawwan-Oracle
                                  dkoracle wrote:
                                  Yes hussein,

                                  I tried the steps on TEST and it given results.



                                  Regards,
                                  dkoracle
                                  Thanks for the update.

                                  Regards,
                                  Hussein
                                  1 2 Previous Next