Teradata SQL Error and Failure Codes from Error 2755 To 2766

SQLServerF1_Header_Small

2755 Fallback data row is in wrong subtable.
Explanation: A row is found to be in the wrong subtable when the data subtables are scanned.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2756 Fallback data row is missing.
Explanation: Missing fallback data rows are detected.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2757 Primary data row is missing.
Explanation: Extra fallback data rows are detected.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2758 USI row out of order.
Explanation: Out of order index rows are detected as the index subtables are traversed. The row is discarded from the
remainder of the checking process.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2759 USI row has same row id as previous row
Explanation: Duplicated index rows are detected as the index subtables are traversed. The row is discarded from the
remainder of the checking process.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2760 Primary USI row is on wrong AMP
Explanation: Incorrectly distributed index rows are detected as the index subtables are traversed. The row is discarded
from the remainder of the checking process.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2761 Fallback USI row is on wrong AMP.
Explanation: Incorrectly distributed index rows are detected as the index subtables are traversed. The row is discarded
from the remainder of the checking process.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2762 Fallback USI row is in wrong subtable.
Explanation: Incorrectly distributed index rows are detected as the index subtables are traversed. The row is discarded
from the remainder of the checking process.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2763 USI row indexes non existent data row.
Explanation: Non existent indexed data rows are detected during the check for unique secondary indexes.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2764 Data row not indexed by USI.
Explanation: Unindexed data rows are detected during the check for unique secondary indexes.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2765 Data row indexed multiple times by USI.
Explanation: Multiply indexed data rows are detected during the check for unique secondary indexes.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

2766 Fallback USI row is missing.
Explanation: A missing fallback unique secondary index row is detected.
Generated By: CheckTable
For Whom: Site support representative
Remedy: Contact your Support Representative.

Above are list of Teradata Errors or Failure Codes from Error 2755 To 2766 received while performing certain operation against Teradata Database or related products.

What are Teradata Database Errors?

In general, each Teradata error message contains the following information:
• The message number.
• The message text. This text is usually returned with the message number. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.
• Generated-by text that indicates the software module which initiated the message. This field serves a diagnostic purpose for support and development personnel.
• A remedy which suggests how to resolve the condition.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Teradata SQL Error and Failure Codes and Error Messages on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *