Sunday, April 24, 2016

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

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

Error:
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()

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 <apps_user>/<apps_pw> @$AD_TOP/patch/115/sql/adgrnaq.sql <system_pw> <apps_user> <apps_pw>
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

Reference metalink Doc ID 1050892.1

No comments:

Post a Comment