Teradata SQL Error and Failure Codes from Error 5727 To 5734

SQLServerF1_Header_Small

5727 Missing the last range end.
Explanation: For a RANGE_N function or an ALTER TABLE, the last range must specify a range end preceded by the
keyword AND. **DR62813-bessc**
Generated By: RES modules.
For Whom: End User. **DR62813-bessc**
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the
RANGE_N function rules and resubmit the request.

5728 Partitioning violation for table %DBID.%TVMID.
Explanation: 1) An insert or update occurred to a table whose primary index partitioning definition does not allow that
data. Or, 2) an ALTER TABLE statement attempted to alter the primary index partitioning but there are existing rows that
are not allowed by the new partitioning expression and a WITH DELETE/INSERT clause was not specified.
For rows of a table with a single-level, 2-byte partitioned primary index, there is an implied check constraint of
“(CAST((partitioning expression ) AS INTEGER) ) BETWEEN 1 AND max” where max is 65535 or smaller. The CAST is not
included if the partitioning expression is already INTEGER or consists solely of a RANGE_N function. A smaller value for
max is used when the partitioning expression consists solely of a RANGE_N or CASE_N function; in that case, max is the
number of ranges/partitions defined by the function. Note that if the partitioning expression results in NULL, the constraint
is violated.
For rows of a table with a multilevel or 8-byte partitioned primary index, there is an implied check constraint of
“partitioning_expression_1 IS NOT NULL [AND partitioning_expression_n IS NOT NULL]…”.
A row that violates this constraint is not allowed to occur in the table and, therefore, cannot be inserted into the table or, for
an update, replace a row in the table. Additionally, if an existing row violates a new partitioning expression and a WITH
DELETE/INSERT clause is not specified for the ALTER TABLE statement, the new partitioning cannot be applied.
%TVMID indicates the table with the partitioning constraint violation. %DBID indicates the database containing the table.
**DR62813-bessc**
Generated By: STP modules.
For Whom: End User.
Remedy: For 1), correct the values of the columns referenced in the partitioning expressions and resubmit the request.
For 2), alter the table with a new partitioning expressions that allows for all existing rows or use a WITH DELETE/INSERT
clause.

5729 The table is not row partitioned.
Explanation: For an ALTER TABLE statement with the REVALIDATE PRIMARY INDEX clause, the specified table must
have a partitioned primary index. This clause is not valid for a nonpartitioned primary index.
Generated By: RES modules.
For Whom: End User. **DR62813-bessc**
Remedy: Examine the SQL statement and verify that the request is correct. Either submit another request or change the
statement to reference a table that does have a partitioned primary index and resubmit the request.

5730 Invalid DROP RANGE WHERE partition condition for level %VSTR.
Explanation: For an ALTER TABLE statement with a DROP RANGE[#Ln] WHERE clause and a single-level partitioned
primary index, a partition conditional expression must be a conditional expression that references the system-derived column
PARTITION or PARTITION#L1 (but not both) and no other columns. If the table includes an explicit column named
PARTITION, PARTITION may not be used in the conditional expression. If the table includes an explicit column named
PARTITION#L1, PARTITION#L1 may not be used in the conditional expression. If the table includes explicit columns
named PARTITION and PARTITION#L1, this WHERE form may not be specified.For a multi-level partitioned primary index, a partition conditional expression must be a conditional expression that references
the system-derived column PARTITION#Ln where n is the default or specified level of the corresponding DROP
RANGE[#Ln] and no other columns. If the table includes an explicit column named PARTITION#Ln, this WHERE form
may not be used. Note that the system-derived column PARTITION may not be used in the conditional ex-pression.
Generated By: RES modules.
For Whom: End User. **DR62813-bessc**
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the partitioned
primary index rules and resubmit the request.

5731 DROP RANGE and ADD RANGE for level %VSTR are not allowed; partitioning expression, if any, at that level is not a RANGE_N function or involves comparison of character or graphic data.
Explanation: For an ALTER TABLE statement, DROP RANGE[#Ln] and ADD RANGE[#Ln] clauses are only allowed if
the table is partitioned solely with a RANGE_N partitioning expression at the level being altered and:
i. Does not involve comparision of character or graphic data. or ii. Involves only special partitions (e.g. NO RANGE,
UNKNOWN, NO RANGE OR UNKNOWN).
Generated By: RES modules.
For Whom: End User.
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the partitioned
primary index rules and resubmit the request.

5733 DROP RANGE specifies no existing range, part of an existing range, or a nonexisting NO RANGE, NO RANGE OR UNKNOWN, or UNKNOWN partition.
Explanation: For an ALTER TABLE statement, an existing range cannot be partially specified by DROP RANGE. That is,
existing ranges must be entirely within the dropped ranges or entirely outside the dropped ranges. Also, at least one existing
range must be dropped if ranges are specified to be dropped. If the NO RANGE, NO RANGE OR UNKNOWN, or
UNKNOWN partition is specified to be dropped, it must exist.
Generated By: RES modules.
For Whom: End User. **DR62813-bessc**
Remedy: Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the partitioned
primary index rules and resubmit the request.

5734 ADD RANGE for level %VSTR overlaps existing ranges or partitions.
Explanation: For an ALTER TABLE statement after applying DROP RANGE[#Ln] and expansion of ranges with EACH
clauses, the ranges specified by ADD RANGE[#Ln] must not overlap existing ranges and added partitions must not conflict
with or be the same as existing partitions. For example, an UNKNOWN partition may not be added if NO RANGE OR
UNKNOWN partition or an UNKNOWN partition is already in the partitioning expression for the table.
Generated By: RES modules.
For Whom: End User. **DR62813-bessc**
Remedy: Examine the SQL statement and verify that th

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