Support Article

How to install User Defined Functions (UDFs)

SA-15921

Summary



User Defined Function (UDF) installation was bypassed during the installation process. How to install the UDFs manually?

Resolution



Use generateudf.bat/generateudf.sh script to install (or re-install) the UDFs in the installation media or scripts directory.

Ensure that the following functions are not partially installed before it. The steps given below are for a fresh installation of the UDFs:

DROP FUNCTION YOURSCHEMA.pr_read_from_stream;
DROP FUNCTION YOURSCHEMA.pr_read_decimal_from_stream;
DROP FUNCTION YOURSCHEMA.pr_read_int_from_stream;

(If the system is a split schema, run the following against data schema and rules schema. If the functions are not present, proceed with step 1.)

  1. Confirm if setupDatabase.properties are set properly (database connection URL, username, password, and schema names(s)). The properties' file is in /scripts directory.
  2. Run the generateudf.bat (or .sh, as appropriate) with the flags --action install --dbType YourDatabaseType. For example, when running the script on Windows machine against an Oracle database this would be:
C:\PegaInstallationMedia\scripts> generateudf.bat --action install --dbType oracledate

Published November 28, 2016 - Updated October 8, 2020


50% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.