Posted: 7 Jun 2018 3:04 EDT Last activity: 10 Sep 2018 8:42 EDT
Getting SQL Report Resolver Error for Extenal Tables
We are getting Frequent Sql Report Resolver Error for some property for the External Tables, however the following property are been already present in the external tables.
We are using SQLServer 2017 and on PEGA 731 Instance at our end,
(rd.resolve.SqlReportResolver) ERROR - An error occured during resolving the report definition - InvalidReferenceException<PropertyName> Unexposed properties cannot be selected for classes mapped to external tables
com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceException.CentreNameUnexposed properties cannot be selected for classes mapped to external tables
at com.pega.pegarules.data.internal.rd.utils.ValidationUtils.throwInvalidReferenceException(ValidationUtils.java:520) ~[prprivate.jar:?]
SQL Query : select pzPVStream from pegarules.pr4_base where pyDatabaseName = ? and pyTableName = ? is been used and if I pass the parameter nothing returns back, even I run the following on the SQL Client it doesn't return anything.
I'm not entirely sure why this would be useful in this instance.
Even if you supply the right database and table name, this is only going to return the Data-Admin-DB-Name rule information and the pzPVStream is binary and won't be readable.
If you want to verify if the column has been optimized, you might want to open the associated Property rule, then examine the XML for that rule. If it's optimized I believe it will list the classes that it is optimized for here (probably towards the bottom).