Teradata SQL Error and Failure Codes from Error 9838 To 9847

SQLServerF1_Header_Small

9838 The query ValidTime period specification requires a table with ValidTime period.
Explanation: If query ValidTime period specification is specified in the query then the table reference in the query must
be a ValidTime table.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the query ValidTime period specification and resubmit.

9839 The column name specified in the FOR PORTION OF must be a ValidTime column defined using derived period.
Explanation: If FOR PORTION OF is specified in the update or delete operation, then the ValidTime column name specified
in the FOR PORTION OF must be a column defined using derived period.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the FOR PORTION OF from the request and resubmit.

9840 Invalid expression with FOR PORTION OF specification.
Explanation: If FOR PORTION OF is specified in the update or delete operation, then there must not be any column reference
in the DateTime expression of FOR PORTION OF.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the column reference form the DateTime expression of the FOR PORTION OF and resubmit.

9841 Start or end column of a system-time period reference in SET clause is invalid.
Explanation: If FOR PORTION OF is specified in the update operation and the table contains a system-time period definition,
then the SYSTEM_TIME period start column or the SYSTEM_TIME period end column must not be pecified in the
SET clause.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the system-time start or end column from the SET clause and resubmit.

9842 The DateTime expression specified in FOR PORTION OF must be comparable to the data type of the start column of the ValidTime period.
Explanation: If FOR PORTION OF is specified in the update or delete operation then the data type of the DateTime
expression in the FOR PORTION OF must be comparable with the data type of the start column of the ValidTime period.
Generated By: RES modules.
For Whom: The end user.
Remedy: Rewrite the DateTime expression such that it results into comparable data type of the start column of the Valid-
Time period and resubmit.
9843 Query resulting in mixing of ANSI temporal syntax and Teradata temporal syntax is not allowed.
Explanation: Mix of ANSI temporal syntax with Teradata temporal syntax is not allowed.
Generated By: RES modules.
For Whom: The end user.
Remedy: Rewrite the query using either only ANSI temporal syntax or existing temporal syntax and resubmit.

9844 The source table cannot be a system-versioned table in a CREATE TABLE AS statement.
Explanation: The source table must not be a system-versioned table during CREATE TABLE AS operation.
Generated By: RES modules.
For Whom: The end user.
Remedy: Replace the source table reference with non system-versioned table and resubmit.

9845 System-time period start or end column cannot be referenced in the triggered action statement.
Explanation: The SYSTEM_TIME period start or end column must not be referenced in the triggered action statement.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the start or end column of the SYSTEM_TIME period from the triggered action statement and resubmit.

9846 Start or end column of a ValidTime period cannot be referenced in the triggered action statement of the before trigger.
Explanation: The ValidTime period start or end column must not be referenced in the triggered action statement of a
before trigger.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the start or end column of the ValidTime period from the triggered action statement of the before trigger
and resubmit.

9847 Nontemporal operations are not allowed on a system-versioned table.
Explanation: Any nontemporal operation such as alter table, CREATE TABLE.AS, insert and update are not allowed on
a system-versioned table.
Generated By: RES modules.
For Whom: The end user.
Remedy: Remove the GENERATED ALWAYS AS ROW START or GENERATED ALWAYS AS ROW END specification
and resubmit.

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