Post upgrade to Pega8.8.1 we are facing user-defined functions (UDF) Issue
We have upgraded our application from Pega 8.3 to 8.8.1
Below is the Error Details
An error occured on executing the query for the report definition - There was a problem getting a list: code: 4045 SQLState: 42000 Message: ORA-04045: errors during recompilation/revalidation of .PR_READ_FROM_STREAM ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-04045: errors during recompilation/revalidation of .PR_READ_FROM_STREAM ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated | SQL Code: 4045 | SQL State: 42000
Following are the queries
1. Is UDF deprecated?
2. Is it recommended to enable the UDF ?
Accepted Solution
Updated: 14 Mar 2023 11:12 EDT
NCS Pte. Ltd
SG
Hi @Anushree: Please find the below recommendation for UDF.
" Beginning in Pega Platform version 8.6, Pega deprecated usage of the Java user-defined functions (UDFs) due to their severe performance impact. In a future release of Pega Platform, Pega will no longer support Java UDFs for on-premises deployments. Pega Platform deployments do not require Java UDFs and in most cases, Pega does NOT recommend the installation of Java UDFs."
If this is a upgrade and your existing codes are using these UDF (getting data from blob in reports), then the suggested way forward would be fixing those so that future upgrades will be smooth.
If you still want to continue with usage of UDF's then you are still allowed to. Please follow installation doc Manually installing or re-installing Java UDFs.
If you are still facing the issue after reinstalling UDF, please check with DBA because i could see some similar DB related issues discussed here
Thanks.
TSPi
IN
HI @Anushree,
Yes, Pega is not recommending UDF.
If you want to use UDF. follow the steps after upgrade.
1) in the Scripts folder we have generateudf.bat file.
in the command prompt use the below command
C: ...\..\ scripts>generateudf.bat --action install
Carelon Global Solutions
IN
Thank you @Satish Sudagoni
Accepted Solution
Updated: 14 Mar 2023 11:12 EDT
NCS Pte. Ltd
SG
Hi @Anushree: Please find the below recommendation for UDF.
" Beginning in Pega Platform version 8.6, Pega deprecated usage of the Java user-defined functions (UDFs) due to their severe performance impact. In a future release of Pega Platform, Pega will no longer support Java UDFs for on-premises deployments. Pega Platform deployments do not require Java UDFs and in most cases, Pega does NOT recommend the installation of Java UDFs."
If this is a upgrade and your existing codes are using these UDF (getting data from blob in reports), then the suggested way forward would be fixing those so that future upgrades will be smooth.
If you still want to continue with usage of UDF's then you are still allowed to. Please follow installation doc Manually installing or re-installing Java UDFs.
If you are still facing the issue after reinstalling UDF, please check with DBA because i could see some similar DB related issues discussed here
Thanks.
Carelon Global Solutions
IN
Thank you @ArulDevan