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 ipaddressncabaret - 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 IPAddressncabaret - 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 June 7, 2017 - Updated July 31, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.