Unexposed properties cannot be selected for classes mapped to external tables error coming in RD.
While running a report definition, I am getting an error- Unexposed properties cannot be selected for classes mapped to external tables. The columns are optimized and are present in the database.
Under Data Access tab, when I uncheck the option- Report on descendant class instances, the error goes away. (taken from- https://support.pega.com/question/error-occured-during-resolving-report-definition-invalidreferenceexception-propertyname)
Can someone please explain what exactly does this option mean and how would it impact the report.
There is no descendant class to the class of the report definition.
Accepted Solution
Updated: 14 Apr 2023 7:00 EDT
NCS Pte. Ltd
SG
Hi @soodn: This helps when you have framework and implementation. Details of this option as below.
If there is any implementation class in the application rule set list, check this checkbox to have the report build its query using the implementation class mapping. This feature eliminates the need to copy each framework class-based Report Definition into the implementation class.
This is extended behavior from versions previous to 7.1. If you want the report to be based on the parent framework class, make sure this checkbox is unchecked.
A quick try having a application with Framework and implementation layer and creating the report in framework layer will help to understand this better.
Thanks.
Pegasystems Inc.
IN
@ArulDevan Hi, Thank you for your reply, the report is created in an implementation layer class where the columns are present and there is no further implementation layer to it. If the checkbox is checked, then also it is giving the error. Any idea, what could be the issue?
NCS Pte. Ltd
SG
Hi @soodn: Can you please try to get the SQL from tracer and try running the same in DB? This will help to understand if any issues in SQL. If the SQL is running fine in DB, then I suggest to save the class and DB table instance.
Thanks.