Teradata SQL Error and Failure Codes from Error 5650 To 5663

5650 Text size exceeds Parser limit.
Explanation: The user specified a text that cannot fit in one parse tree node.
Generated By: SYN modules that generate tree
For Whom: End user
Remedy: The request may be exceeding some limits the system is imposing. Check the request, correct and re-submit.

5652 A profile already exists with that name.
Explanation: Profile names must by unique amongst profiles.
Generated By: RES or OPD module.
For Whom: End User.
Remedy: Specify a unique profile name and re-submit the request.

5653 Profile ’%VSTR’ does not exist.
Explanation: The user referred to a profile as %VSTR. That profile does not exist.
Generated By: RES and OPT modules.
For Whom: End User.
Remedy: Correct the Teradata SQL statemenet by using a valid name for the profile and resubmit the request.

5654 The value for PasswordMinChar exceeds that for PasswordMaxChar.
Explanation: The PasswordMinChar value must not exceed the PasswordMaxChar value. PasswordMinChar and PasswordMaxChar
can be specified in the table SysSecDefaults or via a profile.
Generated By: OPD modules.
For Whom: Site Administrator.
Remedy: Correct the value for PasswordMaxChar or for PasswordMinChar in the table SysSecDefaults or in the profile.

5656 Internal error in UDF/XSP/UDM/UDT/JAR compile task.
Explanation: During the startup of the cuftsk, a problem was found. Or during execution some other error was encountered.
Or problem with cufdoudf.
Generated By: CUFTsk, CUFdoUDF
For Whom: Support Representative.
Remedy: If the problem presists, notify your Support Representative.

5658 When Clause is not satified
Explanation: This error indicates that the triggered when clause is not is not satisfied. This error is not returned to the user.
Generated By: OPT, GNS, AMP Modeules
For Whom: Internal
Remedy: Please save the traceback and any pertinent information that would help an analyst to reproduce the problem,
and contact the Global Support Center.

5659 Table has too many LOB columns.
Explanation: A user table or an internal table (spool file) has too many LOB fields. User defined tables and macros are
limited to 32 LOB columns.
Generated By: RES and OPT modules.
For Whom: User.
Remedy: Tables and views cannot be created or modified to have more than 32 LOB columns. Response rows and rows
of spool tables used in joins are also restricted.

5660 Cannot create index on LOB columns.
Explanation: Cannot create index on LOB data type.
Generated By: OPD modules.
For Whom: End User.
Remedy: Remove the index on the LOB column.

5661 Cannot collect statistics on LOB column.
Explanation: Cannot collect statistics on LOB data type.
Generated By: OPD modules.
For Whom: End User.
Remedy: Remove the LOB column from the COLLECT STATISTICS statement.

5662 Numeric operation on LOB data type is illegal.
Explanation: LOB data cannot be used in most numeric operations.
Generated By: OPT modules.
For Whom: The End User.
Remedy: Remove the LOB column from the numeric expression.

5663 Numeric operation on LOB data type in column %VSTR is illegal.
Explanation: LOB data cannot be used in most numeric operations.
Generated By: OPT modules.
For Whom: The End User.
Remedy: Remove the LOB column from the numeric expression.

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