SA-39943

Summary

Administrators have configured the 'setupDatabase.properties' file with the 'bypass.pega.schema' property set to "false" in order to re-generate UDFs during an upgrade. However, this is causing an issue because the rule schema is no longer be owned by the deployment user; instead it is owned by the application administrator user (which has fewer priveliges). Running the upgrade will recreate the schema, and thus requiring the transfer of schema ownership back to the administrator user later.

Error Messages

Not Applicable

Steps to Reproduce

Run an upgrade with the 'bypass.pega.schema' property set to "false" in order to re-generate UDFs.

Root Cause

UDF generation can be completed without modifying the schema ownership or privileges by using the separate script in the /scripts/ subdirectory of the installation media: generateudf.sh (or .bat)

This utilizes the database information in setupdatabase.properties to generate, compile, and grant access to the User-defined Functions (UDFs.)

Resolution

Utilize the generateUDF script to re-generate the UDFs instead of running a complete upgrade.