Support Article

Issue with 'AppGetAccountList' Report Definition

SA-29443

Summary



Issue with 'AppGetAccountList' Report Definition, which is in 'PegaLS_CPMLSFW:07-13-01'  ruleset.


Error Messages



An 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

  1. Open the rule 'AppGetAccountList' in developer portal.
  2. From Other Actions run the rule and observe that there is an error shown in UI


Root Cause




When the user opens the Report Definition and checks its pages and classes. They are 4 classes defined.
 
  1. PegaCA-Interface-Account
  2. PegaCPMLS-Int-EntityMapping
  3. PegaApp-Interface-Roles
  4. PegaCPMLS-Int-AccountGenInfo


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.


Resolution

  1. Correcting the mapping of class PegaApp-Interface-Roles to ‘pr_roles’ table.
  2. Re-importing the CPM LS jar to get the missing table 'PALS_ACCOUNTDETAILS'.

 

Published October 21, 2016 - Updated November 3, 2016

Have a question? Get answers now.

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