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
FILEtarget_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}