Question

Issues with Report Defintion after upgrade from Pega 7.3.0 to Pega 8.2.4

Hi,

after the upgrade from Pega 7.3.0 to Pega 8.2.4, our report definitions with class joins are returning empty results when the option "Report on descendant class instances" is set to "Include all descendant classes". But if we change this to "Include Implementation class only" it works.

I want to understand why it is behaving like this? Why is the behavior different in Pega 8?

Regards,

Herve

Correct Answer
October 6, 2019 - 8:16pm

Please check below pnd link:

https://community.pega.com/sites/default/files/help_v83/procomhelpmain.htm#rule-/rule-obj-/rule-obj-report-/rule-obj-report-definition/dataaccess.htm

"Include all descendant classes" applies to the Applies to Class. It does not apply to Join classes.

If descendant classes are in multiple class tables, the query may fail if the referenced properties are not optimized.

 

Comments

Keep up to date on this post and subscribe to comments

October 6, 2019 - 5:58am

Can you check the query being fired by the RD in both cases using tracer.

Check if it is querying from the correct table or not. If the query is correct then run the same query in the DB directly and see if you are getting the result or not.

Also are the properties exposed or not?

 

Pega
October 6, 2019 - 8:16pm

Please check below pnd link:

https://community.pega.com/sites/default/files/help_v83/procomhelpmain.htm#rule-/rule-obj-/rule-obj-report-/rule-obj-report-definition/dataaccess.htm

"Include all descendant classes" applies to the Applies to Class. It does not apply to Join classes.

If descendant classes are in multiple class tables, the query may fail if the referenced properties are not optimized.