InvalidReferenceException while running CPMGetContactInfo
User is gets an error while running CPMGetContactInfo Report definition.
An error occured during resolving the report definition -
InvalidReferenceException LoyaltyPointsBalance Unexposed properties cannot be selected for classes mapped to external tables
com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceException LoyaltyPointsBalance Unexposed properties cannot be selected for classes mapped to external tables
Steps to Reproduce
Run the report definition standalone.
The root cause of this problem is a defect in user's application code or rules. The property is not exposed in the external table.
This issue is resolved through the following local-change:
Run the below alter query on the mapped table instance:
ALTER TABLE pa_contact ADD LOYALTYPOINTSBALANCE NUMBER(22,0)
100% found this useful