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

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Data rows discarded due to inconsistent hash codes
Explanation
During a restore operation, some rows were discarded because of inconsistencies in the row hash codes.
Generated By
Restore.
For Whom
End User. Site support representative.
Notes
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.
Remedy
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.