Teradata SQL Error and Failure Codes from Error 9337 To 9351

SQLServerF1_Header_Small

9337 ValidTime column must be defined as NOT NULL for the specified primary key.
Explanation: A current or sequenced UNIQUE/PRIMARY KEY is defined for a ValidTime table and the ValidTime column
is nullable. The constraint uses the ValidTime column and hence must be defined as NOT NULL.
Generated By: SYN and RES Modules.
For Whom: End User.
Remedy: Make ValidTime column as NOT NULL.

9338 Secondary indexes cannot be created on a system-defined join index.
Explanation: The join index referenced in the CREATE INDEX statement is a system-defined join index. The systemdefined
join index cannot have secondary indexes.
Generated By: RES modules.
For Whom: End User.
Remedy: None.

9340 Nontemporal operations are disabled.
Explanation: A DBSControl record .
Generated By: Par Modules
For Whom: End User.
Remedy: Enable EnabNonTempoOp dbscontrol flag.

9341 NONTEMPORAL privilege is invalid in %VSTR logging statement.
Explanation: A access logging rule cannot be ended for a NONTEMPORAL privilege.It must not be specified in an END
LOGGING statement.
Generated By: RES modules
For Whom: End user
Remedy: The logging for this privilege use cannot be disabled. An option to disable nontemporal operations in the system
is possible using DBSControl record. See the DBSControl reference manual for details. You may need to contact your
system administrator for such option.

9342 Invalid use Of UNTIL_CLOSED.
Explanation: This error occurs only if UNTIL_CLOSED is not used for a TT col.
Generated By: RES modules.
For Whom: System Support Representative.
Remedy: Save all relevant information and the dump, and contact your support representative.

9343 Period of applicability must not reference columns.
Explanation: Period of applicability must not reference columns,
Generated By: RES modules.
For Whom: End User.
Remedy: Remove the column references in PA.

9344 Invalid expression with AS OF clause.
Explanation: An AS OF temporal qualifier must not reference any column. It should contain only constant or parameterized
of USING references.
Generated By: RES modules.
For Whom: End User.
Remedy: Remove the column references from the AS OF clause.

9345 Invalid temporal qualifier is specified.
Explanation: This error can occur in any of the following conditions. (1) An AS OF temporal qualifier is specified in the
statement but there are no temporal tables referenced in the statement. (2) An ABORT or ROLLBACK specifies a NONSEQUENCED
VALIDTIME qualifier with a period of applicability. (3) An UPSERT specifies a NONTEMPORAL qualifier. (4)
When a SSQ is given in the set session. (5) If an EXPLICIT qualifier is specified for any of the sub-selects other than top most for a SetOp query.
Generated By: RES modules.
For Whom: End User.
Remedy: Remove the inappropriate qualifier if it is not applicable.

9347 This form of sequenced operation is not allowed.
Explanation: A Sequenced qualifier specified in the statement and the statement is not a simple single table operation.
For example it is SELECT statement with a GROUP BY clause or a DISTINCT clause.
Generated By: RES modules.
For Whom: End User.
Remedy: Remove the sequenced qualifier and modify the request appropriately and resubmit.

9350 Referenced column in the period of applicability is not part of the select list.
Explanation: A NONSEQUENCED VALIDTIME temporal qualifier with a period of applicability is used in the statement.
The period of applicability is specifying an alias name that is not in the projection list of the statement.
Generated By: RES modules.
For Whom: End user.
Remedy: Fix the alias referenced in the ValidTime qualifier or add the alias to the projection list of the select statement.

9351 Referenced column in the period of applicability is ambiguous.
Explanation: A NONSEQUENCED VALIDTIME temporal qualifier with a period of applicability is used in the statement.
The alias referenced in the period of applicability is ambiguous i.e, the alias is duplicated in the projection list of the select statement.
Generated By: RES modules.
For Whom: End user.
Remedy: Reference a uniquely identifiable alias when used in the ValidTime qualifier.

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