7 Replies Latest reply on Mar 28, 2012 8:03 PM by Hussein Sawwan-Oracle

    Workflow mailer not starting R12 on linux

    user409261
      Hi:

      I was trying to start workflow mailer after clone but won't start. Please guide me step by step to trouble shot. I don't see any errors in log file FNDCPxxx. BTW, the "View Log" is the log file?

      How to run diagnostics?

      Thanks and regards.
        • 1. Re: Workflow mailer not starting R12 on linux
          Hussein Sawwan-Oracle
          Please post the details of the application release, database version and OS.
          I was trying to start workflow mailer after clone but won't start. Please guide me step by step to trouble shot. I don't see any errors in log file FNDCPxxx. BTW, the "View Log" is the log file?
          Was this working before? If yes, any changes have been done recently?

          Can you find any errors in the database log file?

          Please rename the workflow log file, reproduce the issue and check the log then -- $APPLCSF/$APPLLOG/FNDCPGSC*.txt
          How to run diagnostics?
          Please see the docs referenced in old threads.

          https://forums.oracle.com/forums/search.jspa?threadID=&q=Workflow+AND+Troubleshoot&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
          https://forums.oracle.com/forums/search.jspa?threadID=&q=Workflow+AND+Diagnostics&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

          Thanks,
          Hussein
          • 2. Re: Workflow mailer not starting R12 on linux
            user409261
            EBS: 12.1.3
            OS: Linux
            DB: 11.1.0.7

            Don't see any errors in alert.log. After clone, didn't work. Don't know about any changes. Where I should start to troubleshot?
            • 3. Re: Workflow mailer not starting R12 on linux
              Hussein Sawwan-Oracle
              Don't see any errors in alert.log. After clone, didn't work. Don't know about any changes. Where I should start to troubleshot?
              Have you followed the action plan mentioned in my previous email?

              Did you go through the troubleshooting/diagnostics docs referenced in the link above?

              Thanks,
              Hussein
              • 4. Re: Workflow mailer not starting R12 on linux
                user409261
                I am working on the disgnostics.

                I was trying start again, and find errors:

                [Mar 28, 2012 2:11:27 PM CDT]:1332961887697:-1:-1:oracledbser3.linux.lac1:10.1.102.211:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:10.1.102.211:46204:1332961757272:55:EXCEPTION:[SVC-GSM-WFMLRSVC-371679 : oracle.apps.fnd.cp.gsc.SvcComponentStateMachine.updateComponentStatus(Logger, Connection, int, String, String)]:BEGIN (Logger{mLog=[$Header: AppsLog.java 120.4.12010000.2 2009/06/17 15:14:37 rsantis ship $ @29488562 {oracle.apps.fnd.profiles.ExtendedProfileStore@e99ce5}],mUniqueId=SVC-GSM-WFMLRSVC-371679,mLevel=4}, oracle.jdbc.driver.T4CConnection@1a99347, 10009, STOPPED_ERROR, Could not handle the control event -> java.lang.RuntimeException: Connection refused)
                • 5. Re: Workflow mailer not starting R12 on linux
                  Hussein Sawwan-Oracle
                  I was trying start again, and find errors:

                  [Mar 28, 2012 2:11:27 PM CDT]:1332961887697:-1:-1:oracledbser3.linux.lac1:10.1.102.211:-1:-1:1:20420:SYSADMIN(0):-1:Thread[BES Dispatch Thread,5,main]:10.1.102.211:46204:1332961757272:55:EXCEPTION:[SVC-GSM-WFMLRSVC-371679 : oracle.apps.fnd.cp.gsc.SvcComponentStateMachine.updateComponentStatus(Logger, Connection, int, String, String)]:BEGIN (Logger{mLog=[$Header: AppsLog.java 120.4.12010000.2 2009/06/17 15:14:37 rsantis ship $ @29488562 {oracle.apps.fnd.profiles.ExtendedProfileStore@e99ce5}],mUniqueId=SVC-GSM-WFMLRSVC-371679,mLevel=4}, oracle.jdbc.driver.T4CConnection@1a99347, 10009, STOPPED_ERROR, Could not handle the control event -> java.lang.RuntimeException: Connection refused)
                  Please see these docs.

                  Workflow Service Component is System Deactivated with Error Details : Could not handle the control event -> java.lang.OutOfMemoryError: unable to create new native thread [ID 842968.1]
                  Workflow Notification Mailer Remains in Starting Status [ID 1400353.1]
                  Java Mailer wont start OPEN_MAIL_FYI=The requested template does not exist [ID 331358.1]
                  Unable To Start Workflow Notification Mailer [ID 418329.1]

                  Thanks,
                  Hussein
                  • 6. Re: Workflow mailer not starting R12 on linux
                    Srini Chavali-Oracle
                    Pl see the steps in this MOS Doc

                    Workflow Notification Mailer Remains in Starting Status [ID 1400353.1]     

                    HTH
                    Srini
                    • 7. Re: Workflow mailer not starting R12 on linux
                      Hussein Sawwan-Oracle
                      Please also perform the tests in (How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java Mailer For Sending Email Notifications [ID 753845.1]).

                      Thanks,
                      Hussein