The queue object and queue existed and could be queried in the database directly. Messages could be enqueue/dequeued using anonymous blocks with no problem. However, the AqAdapter would not dequeue messages as expected.
ERROR
Please correct the reported issue and redeploy the BPEL process.: Endpoint Activation Error.
AdapterFrameworkImpl::endpointActivation - Endpoint Activation Error.
The Resource Adapter AQ Adapter was unable to activate the endpoint oracle.tip.adapter.aq.inbound.AQDequeueActivationSpec:{QueueName=myqueue, DatabaseSchema=myuser, SchemaValidation=false} due to the following reason: BINDING.JCA-11976
AQ_INVALID_QUEUE_TYPE.
Unable to obtain the correct queue type.
Queue does not exist or not defined correctly.
Drop and re-create queue.
Please correct the reported issue and redeploy the BPEL process. […]
ANALYSIS
Similar to the DbAdapter distributed polling, the AqAdapter queries the query queue table using SELECT FOR UPDATE SKIP LOCKED.You can view the actual SQL query by finding the sql_id of the DML that was passed to the database.
select sql_id,prev_sql_id,a.*
from gv$session a
where machine = ‘hostname';
select *
from gv$sql
where sql_id = sql_id;
FIX
In addition to granting execute to the object used in the queue and using DBMS_AQADM to grant privileges to the queue itself,grant execute on queue_object to role;
DBMS_AQADM.GRANT_QUEUE_PRIVILEGE (
privilege => 'DEQUEUE',
queue_name => 'myqueue',
grantee => 'myuser',
grant_option => FALSE);
the jdbc user that the AqAdapter employs to connect to the database also needs select and update to the queue table. This table is what the AqAdapter polls for new messages in the queue.
grant select on aq$myqueue_query_table to role;grant update on aq$myqueue_query_table to role;
This is an informative blog to everyone in which it would really helps to gain knowledge
ReplyDeleteabout this technology.
Japanese Classes in Chennai
learn Japanese in Chennai
German Language Course in Chennai
TOEFL Classes in Chennai
IELTS Coaching centre in Chennai
spanish classes in chennai
Japanese Classes in Anna Nagar
Japanese Classes in Tnagar
Spoken English Class in Anna Nagar
spoken english course in anna nagar
IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.
DeleteIEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.
corporate training in chennai corporate training in chennai
corporate training companies in india corporate training companies in india
corporate training companies in chennai corporate training companies in chennai
I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai
TreasureBox is operated by a group of young, passionate, and ambitious people that are working diligently towards the same goal - make your every dollar count, as we believe you deserve something better.
ReplyDeleteCheck out the best
body pillow nz
playpen nz
First off, a hearty thanks to you.
ReplyDeleteYour blog is awesome and completely knowledgeable and I completely satisfied with the reading. Keep your work spread till long after. For more Cervical Traction Pillow related information visit Eliterest.