==============================================================================
Applies To:
SOA Product Type: BPM
- version 11.1.1.6.7
Oracle Database: Enterprise Edition - Version 11.2.0.3
==============================================================================
Problem: When you
call BPM composite sometimes you will hit with enqueue/dequeue errors as below,
Non Recoverable System Fault :
ORAMED-03303:[Unexpected exception in case execution]Unexpected
exception in request response operation "operation" on reference
"RetrieveFraudCaseStatusWorkflow.RetrieveFraudCaseStatusWorkflow.service".
Possible Fix:Check whether the reference service is properly configured and running
or look at exception for analyzing the reason or contact Oracle Support
Services. Cause:Error enqueing event: ORA-25207: enqueue failed, queue
DEV_SOAINFRA.EDN_EVENT_QUEUE is disabled from enqueueing ORA-06512: at
"SYS.DBMS_AQ", line 169 ORA-06512: at "DEV_SOAINFRA.EDN_ENQUEUE_BUSINESS_EVENT",
line 52 ORA-06512: at
"DEV_SOAINFRA.EDN_INTERNAL_PUBLISH_EVENT", line 4
Non Recoverable System Fault :
Error enqueing event: ORA-25207: enqueue failed, queue
DEV_SOAINFRA.EDN_EVENT_QUEUE is disabled from enqueueing ORA-06512: at
"SYS.DBMS_AQ", line 169 ORA-06512: at
"DEV_SOAINFRA.EDN_ENQUEUE_BUSINESS_EVENT", line 52 ORA-06512:
at "DEV_SOAINFRA.EDN_INTERNAL_PUBLISH_EVENT", line 4
============================================================================
Cause:
EDN_EVENT_QUEUE
enqueue/dequeue is disabled.
============================================================================
Solution:
If you face above error perform the below steps to fix it.
This can be performed by SOA Admin /DBA
1. Login to the DB with SOAINFRA user (e.g.
DEV_SOAINFRA) or use the SYS account and go to DEV_SOAINFRA schema.
2. Run the below pl/sql statement to enable enqueue
and dequeue operation,
begin
dbms_aqadm.start_queue (queue_name => 'EDN_EVENT_QUEUE', enqueue => TRUE
, dequeue => TRUE); end;
3. Check the queue table DEV_SOAINFRA.EDN_EVENT_QUEUE_TABLE.
Once enqueue/dequeue is enabled, you will find updates on table
EDN_EVENT_QUEUE_TABLE.
