12 Replies Latest reply on Jul 21, 2010 7:20 AM by Hussein Sawwan-Oracle

    Workflow Mailer not starting

    495265
      Dear Friends

      My workflow component stopped with error and is not starting.I am getting the error below.I have already tried to purge the workflow but still it will not start.Error below is obtained.


      Workflow Mailer Service Process Log: 3449184: PROD



      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.initializeStateMachine() : BEGIN
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.getNewWorkflowContext() : BEGIN
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.getNewWorkflowContext() : BEGIN
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.loadGlobalParameters() : BEGIN
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.loadContainerParameters() : BEGIN
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.start() : Successfully retrieved global and container parameters
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.validateParameterValues(Properties) : BEGIN
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.validateParameterValues(Properties) : ({SVC_COMP_MAX_ERROR_COUNT=10, SVC_COMP_MONITOR_LOOP_SLEEP=60, SVC_CONTAINER_LOOP_SLEEP=10, SVC_CONTAINER_READ_TIMEOUT=10, SVC_COMP_MONITOR_ONDEMAND_FREQ=300, SVC_CONTAINER_LOG_LEVEL=4, SVC_WRITE_DIAG_TO_GSM_LOG=Y})
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.start() : Successfully validated container parameters
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.loadDetails(Connection) : BEGIN (oracle.jdbc.driver.OracleConnection@565d6134)
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.start() : Successfully retrieved container details
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.startLogger() : BEGIN
      LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.startLogger() : BEGIN [default implementation]
      Failed to establish Java Business Event System control connection: databaseId = prod, ownerName = APPLSYS, queueName = WF_CONTROL, subscriberName = WFBESCL_12606, selector = null, exception = oracle.apps.fnd.wf.bes.BusinessEventException: A JMS error occurred; see the linked exception for details., linkedException = oracle.jms.AQjmsException: ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.WF_CONTROL
      ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4412
      ORA-06512: at line 1
      ORA-06512: at "SYS.DBMS_AQJMS_INTERNAL", line 110
      ORA-06512: at line 1
      ORA-06512: at "SYS.DBMS_AQJMS", line 101
      ORA-06512: at line 1

      Regards
      Kamlesh