Greetings. Hope you are well! We have recently upgraded from Pega 7.3.1 to Pega 8.7.3. There is an issue with UDFs in Pega 8.7.3, we do not have UDFs installed in Pega 7.3.1 and a report definition has no issues however the same report definition fails in Pega 8.7.3 with the below error
We are hosted on Amazon RDS (postgresql) and i think PL/Java cannot be installed on rds.
RD has a property within filter criteria that is exposed via Optimize for Reporting but it also has an external mapping in the class. So the property in Pega is ABC, whereas in Database table it is something like xyz_1.
External Mapping of Class xyz_1 = ABC
Report Definition uses ABC within filter criteria.
Can someone please let me know why this RD is working in Pega 7.3.1 and not in Pega 8.7.3?
***Edited by Moderator Marije to change type from Product to Update; added capability tags***
Hi @KOMARINA: Can you please check if the specific column is available in Database class mapping page. If you have done a external mapping, check the column names between class rule and Database class mapping.
Try to save the Class and DB instance.
Let us know if this helps.
Posted: 1 month ago
Posted: 22 Dec 2022 4:56 EST
Srinivas Bharat Komarina (KOMARINA)
Senior System Architect
Thank you @ArulDevan , When i last tried i only resaved the DB instance of Framework class, the RD has Report on descendent class instances enabled and i did not notice the Implementation class, after resaving this associated DB table, UDF is no longer being invoked but honoring the mapping from External Mapping of the class definition.