Teradata SQL Error and Failure Codes from Error 9828 To 9837

9828 Explicit temporal qualifier must not be specified along with without overlap specification.
Explanation: The unique or primary key constraint definition must not include explicit temporal qualifiers along with
<without overlaps specification>.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the explicit temporal qualifier from the unique or primary key constraint definition and resubmit.

9829 Start or end column of a system-time period are not allowed in referencing or referenced
column list.
Explanation: The start or end column of a system-time period must not be included in the referencing or referenced column
list of a referential integrity constraint.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove start or end column of the system-time period from the referencing or referenced column list and
resubmit.

9830 The column name specified in referencing or referenced period specification must be of a
ValidTime column defined using derived period.
Explanation: If the referential integrity constraint is defined with referencing and referenced period specification, then
the ValidTime column name specified in the referencing and referenced period specification must be of a column defined
with derived period definition.
Generated By: RES modules.
For Whom: The end user.
Remedy: Define the ValidTime column with derived period definition and resubmit.

9831 Start or end column of a system-time period is not allowed in a check constraint.
Explanation: The start or end column of a system-time period must not be included in the check constraint.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove start or end column of the system-time period from the check constraint and resubmit.

9832 Specified alter table operation is not supported on a system-versioned table.
Explanation: If a table is a system-versioned table then add or drop column, add DEFAULT clause, add NULL or NOT
NULL, change column data type, drop identity column attribute, modify partition WITH DELETE or WITH INSERT,
ALTER TABLE TO CURRENT with WITH DELETE or WITH INSERT, revalidate primary index with WITH DELETE or
WITH INSERT and add NORMALIZATION option are not supported.
Generated By: RES modules.
For Whom: The end user.
Remedy: Drop system-versioning from the table and then do the required alter operation.

9833 The table is already system-versioned.
Explanation: If the table is already a system-versioned table, then alter table to add system-versioning cannot be done
on the same table.
Generated By: RES modules.
For Whom: The end user.
Remedy: Drop system-versioning and add system-versioning again if required.

9834 The table must be a system-versioned table.
Explanation: In order to do drop system-versioning operation the table must be a system-versioned table.
Generated By: RES modules.
For Whom: The end user.
Remedy: Add system-versioning and drop system-versioning again if required.

9835 %VSTR requires a system-versioned table or a transactiontime table.
Explanation: If query system-time period specification or query TransactionTime period specification is specified in the
query then the table reference in the query must be a system-versioned table or a transactiontime table.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the query system-time period specification and resubmit.

9836 Invalid expression with %VSTR specification.
Explanation: The query system-time period specification must not include a column reference in the DateTime expression.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the column reference form the DateTime expression of the query system-time period specification and
resubmit.

9837 The column name specified with without delete option must be of a ValidTime column or
TransactionTime column.
Explanation: The column name specified in the alter table drop column, without delete option must be of a ValidTime
column or TransactionTime column.
Generated By: RES modules.
For Whom: The end user.
Remedy: Replace the column reference in alter table drop column, without delete option with ValidTime column or
TransactionTime column and resubmit.

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