Teradata SQL Error and Failure Codes from Error 3627 To 3638

SQLServerF1_Header_Small

3627 Illegal use of DISTINCT Aggregate Expressions.
Explanation: The given SELECT operation uses an aggregate function that specifies the DISTINCT option, as in:
COUNT( DISTINCT <expression> );
Uses of the DISTINCT modifier are restricted to:
(a) the SELECT List, ORDER BY, and HAVING clause of a select statement that uses a GROUP BY clause, or;
(b) the first WITH clause SELECT list for select statements that do not use a GROUP BY clause.
Multiple use of DISTINCT modifier is restricted when there is a WITH clause.
The option can not be used in both places, and the option can not be used in multiple WITH Clauses. In the given query, the DISTINCT option is not being properly used.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the request and resubmit it.

3629 The ABORT request uses overly complex aggregate functions.
Explanation: The given ABORT operation either contains conditions that force processing into an illegal join situation,
or that result in aggregate processing of an expression that does not reference any tables.
Generated By: OPT modules.
For Whom: End User.
Remedy: Contact the nearest S.E. for a recommendation for how the query can be rewritten to avoid this error.

3630 Default value incompatible with type of column %VSTR.
Explanation: A value provided as a default for a non- nullable column is not compatible with the data type declared for
the field.
Generated By: OPT modules.
For Whom: End User.
Remedy: Change the default value to the correct form.

3631 Column %VSTR is an index column and cannot be modified.
Explanation: An index column cannot be modified by a ALTER TABLE statement unless the modification does not
change the type of the data or nullability.
Generated By: OPT modules.
For Whom: End User.
Remedy: If the column needs to be modified, drop the index containing that column with the DROP INDEX statement.
The index may be created again after the modification.

3632 Compressed value incompatible with type of column %VSTR.
Explanation: A compressed value in a column is not compatible with the type declared for the column.
Generated By: OPT modules.
For Whom: End User.
Remedy: Change the Compress value to the correct form.

3633 COMPRESS declaration allowed only in CREATE/ALTER TABLE.
Explanation: A COMPRESS declaration has been made in some context other than CREATE TABLE or ALTER TABLE.
Generated By: OPT modules.
For Whom: End User.
Remedy: The COMPRESS option can be used only in CREATE TABLE and ALTER TABLE statements.

3634 Compressed values illegal for variable length column %VSTR.
Explanation: COMPRESS has been declared for a column of type VARCHAR(n), VARBYTE(n), or VARGRAPHIC(n).
COMPRESS does not apply to variable length columns.
Generated By: OPT modules.
For Whom: End User.
Remedy: Remove the Compress option or change the column type.

3635 Data Parcel too long in field mode response.
Explanation: A data parcel exceeds the maximum size for field mode responses. Note that field mode responses convert
VARCHAR data to fixed lengths. Many responses that fit in record mode will not fit in field mode.
Generated By: OPT modules.
For Whom: End User.
Remedy: If field mode is required, modify the request to ensure a smaller field or fields.

3636 Column %VSTR longer than permitted for COMPRESS.
Explanation: A CHAR, BYTES, or GRAPHIC column has a length of over 255 characters, which is the maximum length
for compressed columns.
Generated By: OPT modules.
For Whom: End User.
Remedy: Change the column length or remove COMPRESS.

3637 Invalid ORDER BY constant.
Explanation: An ORDER BY constant does not represent the position of a selected expression, or the selected expression
represented is itself a constant.
Generated By: RES and OPT modules.
For Whom: End User.
Remedy: Change ORDER BY phrase.

3638 Invalid PasswordMinChar/PasswordMaxChar value in SysSecDefaults table.
Explanation: The PasswordMaxChar value must be equal to or greater than the PasswordMinChar value.
For extended object names (EnableEON = true and Namevalidationrule is not equal to 1 in DBSControl): The Password-
MinChar value must be between, or include, 1 and 127.
The PasswordMaxChar value must be between, or include, 1 and 127.
The following default values are in use: PasswordMinChar is set to 1 and PasswordMaxChar is set to 127.
For non-extended object names (EnableEON = false, or EnableEON = true and Namevalidationrule equal to 1 in
DBSControl): The PasswordMinChar value must be between, or include, 1 and 30.
The PasswordMaxChar value must be between, or include, 1 and 30.
The following default values are in use: PasswordMinChar is set to 1 and PasswordMaxChar is set to 30.
Generated By: MgcSecOp.
For Whom: Site Administrator.
Remedy: Correct

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