Teradata Database Message 2840 - 17.10 - 2840 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Data rows discarded due to inconsistent hash codes
During a restore operation, some rows were discarded because of inconsistencies in the row hash codes.
Generated By
For Whom
End User. Site support representative.
Two situations cause this error to occur: 1) During an attempt to restore a row, a row with the same rowid but different data was found on the disk. 2) During a specific-AMP restore, the AMP received a data block containing a row that it does not own, even though reconfiguration has not taken place since the dump. The situation may be caused either by a software bug (the rows were mis-distributed when the dump was taken) or a user error (updating the table before the table was completely restored). In either case, the restore continues unaffected, except that the offending rows are discarded. Associated with this error is a count of the rows discarded.
If the error is caused by an operational error, start the restore process over or accept an incomplete table. If there were no operational errors, contact your Support Representative.