Oracle Error ORA-24055: cannot delete propagation status rows that are in prepared state

Oracle Error Message

ORA-24055: cannot delete propagation status rows that are in prepared state

Reason for the Error

An attempt was made to use the internal administration procedure to delete status rows from the SYS.AQ$_PROPAGATION_STATUS table that were in the prepared state.

Solution

Wait for the propagation to complete successfully before retrying the operation.