ORA-24067: exceeded maximum number of subscribers for queue

mac2024-05-13  27

oracle.jms.AQjmsException: ORA-24067: exceeded maximum number of subscribers for queue FWBZ.SMS_MT_QUEUE

ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4459

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_AQJMS_INTERNAL", line 110

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_AQJMS", line 101

ORA-06512: at line 1

 

truncate table aq$_ss_MT_tab_D; truncate table aq$_ss_MT_tab_g; truncate table aq$_ss_MT_tab_h; truncate table aq$_ss_MT_tab_i; truncate table aq$_ss_MT_tab_p; truncate table aq$_ss_MT_tab_s; truncate table aq$_ss_MT_tab_t; delete from aq$_ss_MT_tab_D; delete from aq$_ss_MT_tab_g; delete from aq$_ss_MT_tab_h; delete from aq$_ss_MT_tab_i; delete from aq$_ss_MT_tab_p; delete from aq$_ss_MT_tab_s; delete from aq$_ss_MT_tab_t; commit;

 

最新回复(0)