Issue with UDFs after upgrade to Pega 8.7.3

General
, , , , ,
1

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

UDF.jpg
UDF.jpg656×495 88.4 KB

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

2

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.

3

@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

4

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