This discussion is archived
1 2 Previous Next 28 Replies Latest reply: Oct 26, 2012 7:41 AM by Hussein Sawwan-Oracle Go to original post RSS
  • 15. Re: Workflow error
    dkoracle Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Yes hussein,

    I tried the steps on TEST and it given results.



    Regards,
    dkoracle
  • 28. Re: Workflow error
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points