REPORTTMFEXCEPTIONS

Valid for

Replicat

Description

Use REPORTTMFEXCEPTIONS for debugging purposes, generally in conjunction with Oracle GoldenGate Technical Support. REPORTTMFEXCEPTIONS reports when Replicat detects a TMFEXCEPTIONS type of condition. Messages are written to the report file in the following format:

location_id FILE target_file_name POS (seqno, rba)

Values for location_id include:

"track duplicate": A duplicate record that occurred on insert was placed on the list of records to be tracked.
"backout of duplicate": A TMF backout delete record was matched to a duplicate insert (so no processing is required and the duplicate error is no longer tracked).
"fix reversed insert": A delete record matched to out-of-order duplicate insert
"update backout": An update record matched to correct a duplicate record
"reapply update": Attempting to process record from missing update list
"reapply duplicate": Attempting to process record from duplicate list
"keep missing update": A missing update/delete record was placed on list
"reversed update": An insert record was overlaid with an update/delete from the missing updates list
"reversed insert add col": When applying an update record to a record on the duplicate list, a column in the source update was not present in the record on the duplicate list. This column was added to the target record.
"reversed insert from update": An update record was overlaid with a record on the duplicate list.
"reversed insert from delete": A delete record was matched to an out-of-order duplicate insert
"Reapply duplicate rec failed": The attempt to process the updated duplicate record failed.
"REVERSEWINDOWSECS expired for duplicate": The timer expired before the reversed situation was corrected.
"REVERSEWINDOWSECS expired for missing delete": The timer expired before the reversed situation was corrected.
"REVERSEWINDOWSECS expired for missing update": The timer expired before the reversed situation was corrected.

Default

OFF

Syntax

REPORTTMFEXCEPTIONS {OFF | ON}