5 Replies Latest reply on Apr 13, 2017 7:56 PM by Aldrich

    Oracle workflow not sending emails.

    Girish Sunkara

      Notification mailers, service components and background engines, all are up and running. I bounced all the services with any errors. But users are still complaining that they are not receiving mails. Below is the log file.

       

       

      apps.fnd.cp.gsc.SvcComponentMonitor.process()]:On-Demand monitoring will not occur this round; the count is 3 out of 5

      [Apr 11, 2017 11:46:43 AM MYT]:1491882403974:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.run()]:Resetting Error Count

      [Apr 11, 2017 11:46:43 AM MYT]:1491882403975:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

      [Apr 11, 2017 11:46:43 AM MYT]:1491882403975:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 60 seconds (60000 ms)

      [Apr 11, 2017 11:46:44 AM MYT]:1491882404194:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

      [Apr 11, 2017 11:46:44 AM MYT]:1491882404195:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)

      [Apr 11, 2017 11:46:52 AM MYT]:1491882412569:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.

      [Apr 11, 2017 11:46:52 AM MYT]:1491882412569:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)

      [Apr 11, 2017 11:46:52 AM MYT]:1491882412569:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.

      [Apr 11, 2017 11:46:52 AM MYT]:1491882412569:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.process()]:BEGIN

      [Apr 11, 2017 11:46:52 AM MYT]:1491882412569:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read]:BEGIN

      [Apr 11, 2017 11:46:52 AM MYT]:1491882412569:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.cp.gsc.SvcComponentProcessor.read()]:BEGIN [default implementation]

      [Apr 11, 2017 11:46:52 AM MYT]:1491882412569:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[fnd.wf.bes.QueueHandlerInvoker]:dequeue() BEGIN

      [Apr 11, 2017 11:46:52 AM MYT]:1491882412569:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :BEGIN

      [Apr 11, 2017 11:46:54 AM MYT]:1491882414197:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.

      [Apr 11, 2017 11:46:54 AM MYT]:1491882414197:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)

      [Apr 11, 2017 11:46:54 AM MYT]:1491882414197:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.

      [Apr 11, 2017 11:46:54 AM MYT]:1491882414197:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.process()]:BEGIN

      [Apr 11, 2017 11:46:54 AM MYT]:1491882414197:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.read()]:BEGIN

      [Apr 11, 2017 11:52:55 AM MYT]:1491882775068:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:INBOX connection has been closed

      [Apr 11, 2017 11:52:56 AM MYT]:1491882776074:Thread[JavaMail-EventQueue,5,inboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:Store connection has been closed

      [Apr 11, 2017 11:52:57 AM MYT]:1491882777075:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

      [Apr 11, 2017 11:52:57 AM MYT]:1491882777075:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881-10006 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 55 seconds (55000 ms)

      [Apr 11, 2017 11:53:04 AM MYT]:1491882784374:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

      [Apr 11, 2017 11:53:04 AM MYT]:1491882784375:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-921881 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)

       

       

      Please help resolve the issue.

       

      Regards,

      Girish

        • 1. Re: Oracle workflow not sending emails.
          mdtaylor

          Edit your workflow mailer and change the logging level to Exception so we can catch the error.  You will need to start Workflow Mailer after making this change.

          • 2. Re: Oracle workflow not sending emails.
            Girish Sunkara

            Changed the logging level to exception and bounced workflow services. Below is the log after sending a test mail. User again reported she did not receive mail.

             

            [Apr 11, 2017 3:45:40 PM MYT]:1491896740008:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

            [Apr 11, 2017 3:45:40 PM MYT]:1491896740009:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)

            [Apr 11, 2017 3:45:50 PM MYT]:1491896750012:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.

            [Apr 11, 2017 3:45:50 PM MYT]:1491896750013:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)

            [Apr 11, 2017 3:45:50 PM MYT]:1491896750013:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.

            [Apr 11, 2017 3:45:50 PM MYT]:1491896750013:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.process()]:BEGIN

            [Apr 11, 2017 3:45:50 PM MYT]:1491896750013:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.read()]:BEGIN

            [Apr 11, 2017 3:46:00 PM MYT]:1491896760020:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

            [Apr 11, 2017 3:46:00 PM MYT]:1491896760020:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769910:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769910:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769910:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769910:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.SvcComponentMonitor.process()]:BEGIN

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769911:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.SvcComponentMonitor.startAutomaticComponents()]:BEGIN

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769913:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.SvcComponentMonitor.startOnDemandComponents()]:BEGIN

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769914:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.SvcComponentMonitor.stopOnDemandComponents()]:BEGIN

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769914:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.run()]:Resetting Error Count

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769915:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

            [Apr 11, 2017 3:46:09 PM MYT]:1491896769915:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 60 seconds (60000 ms)

             

             

            [Apr 11, 2017 3:46:30 PM MYT]:1491896790032:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.process()]:BEGIN

            [Apr 11, 2017 3:46:30 PM MYT]:1491896790032:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.read()]:BEGIN

            [Apr 11, 2017 3:46:40 PM MYT]:1491896800040:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

            [Apr 11, 2017 3:46:40 PM MYT]:1491896800041:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)

            [Apr 11, 2017 3:46:50 PM MYT]:1491896810044:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.

            [Apr 11, 2017 3:46:50 PM MYT]:1491896810045:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)

            [Apr 11, 2017 3:46:50 PM MYT]:1491896810045:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.

            [Apr 11, 2017 3:46:50 PM MYT]:1491896810045:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.process()]:BEGIN

            [Apr 11, 2017 3:46:50 PM MYT]:1491896810045:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.read()]:BEGIN

            [Apr 11, 2017 3:47:00 PM MYT]:1491896820051:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

            [Apr 11, 2017 3:47:00 PM MYT]:1491896820051:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)

            [Apr 11, 2017 3:47:04 PM MYT]:1491896824440:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:EXCEPTION:[SVC-GSM-WFMLRSVC-922634-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:Successfully processed Message[0] for NOTIFICATION_ID=1026953 to [["LY CHAN, Ms." <lychan@bcmcorp.com.my>]]

            [Apr 11, 2017 3:47:04 PM MYT]:1491896824441:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:EXCEPTION:[SVC-GSM-WFMLRSVC-922634-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:Updating notification {1026953} status {SENT} {} {}

            [Apr 11, 2017 3:47:09 PM MYT]:1491896829917:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.

            [Apr 11, 2017 3:47:09 PM MYT]:1491896829918:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)

            [Apr 11, 2017 3:47:09 PM MYT]:1491896829918:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.

            [Apr 11, 2017 3:47:09 PM MYT]:1491896829918:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.SvcComponentMonitor.process()]:BEGIN

            [Apr 11, 2017 3:47:09 PM MYT]:1491896829918:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.SvcComponentMonitor.startAutomaticComponents()]:BEGIN

            [Apr 11, 2017 3:47:09 PM MYT]:1491896829920:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.SvcComponentMonitor.process()]:On-Demand monitoring will not occur this round; the count is 1 out of 5

            [Apr 11, 2017 3:47:09 PM MYT]:1491896829920:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.run()]:Resetting Error Count

            [Apr 11, 2017 3:47:09 PM MYT]:1491896829920:Thread[ComponentMonitor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

             

             

            [Apr 11, 2017 3:47:10 PM MYT]:1491896830054:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.

            [Apr 11, 2017 3:47:10 PM MYT]:1491896830054:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)

            [Apr 11, 2017 3:47:10 PM MYT]:1491896830054:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.

            [Apr 11, 2017 3:47:10 PM MYT]:1491896830054:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.process()]:BEGIN

            [Apr 11, 2017 3:47:10 PM MYT]:1491896830054:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.read()]:BEGIN

            [Apr 11, 2017 3:47:20 PM MYT]:1491896840061:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

            [Apr 11, 2017 3:47:20 PM MYT]:1491896840061:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)

            [Apr 11, 2017 3:47:30 PM MYT]:1491896850063:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.

            [Apr 11, 2017 3:47:30 PM MYT]:1491896850063:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN (noEvent)

            [Apr 11, 2017 3:47:30 PM MYT]:1491896850063:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not receive any control events.

            [Apr 11, 2017 3:47:30 PM MYT]:1491896850063:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.process()]:BEGIN

            [Apr 11, 2017 3:47:30 PM MYT]:1491896850064:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsm.GSMQueueProcessor.read()]:BEGIN

            [Apr 11, 2017 3:47:30 PM MYT]:1491896850581:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:EXCEPTION:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Defer the Read of CLOB reference of Event Data

            [Apr 11, 2017 3:47:30 PM MYT]:1491896850582:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:EXCEPTION:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Dequeued the following BusinessEvent -> BusinessEvent{name=oracle.apps.wf.notification.send, key=1026954, priority=50, correlationId=null, sendDate=Tue Apr 11 14:31:29 MYT 2017, receiveDate=Tue Apr 11 14:32:56 MYT 2017, From Agent:Agent{agent=WF_NOTIFICATION_OUT, system=PROD.BCMLAN.COM}, To Agent:  , Last Subscription=C0F79E8FE398266EE0301490C8C41A0C, Error Message=null, Error Stack=null, OBJECT_NAME=oracle.apps.fnd.wf.worklist.server.AllNotificationsVO, GROUP_ID=1026954, ROLE=P6676, CHANGE_TYPE=INSERT, #CURRENT_PHASE=100, ID_TYPE=PK, PK_NAME_1=NOTIFICATION_ID, PK_NAME_2=LANGUAGE, #MSG_DQ_ATTEMPTS=0, NOTIFICATION_ID=1026954, PK_VALUE_1=1026954, #MSG_ID=4CDF43232DB0B0F5E0531301A8C0F2C7, BES_PAYLOAD_OBJECT=false, Q_CORRELATION_ID=WFTESTS:OAFWK_MSG, PK_VALUE_2=US}

            [Apr 11, 2017 3:47:32 PM MYT]:1491896852903:Thread[outboundThreadGroup1,5,outboundThreadGroup]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:EXCEPTION:[SVC-GSM-WFMLRSVC-922634-10006 : oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Intending to send email to -> [["CHONG KOOI HAR, Ms." <xxxxxxxxxxxxxxxxxxxxx>]]. Sending to -> [["CHONG KOOI HAR, Ms." <xxxxxxxxxxxxxxxxxxxxx>]]

            [Apr 11, 2017 3:47:40 PM MYT]:1491896860070:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN

            [Apr 11, 2017 3:47:40 PM MYT]:1491896860070:Thread[GSMQueueProcessor,5,main]:0:-1:oracleprod1.bcmlan.com:192.168.1.16:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-922634 : oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)

            • 3. Re: Oracle workflow not sending emails.
              mdtaylor

              Please review the following Workflow Notification troubleshooting documents:

               

              Workflow Java Mailer & Notifications FAQ (Doc ID 562551.1)

              Steps for Configuring Workflow Java Mailer to connect using SSL to IMAP Server (Doc ID 1265949.1)

              11i-12 Troubleshooting Workflow Java Notification Mailer - Technical Reference (Doc ID 1191125.1)

              Example Of Configuring Workflow Java Notification Mailer With Oracle Applications (Doc ID 249957.1)

               

              Also ask your DBA to ssh to the concurrent manager tier and mailx a test email to your email to verify SMTP outbound is working.

               

              Regards,

              Michael

              • 4. Re: Oracle workflow not sending emails.
                Girish Sunkara

                Hello michael,

                 

                Ok. Thanks for the docs.

                • 5. Re: Oracle workflow not sending emails.
                  Aldrich

                  Did you check /var/log/messages on the Concurrent Manager server?  Might be telling if its failing to send emails...