Unable to Unschedule Propagation. Streams Queue is Invalid
(Doc ID 368237.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.
Attempting to unschedule Streams propagation fails with the following error:
ERROR at line 1:
ORA-24080 : unschedule_propagation pending for QUEUE STRMADMIN.Q_PLN40_DTD_TRADE
and DESTINATION PSGDTD40.WORLD
ORA-06512 : at "SYS.DBMS_PRVTAQIP", line 1472
ORA-06512 : at "SYS.DBMS_PRVTAQIP", line 1517
ORA-06512 : at "SYS.DBMS_AQADM", line 806
ORA-06512 : at line 1
Tried the solution in Note:118884.1 but it did not help.
The propagation schedule keeps getting into "Pending" state every time we try to remove it.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document