Teradata SQL Error and Failure Codes from Error 7495 To 7506

7495 “%S”.”%S” was skipped due to error %d. Run SCANDISK.
Explanation: This message indicates that the CheckTable utility could not check the table due to data corruption.
Generated By: CheckTable
For Whom: End user or Field Engineer or the concerned site support representative.
Notes: While checking a table, if the CheckTable utility faces some data corruption problems, then the table check is
skipped. The message identifies the error code of the problem that caused the error along with the database name and the
table name.
Remedy: Run SCANDISK after CheckTable utility has completed checking the remaining tables.

7496 CheckTable utility aborted while checking table %04XH %04XH due to unexpected error %d.
Explanation: This message indicates that the CheckTable utility is aborted due to unexpected problems.
Generated By: CheckTable
For Whom: End user or Field Engineer or the concerned site support representative.
Notes: When the CheckTable utility faces some unexpected event, like SEGV, Floating Point Exception, or some illegal
operation, then the utility is aborted. The message identifies the error code of the problem which caused the error along
with the table that was being processed at the time.
Remedy: Restart CheckTable Utility and if the problem persists contact support personnel.

7497 The primary index values in the UPSERT statement hash the same, but are mismatched.
Explanation: The user specified different primary index values for the UPDATE and the INSERT parts of an UPSERT
statement. The values used have the same rowhash, but are not the same. The same primary index values must be used in
both parts of an UPSERT statement.
Generated By: StpUpd
For Whom: End User
Remedy: Correct the UPSERT statement and resubmit.

7498 The primary index values in the UPSERT statement match but other fields do not.
Explanation: The user specified non matching values for fields other than the primary index of an UPSERT statement.
The values used must be the same for both the UPDATE and INSERT parts of an UPSERT statement.
Generated By: StpUpd
For Whom: End User
Remedy: Correct the UPSERT statement and resubmit.

7500 Right truncation of string data for UDF/XSP/UDM %DBID.%TVMID.
Explanation: A UDF/XSP/UDM running in an ANSI mode session cannot pass a string to the function that would
result in the truncation of significant characters. The specified length of the parameter on the create determines the maximum
length string the function will accept.
Generated By: EVL modules.
For Whom: End user or UDF/XSP/UDM developer.
Remedy: Either redesign the UDF/XSP/UDM to accept longer strings or make sure the input string length does not
exceed the maximum string length defined by the UDF/XSP/UDM.

7502 A system trap was caused by UDF/XSP/UDM %DBID.%TVMID for %VSTR
Explanation: The UDF/XSP/UDM caused a system trap for the reason indicated.
Generated By: AMP subsystem.
For Whom: UDF/XSP/UDM Developer.
Notes: The error string will contain the system trap information plus trace back information where possible.
Remedy: The developer of the UDF/XSP/UDM has to look at the UDF/XSP/UDM and fix the bugs.

7503 The UDF server failed to execute UDF/XSP/UDM %DBID.%TVMID
Explanation: The specified UDF/XSP/UDM caused the server task that is used to execute a UDF/XSP/UDM in protected
mode to fail. The error was severe enough to prevent the UDF server from reporting any proper error information
Generated By: AMP subsystem.
For Whom: UDF/XSP/UDM developer.
Remedy: The developer of the UDF/XSP/UDM has to look at the function and fix the bugs. Try bypassing some suspect
code. Try trace output.

7504 in UDF/XSP/UDM %DBID.%TVMID: SQLSTATE %VSTR
Explanation: This is a UDF/XSP/UDM generated error. The meaning depends on the UDF as defined by the developer.
Generated By: AMP subsystem.
For Whom: UDF/XSP/UDM user.
Notes: The variable string will contain the SQLSTATE code followed by an optional text string supplied by the
UDF/XSP/UDM.
Remedy: Look up the documentation for the UDF/XSP/UDM and take the necessary action to use the function in the
correct context.

7505 in UDF/XSP/UDM %DBID.%TVMID: SQLSTATE %VSTR
Explanation: This is a UDF/XSP/UDM generated warning. The meaning depends on the UDF/XSP/UDM as defined
by the developer. Since this is only a warning the request is not terminated.
Generated By: AMP subsystem.
For Whom: UDF/XSP/UDM user.
Notes: The variable string will contain the SQLSTATE code followed by an optional text string supplied by the
UDF/XSP/UDM.
Remedy: Look up the documentation for the UDF/XSP/UDM and take the necessary action to use the function in the
correct context.

7506 The library for UDF/XSP/UDM %DBID.%TVMID could not be found
Explanation: All UDFs/XSPs/UDMs are linked in a dynamic linked library or in a package which must exist on all
nodes on the database system. The library for this UDF/XSP/UDM could not be found on at least one node.
Generated By: AMP subsystem.
For Whom: DBA.
Remedy: If the UDF/XSP/UDM is in a package make sure the package has not been deleted or propagated to all nodes.
If the UDF/XSP/UDM is in a library then it has been deleted on some node. To generate a new library compile the
UDF/XSP/UDM via the ALTER FUNCTION/PROCEDURE statement using the COMPILE option. This create a new
UDF/XSP/UDM library.
If the UDF/XSP/UDM is called or executed in protected mode, make sure on each node the library and all the dependency
libraries exist and were given the correct file permission. Check the system log for error 7820 for more specific information.

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