Teradata Database Message 7802 - 7802 - Analytics Database - Teradata Vantage

Message

Call to %VSTR for UDF/XSP/UDM %DBID.%TVMID ran out of shared memory.

Explanation

A user defined function or external procedure called the specified system "FNC" in protected mode, but the function could not complete because the shared memory provided was not large enough to hold the results of the call.

Generated By

FNC library

For Whom

Site support representative & UDF developer

Notes

The shared memory for the protected mode function is usually enough for most situations that might be encountered. If the was encountered in a table function the remedy would be to decrease the size of the "scratch pad" memory that is allocated. By itself allocating the maximum "scratch pad" would not be enough to cause the memory shortage. However if the function uses input and result arguments to the maximum limits and writes to a trace table to the maximum limits or executes a FNC function that returns a lot of variable data to the maximum limits, there is the slight chance that the free memory in the shared memory segment could run out.

Remedy

Redesign the UDF to use less shared memory at the same time.