Issue with UDFs after upgrade to Pega 8.7.3
Hi,
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? Regards, Bharat
***Edited by Moderator Marije to change type from Product to Update; added capability tags***
Accepted Solution
Updated: 23 Dec 2022 9:53 EST
NCS Pte. Ltd
SG
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.
Thanks.
Accenture
GB
@ArulDevan Hi, I have a mapping in Class Definition, example
Pega Property .ABC
Class Mapping XYZ_1 = .ABC
Report Definition uses .ABC within Filter criteria
In Pega 7.3.1, SQL is formed with XYZ_1, where as in Pega 8.7.3, i see it is trying to look for .ABC, and then trying to invoke pr_read_from_stream.
Any thoughts?
Regards,
Bharat
Accenture
GB
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.
Regards,
Bharat