Teradata Database Message 7464 - 7464 - Analytics Database - Teradata Vantage

Message

Compare difference table %DBID.%TVMID has incorrect definition.

Explanation

The defintion of the compare difference table should have the following definition: field 1 : error code (data type SMALLINT, Not Null) field 2 - N : primary key columns from target table. The data type of each columns should be identical to that of target table and the columns should be in the order the primary key appears in DBC.Indexes table (The FieldPosition in DBC.Indexes indicates the order of the index columns. It is in field Id order.) These columns should also be defined as the nonunique primary index of the compare difference table.

Generated By

Replication Utility.

For Whom

RSG (Replication Service Gateway)

Notes

The primary key index Id of target table can be obtained from DBC.TVM and the primary key index columns and the order of it can be obtained from DBC.Indexes. The data type of each column can be obtained from DBC.TVFields.

Remedy

Correct the definition of the compare difference table and start a new utility.