Teradata Database Message 7804 - 7804 - Analytics Database - Teradata Vantage

Message

The UDF %DBID.%TVMID called %VSTR in invalid mode/phase.

Explanation

Some functions in the "FNC" library are only available in CONST mode. The UDF listed called the FNC function in VARY mode but it is only supported in CONST mode. Additionally, this error may indicate the function is called in an inproper mode/phase combination. The following functions have restrictions on the mode/phase in which they may be used: FNC_TblControl, FNC_TblAllocCtrlCtx, FNC_TblGetCtrlCtx, FNC_TblOptOut, and FNC_TblFirstParticipant.

Generated By

FNC library

For Whom

UDF developer

Notes

None

Remedy

Redesign the UDF to not call the FNC library in a non supported MODE.