Teradata SQL Error and Failure Codes from Error 9165 To 9176

9165 Division by zero in an operation involving an ARRAY type.
Explanation: A division by zero was attempted on or with an element of an ARRAY type.
Generated By: UDT subsystem.
For Whom: End User.
Remedy: Change/Update the zero or zeros to different value(s) and resubmit.

9166 Overflow occured in an operation involving an ARRAY type.
Explanation: An arithmetic operation on two numeric types (with at least one as an element of an array type) caused the
result to be unrepresentable in that data type.
Generated By: UDT subsystem.
For Whom: End User.
Remedy: Change/Update the value(s) that caused the overflow.

9167 Tried to access an uninitialized element of an ARRAY type.
Explanation: The array has not been completely initialized and access to an element in the uninitialized section was
attempted. This could occur when passing an array to a function that performs an operation for each element of the array.
Uninitialized elements are not treated as NULL because a NULL element is considered to be initialized.
Generated By: UDT subsystem.
For Whom: End User.
Remedy: Initialized any values of the array that are being accessed and resubmit.

9168 %VSTR index is outside of the bounds of the ARRAY type.
Explanation: A index or bound given by the user lies outside the bounds of the passed ARRAY type.
Generated By: UDT subsystem.
For Whom: End User.
Remedy: Fix the index or bound to be inside of the ARRAY types’ bounds and resubmit.

9169 An unspecified error occured while performing an arithmetic operation on an ARRAY type.
Explanation: An error occured while performing arithmetics on the ARRAY that was not an overflow error or a divide
by zero error as they have their own error codes.
Generated By: UDT subsystem.
For Whom: Array Type developer.
Remedy: This is an internal issue and should be brought up to a Teradata representative.

9170 ARRAY IS NULL: Null ARRAY value passed to %VSTR.
Explanation: A NULL ARRAY value was passed to the function.
Generated By: UDT subsystem.
For Whom: End User.
Remedy: Remove the NULL ARRAY TYPEs from the query and resubmit.

9171 A passed subscript value was greater than the count of an ARRAY type.
Explanation: A passed subscript value was greater than the count of an ARRAY type.
Generated By: UDT subsystem.
For Whom: End User.
Remedy: Modify the subscript or the ARRAY type.

9172 A passed subscript value was outside the bounds of an ARRAY type.
Explanation: A passed subscript value was outside the bounds of an ARRAY type.
Generated By: UDT subsystem.
For Whom: End User.
Remedy: Modify the subscript or the ARRAY type.

9173 %VSTR
Explanation: A value was passed to a field that couldn’t be accepted. See the error for more information.
Generated By: UDT subsystem.
For Whom: End User.
Remedy: Modify the passed value to the array type function.

9174 The number of Array element values is exceeding the Array’s max Cardinality.
Explanation: The number of Array element values is exceeding the Array’s max Cardinality.
Generated By: moverowp
For Whom: End User.
Remedy: Reduce the number of Array element values to be less than the Array’s max Cardinality.

9175 Table %VSTR must be empty to decrease precision or scale.
Explanation: Precision and scale for a number column cannot be decreased by a ALTER TABLE statement when the
table is non-empty.
Generated By: OPD modules.
For Whom: End User.
Remedy: If the precision/scale needs to be decreased for a number column, delete all the rows in the table.

9176 Increase in scale should be less than increase in precision for a non-empty table %VSTR.
Explanation: Precision and scale for a number column cannot be decreased by a ALTER TABLE statement when the
table is non-empty.
Generated By: OPD modules.
For Whom: End User.
Remedy: If the precision/scale needs to be decreased for a number column, delete all the rows in the table.

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