VIEW: SYS.DBA_APPLY_ERROR

Source

View Text - Preformatted

select p.apply_name, e.queue_name, e.queue_owner, e.local_transaction_id,
       e.source_database, e.source_transaction_id,
       e.source_commit_scn, e.message_number, e.error_number,
       e.error_message, e.recipient_id, e.recipient_name, e.message_count,
       e.error_creation_time, e.external_source_pos,
       (case
          when (bitand(e.flags, 1) = 1) then 'EAGER ERROR'
          when (bitand(e.flags, 8) = 8) then
            (case
               when (bitand(e.flags, 2) = 2) then 'RECORD LCR'
               when (bitand(e.flags, 16) = 16) then 'RECORD TXN NO LCRS'
               else 'RECORD TXN WITH LCRS'
             end)
          when (bitand(e.flags, 16) = 16) then 'UNHANDLED ERROR NO LCRS'
          else NULL
       end), p.source_root_name, e.error_pos
  from "_DBA_APPLY_ERROR" e, sys.streams$_apply_process p
 where e.apply# = p.apply#(+)

View Text - HTML Formatted

SELECT P.APPLY_NAME
, E.QUEUE_NAME
, E.QUEUE_OWNER
, E.LOCAL_TRANSACTION_ID
, E.SOURCE_DATABASE
, E.SOURCE_TRANSACTION_ID
, E.SOURCE_COMMIT_SCN
, E.MESSAGE_NUMBER
, E.ERROR_NUMBER
, E.ERROR_MESSAGE
, E.RECIPIENT_ID
, E.RECIPIENT_NAME
, E.MESSAGE_COUNT
, E.ERROR_CREATION_TIME
, E.EXTERNAL_SOURCE_POS
, (CASE WHEN (BITAND(E.FLAGS
, 1) = 1) THEN 'EAGER ERROR' WHEN (BITAND(E.FLAGS
, 8) = 8) THEN (CASE WHEN (BITAND(E.FLAGS
, 2) = 2) THEN 'RECORD LCR' WHEN (BITAND(E.FLAGS
, 16) = 16) THEN 'RECORD TXN NO LCRS' ELSE 'RECORD TXN WITH LCRS' END) WHEN (BITAND(E.FLAGS
, 16) = 16) THEN 'UNHANDLED ERROR NO LCRS' ELSE NULL END)
, P.SOURCE_ROOT_NAME
, E.ERROR_POS
FROM "_DBA_APPLY_ERROR" E
, SYS.STREAMS$_APPLY_PROCESS P
WHERE E.APPLY# = P.APPLY#(+)