event_log has the below entries
07/21/08 01:34 Process exited sp_opst (for o.SOURCE_SID-o.TARGET_SID queue NAME) [pid = 5861] - exit(1)
07/21/08 01:34 Error: Unexpected Oracle error: ORA-25402: transaction must roll back. (object name:
"TABLE_OWNER"."TABLE_NAME") [sp_opst (for o.SOURCE_SID-o.TARGET_SID queue NAME)/PID]
07/21/08 01:34 Notice: ORA-25402: transaction must roll back. [sp_opst(osp)/PID]