Teradata SQL Error and Failure Codes from Error 6869 To 6878

SQLServerF1_Header_Small

6869 Invalid name : %VSTR
Explanation: The name is invalid: –The Transform Group name must not start with “TD_”. “TD_” is reserved for Internal
type UDT Transform Group names.
Generated By: RES modules.
For Whom: End User.
Remedy: Correct and re-submit the query.

6870 Invalid UDT Ordering. %VSTR
Explanation: The ordering for the UDT is invalid: –For Distinct and Structured User Defined Types, Ordering Category
must be MAP Ordering, Ordering Form must be FULL. –For Internal User Defined Type, Ordering Category must be MAP
or RELATIVE, Ordering Form must be FULL or EQUALS.
Generated By: RES modules.
For Whom: End User.
Remedy: Correct and re-submit the query.

6871 Invalid UDT specified for the UDM
Explanation: The UDT specified for a UDM is not valid. For example: CREATE ORDERING for <UDT Name 1> ORDER
FULL BY MAP WITH INSTANCE METHOD OrderUDM FOR <UDT Name 2>; <UDT Name 2> must match <UDT Name
1>, otherwise, an error is generated.
Generated By: RES modules.
For Whom: End User.
Remedy: Correct and re-submit the query.

6872 Distinct types cannot have constructor method.
Explanation: Constructor method cannot be specified for distinct types.
Generated By: RES modules.
For Whom: End User.
Remedy: Resubmit the query without the constructor method signature.

6873 Only user DBC can create Internal Types.
Explanation: User DBC can only create Internal types.
Generated By: RES modules.
For Whom: End User.
Remedy: Resubmit the query as user DBC.

6874 Constructor methodname and the typename should be the same.
Explanation: Constructor methodname and the typename must be the same.
Generated By: RES modules.
For Whom: End User.
Remedy: Correct the constructor method name and resubmit the query.

6875 Duplicate methods in method signatures. %VSTR
Explanation: The methods declared in the method signatures need to be unique and duplicate methods in the signatures
are not allowed.
Generated By: RES modules.
For Whom: End User
Remedy: Resubmit the SQL query without duplicate methods.

6876 Duplicate attribute names in the attribute list. %VSTR
Explanation: The attribute list for structured types should not have duplicate attribute names in them.
Generated By: RES modules.
For Whom: End User
Remedy: Resubmit SQL without duplicate attribute names.

6877 Data type must be UDT. %VSTR
Explanation: The data type must be User Defined Type (UDT): –For CREATE/REPLACE/DROP CAST, either the data
type of the Source or the data type of the Target specified for the CAST must be User Defined Type. (It is also valid if both
the Source and Target are UDTs).
Generated By: RES modules.
For Whom: End User.
Remedy: Correct and re-submit the query.

6878 %FSTR operation is not allowed on %VSTR type UDT
Explanation: The operation is not allowed on the type of User Defined Type (UDT): –REPLACE TRANSFORM/
REPLACE ORDERING/REPLACE CAST operations are not allowed on the Internal Type UDT.
Generated By: RES modules.
For Whom: End User.
Remedy: Correct and re-submit the query.

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