Unexposed properties cannot be selected for classes mapped to external tables
Created view in DB by joining three different tables, now report definition throwing "Unexposed properties cannot be selected for classes mapped to external tables" error . Properties using in report definition are available in view table.
No issues when we joined two tables initially, later we joined one more table to the view, now we are getting this issue. Can I please get to know what are the scenarios causing this issue and resolution available? Please let me know if would provide more information when required.
***Updated by moderator: Lochan to update platform capability***
Accepted Solution
CPFB
SG
Issue is resolved now, issue is with the query.
CPFB
SG
There is issue with view query, now the issue is resolved. Though the properties added in view, still the system forming query as blob (PegaDATA.pr_read_from_stream). Properties were there in view table, can someone help why it is forming query like this?
Pegasystems Inc.
US
Try to resave the class or db table rule for the view that was updated. Could be you just need to do something to make the engine look at the table maping again so it knows that the column is now there.
CPFB
SG
Tried Saving class and DB Table, still facing the same issue. Facing issue in two environments and one environment is fine. Working environment DB is Oracle and issue facing environment DB is SQL.
Coforge Technologies (Erstwhile Incessant Technologies)
GB
DB table resave should resolve the issue.
CollabPartnerz
IN
Below link might help you
https://collaborate.pega.com/question/error-occured-during-resolving-report-definition-null