Post upgrade to Pega8.8.1 we are facing user-defined functions (UDF) Issue

General
, , , , ,
1

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 ?

2

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

3

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.

4

Thank you @Satish Sudagoni

5

Thank you @ArulDevan