Hi friends, I tried in bouncing again the WF services and it did work. Thanks alot for your support on this. Regards, Anant On 1/18/08, Pravin RC <pravinrc@xxxxxxxxx> wrote: > > 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