Support Article
.Churn_RiskUnexposed properties cannot be selected for classes
SA-39063
Summary
Exception in the logs when opening Interaction driver and the information of the contact does not appear too with Pega Customer Service 7.22.
Error Messages
2017-04-29 10:30:05,223 [http-nio-8080-exec-1] [ STANDARD] [ ] [ ETNA:01.01] (pages.DeclarativePageUtilsImpl) WARN ipaddress ncabaret - Required parameter'InteractionId' for data page 'D_Interaction' cannot be blank.
2017-04-29 10:30:42,142 [http-nio-8080-exec-1] [TABTHREAD1] [ ] [ ETNA:01.01] ( rd.resolve.SqlReportResolver) ERROR IPAddress ncabaret - An error occured during resolving the report definition - InvalidReferenceException .Churn_Risk Unexposed properties cannot be selected for classes mapped to external tables
com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceException .Churn_Risk Unexposed properties cannot be selected for classes mapped to external tables
at com.pega.pegarules.data.internal.rd.utils.ValidationUtils.throwInvalidReferenceException(ValidationUtils.java:521)
at com.pega.pegarules.data.internal.rd.reference.StreamPropertyReferenceResolver.isValidClassForReference(StreamPropertyReferenceResolver.java:207)
at com.pega.pegarules.data.internal.rd.reference.StreamPropertyReferenceResolver.resolve(StreamPropertyReferenceResolver.java:102)
at com.pega.pegarules.data.internal.rd.reference.GenericPropertyReferenceResolver.resolve(GenericPropertyReferenceResolver.java:149)
at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveField(AbstractFieldResolver.java:88)
at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveFields(AbstractFieldResolver.java:62)
at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveFields(AbstractFieldResolver.java:54)
at com.pega.pegarules.data.internal.rd.resolve.ListResolver.resolve(ListResolver.java:56)
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:62)
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:37)
Steps to Reproduce
Create a inbound call.
Root Cause
Issue is related to case sensitivity with SQL Server. The column in the table has camel case Churn_Risk but the column mapping is all lower case churn_risk.
Resolution
For SQL Server, change the column in the database for pa_contact table to reflect the correct case defined in the column name in the external mapping tab of classes PegaCPMHC-Party-Contact and PegaCA-Interface-Contact.
Published August 1, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.