Question
Ericsson
IN
Last activity: 15 Sep 2015 8:16 EDT
When I click on a report Definition Chart, I get the following error
Erro** ** InvalidReferenceException .pyLabel Unexposed properties cannot be selected for classes mapped to external tables ** InvalidReferenceException .pyLabel Unexposed properties cannot be selected for classes mapped to external tables Error: ** ** InvalidReferenceException .pyLabel Unexposed properties cannot be selected for classes mapped to external tables ** InvalidReferenceException .pyLabel Unexposed properties cannot be selected for classes mapped to external tables ** ** InvalidReferenceException .pyLabel Unexposed properties cannot be selected for classes mapped to external tables ** InvalidReferenceException .pyLabel Unexposed properties cannot be selected for classes mapped to external tables
Please refer to the attached Screenshot.
I have created a view and corresponding Class and Data Table.
Pegasystems
IN
So this exception is happening when you are clicking on the chart or data to drill down further. The drill down report configured on the report definition must be referencing properties which are not exposed as specific columns in the database table and since external tables don't have the stream (BLOB) column pzPVStream, they are failing with an exception.
You might want to refer to the drill down report configured in your report to see what columns are configured and either
1) Override the report for your class to show only those columns that the exposed in the table mapped to your class
OR
2) Create a new report to show information based on your class and replace the drill down report name in the main report
Note that both of the above required designer studio access.