Teradata SQL Error and Failure Codes from Error 5691 To 5702


5691 Invalid RowId field.
Explanation: Views and derived tables do not have a RowId field.
Generated By: RES Module.
For Whom: End-User
Remedy: Rewrite the query without using the RowId field and re-submit the query.

5693 Too many roles listed in GRANT/REVOKE statement.
Explanation: The maximum number of roles that can be granted or revoked in one statement is 25.
Generated By: RES modules.
For Whom: End User.
Remedy: Separate the statement into two or more statements each granting or revoking no more than 25 roles.

5694 Database specified for function ’%VSTR’ is ambiguous.
Explanation: The user referenced two different databases in the create function statement.
Generated By: RES modules.
For Whom: End User.
Remedy: Qualify the overloaded function name and specific function name with the same database name, and resubmit
the request.

5695 ’%VSTR’ is not a global temporary trace table.
Explanation: The table specified in the SET SESSION TRACE statement must be a global temporary trace table.
Generated By: RES modules.
For Whom: End User.
Remedy: Change the table reference to a global temporary trace table and resubmit the request.

5696 Invalid AMP Vproc ID specified.
Explanation: User specified an invalid AMP VProc ID in the SET SESSION DEBUG FUNCTION statement.
Generated By: RES modules.
For Whom: End User.
Remedy: Correct the AMP Vproc ID and resubmit the request.

5697 Multi-statement request with USING clause inserting into tables with Identity Column is not allowed.
Explanation: User specified a multi-statement request with USING clause which has insert statements into more than
one table with Identity Column.
Generated By: RES module (residcol).
For Whom: End User.
Remedy: Correct the AMP Vproc ID and resubmit the request

5698 SysSecDefaults table has a zero value for PasswordMinChar/PasswordMaxChar.
Explanation: The value contained in the column PasswordMinChar must be between 1 and 30. The value contained in
column PassWordMaxChar must also be between 1 and 30 and equal to or greater than that in PasswordMinChar.
Generated By: MgcSecOp.
For Whom: Site Administrator.
Remedy: Correct the value for PasswordMaxChar or for PasswordMinChar in the table SysSecDefaults and restart the

5699 Internal error: Could not convert a parse tree into text.
Explanation: Because of an internal problem, the PE has decided the parse tree could not be converted into text format.
Generated By: RES and OPD modules.
For Whom: End User, and System Support Representative.
Remedy: Save a test case, and contact your support representative for an analysis of the error.

5700 Invalid alternate parcel header sent by the host.
Explanation: The alternate parcel has 2 reserved bytes following the Parcel flavor that must be set to 0. If this is a nonzero
Value, this error is reported.
Generated By: Pardrivr, Dispatcher modules
For Whom: End user
Remedy: The reserved bytes in the parcel must be set to 0 and then Re-submitted.

5701 Insufficient memory for workload cache.
Explanation: The maximum amount of workload cache memory has been exceeded during an Index Wizard Analysis or
Validation operation. * <- DR113879-sb230098-01 *
Generated By: OPU routines.
For Whom: End-User * DR113879-sb230098-01-> *
Remedy: Increase the maximum size of the workload cache by reconfiguring one of the following DBS Control settings:
IAMaxWorkloadCache for Analysis statements IVMaxWorkloadCache for Validation statements
If the error still persists after increasing these settings to their maximum value, try removing one or more queries from the
workload being Analyzed or one or more statements from the Validation session. * <- DR113879-sb230098-01 *

5702 Bad kind for workload cache.
Explanation: The kind of the workload cache data structure is not defined.
Generated By: OPU routines.
For Whom: End-User
Remedy: Check the kind, and used a defined one.

Above are list of Teradata Errors or Failure Codes from Error 5691 To 5702 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.

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 *