Support Article
InvalidReferenceException .BusinessUnitId Unexposed properties
SA-89785
Summary
On executing the PegaCA-Interface-BusinessUnit.BusinessUnitData report definition, large volumes of InvalidReferenceException is generated in the logs.
Error Messages
[default task-6] [TABTHREAD1] [ ] ( rd.resolve.SqlReportResolver) ERROR - An error occurred during resolving the report definition - InvalidReferenceException .BusinessUnitId Unexposed properties cannot be selected for classes mapped to external tables com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceException .BusinessUnitId Unexposed properties cannot be selected for classes mapped to external tables at com.pega.pegarules.data.internal.rd.utils.ValidationUtils.throwInvalidReferenceException(ValidationUtils.java:469) ~[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:69) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.SQLExecutorResultsCP.resolveQuery(SQLExecutorResultsCP.java:143) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.SqlReportExecutor.resolveQuery(SqlReportExecutor.java:57) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.query.RDBMSExecutor.resolve(RDBMSExecutor.java:69) ~[prprivate.jar:?] at com.pega.platform.query.LogicalQueryExecutions.resolve(LogicalQueryExecutions.java:134) ~[logicaldatastore.jar:?] at com.pega.platform.query.LogicalQueryExecutions.executor(LogicalQueryExecutions.java:95) ~[logicaldatastore.jar:?] at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1512) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:11060) ~[prprivate.jar:?] at com.pegarules.generated.definition.ra_action_businessunitdata_2164ba7d7e014cfa6e5237c8d2e56c60.perform(ra_action_businessunitdata_2164ba7d7e014cfa6e5237c8d2e56c60.java:52) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3226) ~[prprivate.jar:?] at com.pegarules.generated.activity.ra_action_pxretrievereportdata_79141b5cc236ca170e586888d519cf42.step33_circum0(ra_action_pxretrievereportdata_79141b5cc236ca170e586888d519cf42.java:3596) ~[?:?] at com.pegarules.generated.activity.ra_action_pxretrievereportdata_79141b5cc236ca170e586888d519cf42.perform(ra_action_pxretrievereportdata_79141b5cc236ca170e586888d519cf42.java:701) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3421) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10794) ~[prprivate.jar:?] at com.pegarules.generated.activity.ra_action_pxcallretrievereportdata_244943c4bea7ec6d679b772f4cbc8133.step4_circum0(ra_action_pxcallretrievereportdata_244943c4bea7ec6d679b772f4cbc8133.java:371) ~[?:?] at
Steps to Reproduce
Execute the PegaCA-Interface-BusinessUnit.BusinessUnitData report definition.
Root Cause
The BusinessUnitData report definition was not used in the PegaCustomerService out-of-the-box application. However, this report definition was utilized in the user's application and had references to unoptimized properties which resulted in the errors.
Resolution
Apply HFix-56733.
Tags:
Published March 25, 2020 - 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.