Teradata Database Message 7802 - 7802 - Analytics Database - Teradata Vantage
Teradata® VantageCloud Lake - Analytics Database Messages
- Edition
- Lake
- Product
- Analytics Database
- Teradata Vantage
- Published
- October 2022
- Language
- English (United States)
- Last Update
- 2024-02-26
- dita:mapPath
- tzr1629746512312.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- vza1585613049811
- lifecycle
- latest
- Product Category
- 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.