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 MAY 12, 2022
Applies to:
Oracle Workflow - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]Information in this document applies to any platform.
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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |