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:
A duplicate record that occurred on insert was placed on the list of records to be tracked.
A TMF backout delete record was matched to a duplicate insert (so no processing is required and the duplicate error is no longer tracked).
A delete record matched to out-of-order duplicate insert
An update record matched to correct a duplicate record
Attempting to process record from missing update list
Attempting to process record from duplicate list
A missing update/delete record was placed on list
An insert record was overlaid with an update/delete from the missing updates list
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.
An update record was overlaid with a record on the duplicate list.
A delete record was matched to an out-of-order duplicate insert
The attempt to process the updated duplicate record failed.
The timer expired before the reversed situation was corrected.
The timer expired before the reversed situation was corrected.
The timer expired before the reversed situation was corrected.
Default
OFF
Syntax
REPORTTMFEXCEPTIONS {OFF | ON}