Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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.

Suggest Edit

Published August 1, 2017 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us