Issue with 'AppGetAccountList' Report Definition
Issue with 'AppGetAccountList' Report Definition, which is in 'PegaLS_CPMLSFW:07-13-01' ruleset.
Error MessagesAn error occured during running the report definition - InvalidReferenceException roles.RoleDescription Unexposed properties cannot be selected for classes mapped to external tables.
com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceException roles.RoleDescription Unexposed properties cannot be selected for classes mapped to external tables
Steps to Reproduce
- Open the rule 'AppGetAccountList' in developer portal.
- From Other Actions run the rule and observe that there is an error shown in UI
Root CauseWhen the user opens the Report Definition and checks its pages and classes. They are 4 classes defined.
On doing test connection for all these classes there were errors.
Developer recieved error related to ‘roles.RoleDescription’ property in ‘PegaApp-Interface-Roles’.
Observed that class was mapped to wrong table. It should be pointed to ‘pa_roles’ table. Corrected the mapping of class PegaApp-Interface-Roles to ‘pr_roles’ table.
And for the class 'PegaCPMLS-Int-AccountGenInfo' table 'PALS_ACCOUNTDETAILS' did not exist in Database after upgrade. On re-importing the CPMLS jar the table got created.
- Correcting the mapping of class PegaApp-Interface-Roles to ‘pr_roles’ table.
- Re-importing the CPM LS jar to get the missing table 'PALS_ACCOUNTDETAILS'.
Published October 21, 2016 - Updated November 3, 2016