I dont want to rebuild WF DEFERRED queue as need bounce of db.
I would like to purge it clean.
There are 2000 READY and those are error in customization and I want to get rid of these and 2000 Expired.
Tried the scipt
sqlplus apps/xx @$FND_TOP/sql/wfevqcln.sql WF_DEFERRED customevent 0
but its not cleaning that.
Any suggestion how to purge READY and EXPIRED.
Thx alot!
Br,Laurel :)
Thanks Laurel :) I hope everyting is good on your side as well.
Please review MOS document : How To Rebuild The WF_DEFERRED Queue (Doc ID 286394.1)
There are instructions for backing up and recreating the WF_DEFERRED Queue..
Also there is an instruction to re-enqueue the messages from WF_QUEUE_TEMP_TABLE(backup one) to WF_DEFERRED(rebuilded one, clean one).. So probably, in this step, you can do some manipulations..
The idea comes to my mind is to delete the things that you wanna remove.. (delete them from WF_QUEUE_TEMP_TABLE) and then re-enqueue everyting which remain in WF_QUEUE_TEMP_TABLE back in the to clean/fresh/newly rebuilded WF_DEFERRED :)..
Hi Erman!
Thxs for answer :)
I did not like that note, as it needs to bounce the db and recreating all queue is bit too much.
This one worked as well.
STopped WF, made sure no READY events that are neededed, purged, started.
declare
po dbms_aqadm.aq$_purge_options_t;
begin
po.block := true;
dbms_aqadm.purge_queue_table(queue_table => 'APPLSYS.WF_DEFERRED',
purge_condition => NULL,
purge_options => po);
end;
/
Locked
