Oracle Error ORA-26791: Cannot split or merge propagation “string”

Oracle Error Message

ORA-26791: Cannot split or merge propagation “string”

Reason for the Error

A process tried to split or merge this propagation, but failed and left STREAMS in an inconsistent state.

Solution

Query DBA_RECOVERABLE_SCRIPT_BLOCKS view, and roll back the script which tried to split or merge this propagation.