How to install User Defined Functions (UDFs)
SummaryUser Defined Function (UDF) installation was bypassed during the installation process. How to install the UDFs manually?
ResolutionUse 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.)
- Confirm if setupDatabase.properties are set properly (database connection URL, username, password, and schema names(s)). The properties' file is in /scripts directory.
- 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