Re: Workflow notification mailer - Not getting replies

  • From: "Pravin RC" <pravinrc@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Fri, 18 Jan 2008 10:21:27 +1000

Hi,

Did you try test mail?  Check wf_notification table for further
investigation.

thanks

On Jan 16, 2008 7:03 PM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote:

> Hi all,
>
> I have Workflow Notification mailer issue.
> After submitting a request, I am not getting the reply from Workflow
> notification mailer. I bounced the services and didnt work out. I could see
> that the services are up and running
>
> Select Name Status State Node Actual Processes Target Processes
> 1 Workflow Agent Listener Service  Activated
> 2 Workflow Document Web Services Service  Activated
> 3 Workflow Mailer Service  Activated
>
> Below is the WF mailer log. Please advice me as I am not much aware of the
> same.
>
> Thanks in advance.
>
>
> [Jan 11, 2008 12:45:41 AM
> PST]:1200473141706:Thread[GSMQueueProcessor,5,main]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT: [SVC-GSM-WFMLRSVC-679337 :
> oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 10 seconds (10000 ms)
> [Jan 11, 2008 12:45:42 AM
> PST]:1200473142312:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT: [SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Connecting to
> store.
> [Jan 11, 2008 12:45:42 AM
> PST]:1200473142335:Thread[Thread-2225,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT: [SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.opened(ConnectionEvent)]:Store
> connection has been opened
> [Jan 11, 2008 12:45:43 AM
> PST]:1200473143617:Thread[Thread-2227,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.opened(ConnectionEvent)]:INBOX
> connection has been opened
> [Jan 11, 2008 12:45:44 AM
> PST]:1200473144332:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.read()]:Reading message
> [Jan 11, 2008 12:45:44 AM
> PST]:1200473144333:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Reading
> new messages
> [Jan 11, 2008 12:45:44 AM
> PST]:1200473144436:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.readNewMessages()]:Message
> list is empty
> [Jan 11, 2008 12:45:44 AM
> PST]:1200473144436:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.cp.gsc.SvcComponentProcessor.performClose()]:BEGIN
> [Jan 11, 2008 12:45:44 AM
> PST]:1200473144437:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.close()]:Closing connection
> [Jan 11, 2008 12:45:45 AM
> PST]:1200473145446:Thread[Thread-2227,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:INBOX
> connection has been closed
> [Jan 11, 2008 12:45:46 AM
> PST]:1200473146457:Thread[Thread-2225,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.wf.mailer.IMAPInboundProcessor$ConnectionMonitor.closed(ConnectionEvent)]:Store
> connection has been closed
> [Jan 11, 2008 12:45:47 AM
> PST]:1200473147462:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.cp.gsc.Processor.sleep()]:BEGIN
> [Jan 11, 2008 12:45:47 AM
> PST]:1200473147463:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337-10006 :
> oracle.apps.fnd.cp.gsc.Processor.sleep()]:Waiting 30 seconds (30000 ms)
> [Jan 11, 2008 12:45:51 AM
> PST]:1200473151712:Thread[GSMQueueProcessor,5,main]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT:[SVC-GSM-WFMLRSVC-679337 :
> oracle.apps.fnd.cp.gsc.Processor.run()]:Running loop from the top.
> [Jan 11, 2008 12:45:51 AM
> PST]:1200473151712:Thread[GSMQueueProcessor,5,main]:0:-1:appstprod:
> 172.10.11.210:-1:-1:PROCEDURE: [SVC-GSM-WFMLRSVC-679337 :
> oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:BEGIN
> (noEvent)
> [Jan 11, 2008 12:45:51 AM
> PST]:1200473151713:Thread[GSMQueueProcessor,5,main]:0:-1:appstprod:
> 172.10.11.210:-1:-1:STATEMENT: [SVC-GSM-WFMLRSVC-679337 :
> oracle.apps.fnd.cp.gsc.Processor.processControlEvent(String)]:Did not
> receive any control events.
> [Jan 11, 2008 12:45:51 AM
> PST]:1200473151713:Thread[GSMQueueProcessor,5,main]:0:-1:appstprod:
> 172.10.11.210:-1:-1:PROCEDURE:[SVC-GSM-WFMLRSVC-679337 :
> oracle.apps.fnd.cp.gsm.GSMQueueProcessor.process()]:BEGIN
> [Jan 11, 2008 12:45:51 AM
> PST]:1200473151713:Thread[GSMQueueProcessor,5,main]:0:-1:appstprod:
> 172.10.11.210:-1:-1:PROCEDURE: [SVC-GSM-WFMLRSVC-679337 :
> oracle.apps.fnd.cp.gsm.GSMQueueProcessor.read()]:BEGIN
>
>
>
> Regards,
> Anant
>



-- 
Affectionately Yours
Pravin R C

Other related posts: