Support Article
List Segment does not work for table with PART_KEY column
SA-60143
Summary
List Segment does not work when using a user table with Partionkey column named as PART_KEY.
The user has Pega Marketing v7.22 on Pega 7.3.
Error Messages
Last SQL: INSERT INTO PRPC_NBAM_USR.MKTSEGTestListSegment2 (CustomerID, PARTITIONKEY) ( SELECT PC1.CUSTOMERID, PARTITIONKEY FROM PRPC_NBAM_USR.MKT_LIST_SEGMENT PC1, PRPC_NBAM_USR._VW_DECISION_CAR PC2 WHERE PC1.SEGMENTID = ? AND PC1.CUSTOMERID = PC2.CUSTOMERID)
java.sql.SQLSyntaxErrorException: ORA-00904: "PARTITIONKEY": invalid identifier
Steps to Reproduce
- Create a new List Segment
- Create a comma-separated values (CSV) file with user data
- Import the CSV file to the Segment
- Check in the List Segment which triggers the Segment population
Root Cause
A defect in Pegasystems’ code or rules. The code PARTITIONKEY was hardcoded in the PUSHLISTDATATOSEGMENTTABLE activity.
Resolution
Apply HFix-44781.
Published July 26, 2018 - 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.