Question
Ucare
Ucare
US
Ucare
Posted: Sep 25, 2018
Last activity: Oct 1, 2018
Last activity: 1 Oct 2018 9:47 EDT
Closed
Unexposed properties - CommPreferenceByMail
Hi, This proeprty is throwing error in our log files and its OOTB and its exposed part of OOTB.
We tried to re-save table still it dindot work.Did anyone get this issue and resolved it, Please help us how how did you resolve.
2018-09-25 13:20:20,916 [ttp-apr-8080-exec-27] [TABTHREAD2] [ ] [ XXX:02.01.03] ( rd.resolve.SqlReportResolver) ERROR XXXXXX XXXX - An error occured during resolving the report definition - InvalidReferenceException .CommPreferenceByMail Unexposed properties cannot be selected for classes mapped to external tables
com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceException .CommPreferenceByMail Unexposed properties cannot be selected for classes mapped to external tables at com.pega.pegarules.data.internal.rd.utils.ValidationUtils.throwInvalidReferenceException(ValidationUtils.java:523) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.reference.StreamPropertyReferenceResolver.isValidClassForReference(StreamPropertyReferenceResolver.java:209) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.reference.StreamPropertyReferenceResolver.resolve(StreamPropertyReferenceResolver.java:104) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.reference.GenericPropertyReferenceResolver.resolve(GenericPropertyReferenceResolver.java:150) ~[prprivate.jar:
Show More
Hi, This proeprty is throwing error in our log files and its OOTB and its exposed part of OOTB.
We tried to re-save table still it dindot work.Did anyone get this issue and resolved it, Please help us how how did you resolve.
2018-09-25 13:20:20,916 [ttp-apr-8080-exec-27] [TABTHREAD2] [ ] [ XXX:02.01.03] ( rd.resolve.SqlReportResolver) ERROR XXXXXX XXXX - An error occured during resolving the report definition - InvalidReferenceException .CommPreferenceByMail Unexposed properties cannot be selected for classes mapped to external tables
com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceException .CommPreferenceByMail Unexposed properties cannot be selected for classes mapped to external tables at com.pega.pegarules.data.internal.rd.utils.ValidationUtils.throwInvalidReferenceException(ValidationUtils.java:523) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.reference.StreamPropertyReferenceResolver.isValidClassForReference(StreamPropertyReferenceResolver.java:209) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.reference.StreamPropertyReferenceResolver.resolve(StreamPropertyReferenceResolver.java:104) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.reference.GenericPropertyReferenceResolver.resolve(GenericPropertyReferenceResolver.java:150) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveField(AbstractFieldResolver.java:92) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveFields(AbstractFieldResolver.java:63) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveFields(AbstractFieldResolver.java:55) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.resolve.ListResolver.resolve(ListResolver.java:58) ~[prprivate.jar:?]at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:62) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:37) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.SQLExecutorResultsCP.resolve(SQLExecutorResultsCP.java:67) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainReport(SqlReportExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:83) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:54) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1460) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:11111) ~[prprivate.jar:?] at com.pegarules.generated.definition.ra_action_cpmgetcontactinfo_b7b2569281a7cfa93ea9fc803bc24da0.perform(ra_action_cpmgetcontactinfo_b7b2569281a7cfa93ea9fc803bc24da0.java:52)~[?:?]
Show Less
Posted: 6 years ago
PEGA
Pegasystems Inc.
IN
Hi Kavitha,
After re-saving the Table, Open report definition class to do test connection and save it. please refer to the below article for reference:
Posted: 6 years ago
CollabPartnerz
CollabPartnerz
IN
Below link might help you
https://collaborate.pega.com/question/pega-51-data-properties-pseudo-logic-mimic-udf-function
Posted: 6 years ago
Ucare
Ucare
US
I re-validated the property and re-saved the table instance.But the class is locked and we tried from DB end asking the DBA to rebuild the table.Nothing worked.