Teradata SQL Error and Failure Codes from Error 5168 To 5177

5168 An invalid reference pointer has been detected.
Explanation: An invalid pointer was detected.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates a File System software error.
Remedy: Contact a field engineer.

5169 The passed buffer is too small.
Explanation: The buffer passed to TabRBLKS routine is not big enough to hold even one row.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates a Data Base System software error.
Remedy: Contact a field engineer.

5170 The logical position for the DBD in the MI is invalid.
Explanation: The logical position for the current DBD in the MI is found to be inva lid for the append operation.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates a Data Base System software error.
Remedy: Contact a field engineer.

5171 The logical position of the DBD in the CI is invalid.
Explanation: The logical position of the current DBD in the CI is found to be inva lid for the current operation.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates a Data Base System software error.
Remedy: Contact a field engineer.

5172 The row size is not a multiple of 8.
Explanation: The size of a row being inserted or updated is not a multiple of 8. This may cause an alignment problem.
This error will be generated only on a system having the 64-bit row format.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates a Data Base System software error.
Remedy: Contact a field engineer.

5173 The sector count in DBD is wrong.
Explanation: The sects field in a DBD must be greater than zero and less than SYSMAXDATABLOCKSECTORS.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates a Data Base System software error.
Remedy: Contact a field engineer.

5174 This is the last row of the table.
Explanation: A row matching the specified criteria is the last row of the subtable. This code is returned on a rowraft (or
rowr1stla) when the user issued a rowr1stla.
Generated By: File System
For Whom: Field Engineer
Notes: Database should not ask for another row.
Remedy: Contact Field Engineer.

5175 ………………………………………………………..
FILABORT : Detected LSI interrupted write pattern:
%s ………………………………………………………..
Explanation: An interrupted write pattern was found in a block. This pattern is placed there by disk array vendors when
a requested write could not be completed.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates that an interrupted write occured at some time in the past and is being detected on a read operation.
Remedy: Contact a field engineer.

5176 The data block checksum is invalid.
Explanation: The checksum located in the DBD does not match the data in the DB.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates a Hardware or a File System software error.
Remedy: Contact a field engineer.

5177 The cylinder index checksum is invalid.
Explanation: The checksum located in the CID does not match the data in the CI.
Generated By: File System
For Whom: Field Engineer
Notes: This indicates a Hardware or a File System software error.
Remedy: Contact a field engineer.

Above are list of Teradata Errors or Failure Codes from Error 5168 To 5177 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 *