Teradata SQL Error and Failure Codes from Error 3560 To 3571

3560 Column %VSTR is modified more than once in this statement.
Explanation: The column is referenced more than once in a ALTER TABLE statement.
Generated By: OPT modules.
For Whom: End User.
Remedy: Delete the repeated column reference and resubmit the request.

3561 Cannot DROP USER %VSTR while the user is logged on.
Explanation: A DROP USER statement was executed while the user was still logged on.
Generated By: OPT modules.
For Whom: End User.
Remedy: Wait until the user is logged off and resubmit the request.

3562 New column %VSTR has no data type.
Explanation: The column to be added to a table has no data representation specified.
Generated By: OPT modules.
For Whom: End User.
Remedy: Resubmit the statement with a data representation phrase for the column.

3563 Internal error: The access log rule was not located in the cache.
Explanation: This is a strictly internal error used to convey information to higher level routines. It should NEVER be
reported to users either as a message or a system restart reason.
Generated By: MgcAlgRl
For Whom: Internal
Remedy: Save all relevant information and contact your support representative.

3564 Range constraint: Check error in field %TVMID.%FLDID.
Explanation: The user tried to place data in a column whose definition does not allow the user- supplied value. Look for a BETWEEN clause in the column definition.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the value and resubmit the request.

3565 Database has tables without After Image Journaling.
Explanation: The user had chosen Group Read Lock and the table does not have After Image Journaling.
Generated By: OPT modules.
For Whom: End User.
Remedy: Add Journaling to the tables and resubmit request.

3566 Database does not have a PERMANENT journal.
Explanation: An operation requires that the database have a default permanent journal.
Generated By: RES modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.

3567 Deleting database ’DBC’ is not allowed.
Explanation: The database “DBC” cannot be deleted.
Generated By: OPT modules.
For Whom: End User.
Remedy: Check the name of the database to be deleted.

3568 Cannot nest aggregate operations.
Explanation: Aggregate operators may not be applied to expressions that already contain aggregate operators.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the expression and resubmit the request.

3569 Improper use of an aggregate function in a WHERE Clause.
Explanation: Aggregate operators may not be executed in a WHERE Clause unless they are used in an ABORT statement.
Generated By: RES and OPT modules.
For Whom: End User.
Remedy: Correct the WHERE clause and resubmit the request.

3570 Internal error processing query with aggregate functions.
Explanation: The Optimizer has encountered an illegal combination of clauses in a query involving aggregate functions.
If the error is detected here, it is probably an internal error, rather than an invalid user syntax.
Generated By: OPT modules.
For Whom: System Support Representative
Remedy: Contact your support representative.

3571 Database ’DBC’ cannot have a PERMANENT journal.
Explanation: The database “DBC” cannot have a PERMANENT journal.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.

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