8 Replies Latest reply on May 25, 2017 3:10 PM by JimT

    Workflow issue

    979524

      Hi,

       

      We have configured workflow in R12.2.3 instance with IMAP and it was working fine.

       

      Last 4 days workflow was not running and I can see mails in IMAP account's inbox. Started workflow  and is running. But still the mails are in inbox and not moving to process/discard folder.

       

      How to fix?

        • 1. Re: Workflow issue
          Shaik

          Hi

           

          Are you using exchange or any mail server, if yes check the imap services status

           

          test the imap status from your server

          How to Test IMAP, POP, SMTP (Doc ID 317307.1)

           

           

          Regards

          Shaik

          • 2. Re: Workflow issue
            979524

            POP/IMAP service status are fine from system

            • 3. Re: Workflow issue
              mdtaylor

              Please open the Workflow Mailer log in either Administer Managers or Oracle Applications Manager->Workflow and post the errors present.

              • 4. Re: Workflow issue
                979524

                log:

                ----

                 

                [May 24, 2017 2:59:45 PM AST]:1495627185136:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.security.AppsConnectionManager]:borrowConnection(Hashtable): BEGIN

                [May 24, 2017 2:59:45 PM AST]:1495627185136:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.security.AppsConnectionManager]:borrowConnection(Hashtable): END

                [May 24, 2017 2:59:45 PM AST]:1495627185136:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.borrowConnection: END

                [May 24, 2017 2:59:45 PM AST]:1495627185136:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal: Class null with session_id 0x4a2edb3 borrowed a Connection from the pool.

                [May 24, 2017 2:59:45 PM AST]:1495627185136:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal: END

                [May 24, 2017 2:59:45 PM AST]:1495627185136:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getJDBCConnection: END: returning oracle.jdbc.driver.T4CConnection@c0fc23d

                [May 24, 2017 2:59:45 PM AST]:1495627185136:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(): BEGIN/END

                [May 24, 2017 2:59:45 PM AST]:1495627185137:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@c0fc23d): : BEGIN/END

                [May 24, 2017 2:59:45 PM AST]:1495627185137:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@c0fc23d,0x4a2edb3): : BEGIN/END

                [May 24, 2017 2:59:45 PM AST]:1495627185137:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@c0fc23d,0x4a2edb3): :  (pConn == mConn) is  true, isSplCtx is false, switchGenSol is false

                [May 24, 2017 3:01:32 PM AST]:1495627292978:-1:-1:app01:172.28.10.12:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:172.28.10.12:65057:1495625139802:94:UNEXPECTED:[SVC-GSM-WFMLRSVC-9185-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Unable to connect to mail store at attemt #3

                [May 24, 2017 3:01:32 PM AST]:1495627292979:-1:-1:app01:172.28.10.12:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:172.28.10.12:65057:1495625139802:94:UNEXPECTED:[SVC-GSM-WFMLRSVC-9185-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Opening a new connection

                [May 24, 2017 3:02:15 PM AST]:1495627335986:-1:-1:app01:172.28.10.12:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:172.28.10.12:65057:1495625139802:94:UNEXPECTED:[SVC-GSM-WFMLRSVC-9185-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.openNewConnection]:Connected to store with attemt #1

                [May 24, 2017 3:04:17 PM AST]:1495627457029:-1:-1:app01:172.28.10.12:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:172.28.10.12:65057:1495625139802:94:UNEXPECTED:[SVC-GSM-WFMLRSVC-9185-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Unable to connect to mail store at attemt #4

                [May 24, 2017 3:04:17 PM AST]:1495627457029:-1:-1:app01:172.28.10.12:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:172.28.10.12:65057:1495625139802:94:UNEXPECTED:[SVC-GSM-WFMLRSVC-9185-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Opening a new connection

                [May 24, 2017 3:04:39 PM AST]:1495627479034:-1:-1:app01:172.28.10.12:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:172.28.10.12:65057:1495625139802:94:UNEXPECTED:[SVC-GSM-WFMLRSVC-9185-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.openNewConnection]:Connected to store with attemt #1

                [May 24, 2017 3:04:41 PM AST]:1495627481673:-1:-1:app01:172.28.10.12:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:172.28.10.12:65057:1495625139802:94:UNEXPECTED:[SVC-GSM-WFMLRSVC-9185-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.processSingleMessage(Message)]:Problem reaching content in step {Writing to NID parser} -> javax.mail.internet.AddressException: Local address contains control or whitespace in string ``System Administrator''

                [May 24, 2017 3:04:42 PM AST]:1495627482674:-1:-1:app01:172.28.10.12:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:172.28.10.12:65057:1495625139802:94:ERROR:[SVC-GSM-WFMLRSVC-9185-10006 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.close()]:Connection to Store is closed

                [May 24, 2017 3:04:45 PM AST]:1495627485138:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(): BEGIN/END

                [May 24, 2017 3:04:45 PM AST]:1495627485138:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(null,0x4a2edb3,false,false,false): : BEGIN

                [May 24, 2017 3:04:45 PM AST]:1495627485138:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal(null,0x4a2edb3,true,false,false): : BEGIN

                [May 24, 2017 3:04:45 PM AST]:1495627485138:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.borrowConnection(null,0x4a2edb3,false): : BEGIN

                [May 24, 2017 3:04:45 PM AST]:1495627485138:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.security.AppsConnectionManager]:borrowConnection(Hashtable): BEGIN

                [May 24, 2017 3:04:45 PM AST]:1495627485138:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.security.AppsConnectionManager]:borrowConnection(Hashtable): END

                [May 24, 2017 3:04:45 PM AST]:1495627485139:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.borrowConnection: END

                [May 24, 2017 3:04:45 PM AST]:1495627485139:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal: Class null with session_id 0x4a2edb3 borrowed a Connection from the pool.

                [May 24, 2017 3:04:45 PM AST]:1495627485139:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal: END

                [May 24, 2017 3:04:45 PM AST]:1495627485139:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getJDBCConnection: END: returning oracle.jdbc.driver.T4CConnection@c0fc23d

                [May 24, 2017 3:04:45 PM AST]:1495627485139:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(): BEGIN/END

                [May 24, 2017 3:04:45 PM AST]:1495627485139:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@c0fc23d): : BEGIN/END

                [May 24, 2017 3:04:45 PM AST]:1495627485139:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@c0fc23d,0x4a2edb3): : BEGIN/END

                [May 24, 2017 3:04:45 PM AST]:1495627485139:-1:-1:app01:172.28.10.12:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:172.28.10.12:65057:1495452583233:14:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@c0fc23d,0x4a2edb3): :  (pConn == mConn) is  true, isSplCtx is false, switchGenSol is false

                • 5. Re: Workflow issue
                  mdtaylor

                  Are you using IMAP SSL?  Workflow is unable to connect to the mail account.

                   

                  oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Unable to connect to mail store at attemt #4

                  • 6. Re: Workflow issue
                    979524

                    No.

                    Normally if any issue with IMAP authentication, we will not able to start. Now worlflow is runnning.

                    • 7. Re: Workflow issue
                      mdtaylor

                      It appears you have an email defined as System Administrator:

                       

                      javax.mail.internet.AddressException: Local address contains control or whitespace in string ``System Administrator''

                       

                      Workflow Mailer Deactivated Due to Illegal Whitespace in Address in String During Inbound IMAP Processing (Doc ID 1904529.1)

                      • 8. Re: Workflow issue
                        JimT

                        Look at the emails in the box. Some of the out of office or auto reply emails will cause "Unable to connect mail store" errors.