Unable to Unschedule Propagation. Streams Queue is Invalid (Doc ID 368237.1)

Last updated on MAY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.

Symptoms

Attempting to unschedule Streams propagation fails with the following error:

Exec dbms_aqadm.unschedule_propagation('STRMADMIN.Q_PLN40_DTD_TRADE','PSGDTD40.WORLD')

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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms