15.00 - 7464 Compare difference table %DBID.%TVMID has incorrect definition. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

7464 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.