Troubleshooting DELTA execution failures | Teradata Data Mover - Troubleshooting DELTA Execution Failures - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
During DELTA executions, previously successful incremental copy jobs may fail with following errors:
  • Error code: 1187, error message: Incremental Restore is not allowed because table 'db.table' is not in read-only state
  • Error code: 1186, error message: Incremental Restore is not being processed in the correct order for table 'db.table'
These errors indicate job conflicts due to multiple jobs copying to the same target table, for example:
  • A BAR restore job and a Data Mover incremental job copying to the same target table
  • Two Data Mover incremental jobs copying to the same target table

To recover from the job failures, re-run the failed incremental job with "ir_execution_type" parameter set to "full" to do a FULL table copy: datamove start -job_name my_ir_job -ir_execution_type full

To prevent future errors, user needs to make sure not to restore or copy to the same target table across BAR and Data Mover DSCs.