Generate UDFs without recreating rules schema during upgrade
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.
Steps to Reproduce
Run an upgrade with the 'bypass.pega.schema' property set to "false" in order to re-generate UDFs.
Root CauseUDF 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.)
Utilize the generateUDF script to re-generate the UDFs instead of running a complete upgrade.
0% found this useful