Teradata SQL Error and Failure Codes from Error 3948 To 3964

3948 Internal error: improper column length detected while building Ynet key.
Explanation: While building the Ynet key, a column whose length must be even was detected to have a non-even length.
Generated By: Optimize. <<-DR39140-cnb-01
For Whom: System Support Representative.
Notes: This is not a user error.
Remedy: Save all relevant information and the dump, and contact your support representative.

3949 Concatenation between GRAPHIC data and numeric or date data is illegal.
Explanation: The user tried to concatenate a GRAPHIC data type with a non-GRAPHIC data type.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the statement and resubmit the request.

3950 Improper parameter to Vargraphic function.
Explanation: This error occurs if the parameter to the VarGraphic function is other than character data type.
Generated By: Anywhere in the system.
For Whom: End User.
Notes: This function may be used only with a Kanji DBS using a KanjiEBCDIC character set.
Remedy: Correct the SQL statement and resubmit.

3952 VarGraphic not permitted with current session character set.
Explanation: This error occurs if the DBS is not in the Kanji mode or the current session character set is anything other
than KanjiEBCDIC.
Generated By: Anywhere in the system.
For Whom: End User.
Remedy: Correct the SQL statement and resubmit.

3953 GRAPHIC data cannot be assigned to column %VSTR.
Explanation: GRAPHIC data cannot be assigned to a column of type other than GRAPHIC. User has probably referenced
wrong column.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the SQL statement and resubmit.

3954 Non-GRAPHIC data cannot be assigned to column %VSTR.
Explanation: Non-GRAPHIC data cannot be assigned to a column of type GRAPHIC. User has probably referenced
wrong column.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the SQL statement and resubmit.

3959 Comparing GRAPHIC data with numeric or date data is illegal.
Explanation: GRAPHIC data may only be compared with other character data.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the request and resubmit the request.

3960 Comparing GRAPHIC data in column %VSTR with numeric or date data is illegal.
Explanation: GRAPHIC data may only be compared with other character data.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the request and resubmit the request.

3961 Numeric operation on GRAPHIC data is illegal.
Explanation: GRAPHIC data cannot be used in most numeric operations.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the request and resubmit the request.

3962 Numeric operation on GRAPHIC data in column %VSTR is illegal.
Explanation: GRAPHIC data cannot be used in most numeric operations.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the request and resubmit the request.

3963 Bad argument type to Char2hexint function.
Explanation: The argument to char2hexint function was not of CHAR type.
Generated By: Parser
For Whom: End User.
Remedy: Correct the request and resubmit the request.

3964 The session character set is invalid.
Explanation: The session character set is invalid or it has not been installed.
Generated By: SQL modules
For Whom: End User.
Remedy: Install the character set or correct the name of the character set.

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