Support Article

Segment criteria issue if cust key prop and column are different

SA-36147

Summary



If the marketing customer class key property is mapped to a column with a different name, Segment criteria do not work in Pega Marketing 7.22. When you go to run a Segment with an included Segment criteria, you get an error message saying that the Segment cannot be run.


Error Messages



This segment cannot be run due to the following error:

Error Message
There was a problem performing a database query: There was a problem getting a list: code: 0 SQLState: 42703 Message: ERROR: column pc0s.accountid does not exist
Position: 105
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: column pc0s.accountid does not exist
Position: 105
| SQL Code: 0 | SQL State: 42703

SQL Statement
SELECT COUNT(1) as ".TestRowCount" FROM mktdata.nbam_customer PC0 WHERE (((((PC0.accountid IN (Select PC0S.accountid from MKTSEGJR_NBAMCust_Child_NV PC0S)))))) AND (1=2)


Steps to Reproduce



Use a customer class with the column backing the key property with a different name. For example, property = CustomerID, column = CustID.
  1. Create a Segment. Save it.
  2. Create a second Segment. Add a Segment criteria and reference the first Segment.
  3. Try running the second Segment. Note the error message in the Run Segment modal dialog.


Root Cause



A defect in Pegasystems’ code or rules

Resolution



Apply HFix-33455

Published April 6, 2017 - Updated April 22, 2017

Have a question? Get answers now.

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