Workflow Service Containers Will Not Start: oracle.jms.AQjmsException: JMS-120: Dequeue failed

APPLIES TO:

Oracle Workflow Cartridge - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 20-APR-2013

SYMPTOMS

The Workflow Service Container logs shows error:

oracle.jms.AQjmsException: JMS-120: Dequeue failed
at oracle.jms.AQjmsError.throwEx(AQjmsError.java:233)
at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:1424)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:692)
at oracle.jms.AQjmsConsumer.receive(AQjmsConsumer.java:629)
at oracle.apps.fnd.wf.bes.ControlListener.run(ControlListener.java:74)

Monitoring failed this iteration -> oracle.apps.fnd.cp.gsc.ProcessorException: Could not start automatic component -> oracle.apps.fnd.cp.gsc.server.GenericSvcComponentEOException: ORA-20002: 3825: Error '-24033 - ORA-24033: no recipients for message' encountered during execution of Rule function 'WF_RULE.ERROR_RULE' for event 'oracle.apps.fnd.cp.gsc.SvcComponent.start' with key 'SVC:15/JAN/2010'. FUNCTION_NAME=WF_EVENT_OJMSTEXT_QH.enqueue()

CHANGES

Payroll patch 9204430 was applied which revoked DBA role from the APPS user by running script:
$AD_TOP/patch/115/sql/adrevdba.sql.

CAUSE

The APPS user do not have the privilege to execute the SYS.DBMS_AQIN package.

The following error is thrown when run describe from the apps schema sys.dbms_aqin.

sqlplus apps/apps_pw

desc sys.dbms_aqin

ERROR:
ORA-04043: object sys.dbms_aqin does not exist

SOLUTION

1. Grant AQ_ADMINISTRATOR_ROLE to APPS which includes execute privilege on DBMS_AQIN.

sqlplus / @$AD_TOP/patch/115/sql/adgrnaq.sql

Example

sqlplus apps/apps @$AD_TOP/patch/115/sql/adgrnaq.sql manager apps apps

2. Confirm AQ_ADMINISTRATOR_ROLE is granted to APPS as BOTH ADMIN and DEFAULT.

This is the result for R12.1.  Some roles are not in 11.5.x. The APPS user need to always have the DEFAULT profile.  Do not revoke DEFAULT from the APPS User.

select * from DBA_ROLE_PRIVS where grantee='APPS';

GRANTEE	GRANTED_ROLE	ADM	DEF
APPS	RESOURCE	NO	YES
APPS	CONNECT	NO	YES
APPS	HR_REPORTING_USE	YES	YES
APPS	CTXAPP	NO	YES
APPS	OWS_STANDARD_ROLE	NO	YES
APPS	WEBDB_DEVELOPER	NO	YES
APPS	APPS_CONNECT	NO	YES
APPS	JAVASYSPRIV	NO	YES
APPS	HR_SECURE_USER	YES	YES
APPS	AQ_ADMINISTRATOR_ROLE	YES	YES

3. Give the Default profile to the APPS user if it has been revoked.

alter user APPS default role ALL;

4. Shutdown and restart the Concurrent Manager.

11.5.x

cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME

12.x

cd $ADMIN_SCRIPTS_HOME

sh adcmctl.sh stop apps/apps_pw

sh adcmctl.sh start apps/apps_pw