15.00 - 7802 Call to %VSTR for UDF/XSP/UDM %DBID.%TVMID ran out of shared memory. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

7802 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.