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 |xxxxxxxxxxxxx - An error occured during resolving the report definition - InvalidReferenceExceptionMCDB.pyFullNameUnexposed properties cannot be selected for classes mapped to external tables
com.pega.pegarules.data.internal.rd.reference.InvalidReferenceException: InvalidReferenceExceptionMCDB.pyFullNameUnexposed properties cannot be selected for classes mapped to external tables



Steps to Reproduce

  1. Create a segment.
  2. Select Type as List.
  3. Open the segment.
  4. 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 February 1, 2017 - Updated August 23, 2017


100% found this useful

Have a question? Get answers now.

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