Segment criteria issue if cust key prop and column are different
SummaryIf 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 MessagesThis segment cannot be run due to the following error:
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
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: column pc0s.accountid does not exist
| SQL Code: 0 | SQL State: 42703
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 ReproduceUse a customer class with the column backing the key property with a different name. For example, property = CustomerID, column = CustID.
- Create a Segment. Save it.
- Create a second Segment. Add a Segment criteria and reference the first Segment.
- Try running the second Segment. Note the error message in the Run Segment modal dialog.
Root CauseA defect in Pegasystems’ code or rules
Published April 6, 2017 - Updated April 22, 2017