Issue:
WF_DEFERRED_R & WF_DEFERRED_N
Rule Set become invalid, when try to reload (add & remove the subscriber
and rule set) the WF_DEFERRED queue. I was getting below error.
ERROR at line 1:
ORA-24166: evaluation context APPLSYS.AQ$_WF_DEFERRED_V has errors
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7035
ORA-06512: at "SYS.DBMS_AQADM", line 549
ORA-06512: at line 7
ORA-24166: evaluation context APPLSYS.AQ$_WF_DEFERRED_V has errors
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7035
ORA-06512: at "SYS.DBMS_AQADM", line 549
ORA-06512: at line 7
This shows WF_DEFERRED queue is corrupted, and couldn’t
process any workflow notifications. So we have to drop and recreate wf_deferred queue and queue
tables.
Solution:
Follow Note ID: 286394.1, to rebuild wf_deferred queue. This will solve the problem.
Comments