Support Article
Unable to show data in List type segment after data import
SA-33167
Summary
After importing the customer list into List Segment, unable to see the Imported customers even though the import is successful.
When trying to add customer in List segment it is not showing in existing customer list.
Error Messages
[TABTHREAD1] [ ] [ sgdemo:01.01.01] ( rd.resolve.SqlReportResolver) ERROR xxxxxx |xxxxxx xxxxxxx - An error occured during resolving the report definition - InvalidReferenceException MCDB.pyFullName Unexposed properties cannot be selected for classes mapped to external tables
com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceException MCDB.pyFullName Unexposed properties cannot be selected for classes mapped to external tables
Steps to Reproduce
- Create a segment.
- Select Type as List.
- Open the segment.
- Import data from Excel. Customer data should be visible after importing data but not visible in this case.
Root Cause
PyFullName column was not mapped in associated customer class and not exists in main customer table.
Resolution
PyFullName column is added in associated customer class and main customer view or table to overcome this issue.
Published August 23, 2017 - 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.