7 Replies Latest reply: Feb 28, 2012 2:46 AM by Hussein Sawwan-Oracle RSS

    email box approvals

    905108
      Dear all,

      12.1.1 on Solaris 10.

      PO or leave approval workflow , when approved from the email box of the user , doesn't hit the database. but workflow notification mailer is working fine...


      Any idea ?
        • 1. Re: email box approvals
          Hussein Sawwan-Oracle
          PO or leave approval workflow , when approved from the email box of the user , doesn't hit the database.
          What do you mean? Please elaborate more.
          but workflow notification mailer is working fine...
          Can you find any errors in the Workflow log file?

          Thanks,
          Hussein
          • 2. Re: email box approvals
            905108
            Thanks Hussain and sorry for not explaining it clear. For example .


            Employee A applies for leave
            whch is forwarded to manager A
            Manager receieves this mail.
            When manager approves this leave from the email

            manager receieves the below email
            Action: 'Approve'
            
            Comments From Last Approver
            
            Note: ''
            
             
            
            NID[3988124/220625014145019714966522059974290704835@WFMAIL]
            When he approves the email, it doesn't hit the ebs application .. and I checked workflow log files in FND* in APPLLOG and there is no error.. Please advise if any other thing need to be checked
            • 3. Re: email box approvals
              905108
              Am getting the below errors, in the FND* log files in APPLOG
              bash-3.00$ tail -f FNDCPGSC472811.txt
              [Jan 20, 2012 11:45:09 PM AST]:1327092309154:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              [GC 27131K->20151K(28312K), 0.0122862 secs]
              [Jan 20, 2012 11:46:09 PM AST]:1327092369254:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              [Jan 20, 2012 11:47:09 PM AST]:1327092429352:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              [GC 28022K->20413K(28896K), 0.0082409 secs]
              [Full GC[Unloading class sun.reflect.GeneratedConstructorAccessor34]
              [Unloading class sun.reflect.GeneratedConstructorAccessor28]
              [Unloading class sun.reflect.GeneratedConstructorAccessor33]
               20413K->8914K(28896K), 0.4661341 secs]
              [Jan 20, 2012 11:48:09 PM AST]:1327092489932:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              
              
              GC 27131K->20151K(28312K), 0.0122862 secs]
              [Jan 20, 2012 11:46:09 PM AST]:1327092369254:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              [Jan 20, 2012 11:47:09 PM AST]:1327092429352:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              [GC 28022K->20413K(28896K), 0.0082409 secs]
              [Full GC[Unloading class sun.reflect.GeneratedConstructorAccessor34]
              [Unloading class sun.reflect.GeneratedConstructorAccessor28]
              [Unloading class sun.reflect.GeneratedConstructorAccessor33]
               20413K->8914K(28896K), 0.4661341 secs]
              [Jan 20, 2012 11:48:09 PM AST]:1327092489932:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              [Jan 20, 2012 11:49:10 PM AST]:1327092550032:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              [Jan 20, 2012 11:50:10 PM AST]:1327092610137:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLException: Closed Statement
              [Jan 20, 2012 11:50:10 PM AST]:1327092610156:-1:-1:ERAPPS:178.1.2.159:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:178.1.2.159:67442:1327092068660:52:ERROR:[SVC-GSM-WFMLRSVC-472811-10006 : oracle.apps.fnd.cp.gsc.Processor.performError(ProcessorException)]:Maximum number of errors have occurred for this processing thread.
              [GC 16588K->10166K(28312K), 0.0121189 secs]
              • 4. Re: email box approvals
                abbasha
                Dear,

                Any update on this issue. We are also facing the same problem in our R12.1.1 Production instance on OEL 5.5 platform.
                Due to this repeated error message Workflow Notification Mailer get crashes very frequently. We have set maximum error count as 300.

                Thanks,
                ...basha
                • 5. Re: email box approvals
                  Hussein Sawwan-Oracle
                  Any update on this issue. We are also facing the same problem in our R12.1.1 Production instance on OEL 5.5 platform.
                  Due to this repeated error message Workflow Notification Mailer get crashes very frequently. We have set maximum error count as 300.
                  What is the error in the Workflow log file? -- Getting and Reading Workflow Notification Mailer Log File [ID 1365320.1]

                  Thanks,
                  Hussein
                  • 6. Re: email box approvals
                    abbasha
                    Dear Hussein,

                    Error message in workflow log file is, after it reaches count 300 mailer crashes.

                    [Feb 28, 2012 10:56:36 AM AST]:1330415796497:-1:-1:erpinternal02.alrajhisteel.com:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:127.0.0.1:65700:1330409733296:39:ERROR:[SVC-GSM-WFMLRSVC-125288-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLRecoverableException: Closed Statement

                    Thanks,
                    ...basha
                    • 7. Re: email box approvals
                      Hussein Sawwan-Oracle
                      Error message in workflow log file is, after it reaches count 300 mailer crashes.

                      [Feb 28, 2012 10:56:36 AM AST]:1330415796497:-1:-1:erpinternal02.alrajhisteel.com:127.0.0.1:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:127.0.0.1:65700:1330409733296:39:ERROR:[SVC-GSM-WFMLRSVC-125288-10006 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleInvalidMoreInfoResponse(EmailParser)]:Problem preparing response to an Invalid Response message -> java.sql.SQLRecoverableException: Closed Statement
                      Please see (Workflow Mailer Is Not Able to Handle Unsolicited Emails Due to Error: java.io.IOException: Error in encoded stream OR java.sql.SQLException: Closed Statement [ID 974088.1]).

                      Thanks,
                      Hussein