Resolving UDF Server Setup Errors | Java External Stored Procedures | Vantage - Resolving UDF Server Setup Errors - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

When an external routine like an UDF, UDM, or external stored procedure is called, a UDF server process is acquired from the UDF server pool to execute the external routine. If there are no UDF server processes in the pool or if all of the processes in the pool are busy, then the system tries to start a new UDF server process for the request.

The startup of the new UDF server usually takes some time, especially if the UDF server is for executing Java external routines, or if the system is very busy. If the new UDF server cannot be started within the default time limit, the query that contains the UDF, UDM, or external procedure call is aborted, and you may receive a 7583 error indicating that the UDF server setup encountered a problem. The system log may also record a 7820 error specifying that the UDF server could not stay up long enough for initialization.

If you are experiencing these errors, you can contact Teradata Support Center personnel to adjust the time limit allowed for starting a new UDF server process. For more information, see “Cufconfig Utility” in Teradata Vantage™ - Database Utilities , B035-1102 .