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