Teradata SQL Error and Failure Codes from Error 3776 To 3787

SQLServerF1_Header_Small

3776 Comment not terminated before end of request text.
Explanation: A closing comment (’*’) was missing.
Generated By: LEX modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.

3778 SELECT statement must follow LOCK ROW modifier.
Explanation: This code indicates that the user has not specified a SELECT statement for the LOCK ROW modifier.
Generated By: OPT modules.
For Whom: End User.
Remedy: Re-submit the LOCK ROW modifier with a SELECT statement.

3779 Fractional digits must be between 0 and total digit number.
Explanation: The decimal column definition specified for the fractional part is more than 18 decimal digits, less than
zero, or more than the number of total digits.
Generated By: SYN modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.

3780 SysSecDefaults Row not found, Base Default values used.
Explanation: On system startup, the single row in table DBC.SysSecDefaults that should exist, with a primary index
value of 1, has not been found. The Base default values have been used, providing no 5.0 password security options.
Generated By: MgcSecOp.
For Whom: System Administrator.
Remedy: Check status of DBC.SysSecDefaults and insure that a single row is created with primary index value of 1 and
the desired values for the password security options. Then, restart system.

3781 No aggregate operation allowed in the search condition for a joined table.
Explanation: aggregate operations (SUM, MAX, MIN, AVG, COUNT) are not allowed in a search condition for a joined
table.
Generated By: RES module
For Whom: End User
Remedy: Correct search condition and resubmit request.

3782 Improper column reference in the search condition of a joined table.
Explanation: A column reference in the search condition (ON clause) of the outer join does not belong to any of the two
joined table involved.
Generated By: RES module
For Whom: End User
Remedy: Correct search condition and resubmit request.

3784 The number of digits specified must be between 1 and 38.
Explanation: The user has specified a value n less than 1 or more than 38 in declaring a data type of DECIMAL(n,m) or a
data description of n DIGITS.
Generated By: SYN modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.

3785 Expected ANY or ALL is missing.
Explanation: If a parenthesized list is specified as the right operand of a comparison predicate, it must be preceded by ANY or ALL.
Generated By: SYN modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.

3786 Range value incompatible with type of column %VSTR.
Explanation: The high and low range must be values compatible with the type of the column.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.

3787 Illegal duplicate entry in a list.
Explanation: A list that should contain no duplicate values contains one. Examples are HostIDs and Users in
GRANT/REVOKE LOGON. For the case of BEGIN/END LOGON this error occurs if the User Name list contains duplicate
entries or the Object Name list contains duplicate entries.
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 3776 To 3787 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 *