The compare or repair fails with “Cannot compare” and “Target is table with tracking columns” (4302547)

Chat now with support

Return

Title

The compare or repair fails with “Cannot compare” and “Target is table with tracking columns”
Description

When running compare or repair on a table involved in Change History, also referred to as Change Data Capture (CDC), the following errors show up:
When comparing:
sp_ctrl (alvsupu07:5438)> compare sha86.table4
Cannot compare "SHA86"."TABLE4"
Target is table with tracking columns
comparing 0 of 1 objects
1 object(s) contain errors
No objects to compare; no job started
When repairing:
sp_ctrl (alvsupu07:5438)> repair sha86.table4
Cannot repair "SHA86"."TABLE4"
Target is table with tracking columns
repairing 0 of 1 objects
1 object(s) contain errors
No objects to repair; no job started

Sign In Required

You need to be signed in and under a current maintenance contract to view premium knowledge articles.