A JMS error occurred 'ORA-24067: maximum number of subscribers for APPLSYS.WF_CONTROL' and 'BES system could not establish connection to the control queue' When Attempting to Start Workflow Services. (Doc ID 758091.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Workflow Cartridge - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 13-FEB-2013


Symptoms

On 11.5.10:
When attempting to Start the Workflow Mailer service the following error occurs:

The Service Component Container is not running

Log file:

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_13784, 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

Could not start Service Component Container ->
oracle.apps.fnd.cp.gsc.SvcComponentContainerException: BES system could not establish connection
to the control queue after 180 seconds




STEPS
The issue can be reproduced at will with the following steps:
1. Login to OAM .
2. Navigate to Workflow Manager--> Notification Mailer.
3. Try to start the Mailer services and notice that even the service containers are down.

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot make use of Mailer service.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms