Pega CDH - SQL Error running Simple Segment

General
, , ,
1

I have created a simple Segment rule to pull all the customers. When I save and run the segment I get the following error message:

Error executing SQL for TabSet 1, Group Group 1 : ERROR: column reference "customerid" is ambiguous Position: 65.png
Error executing SQL for TabSet 1, Group Group 1 : ERROR: column reference "customerid" is ambiguous Position: 65.png2365×262 28.3 KB

I am seeing the following error in the log file as well:

Error while performing insert into tmp table with SQL: INSERT INTO segallC0(pySubjectID, pyGroupID, CriteriaID) SELECT customerid AS pySubjectID, customerid AS pyGroupID, 0 AS CriteriaID FROM (SELECT PC2.customerid, PC2.customerid FROM externalmktdata.Engagecustomer PC2 WHERE (PC2.firstname IS  NOT NULL)) src 
org.postgresql.util.PSQLException: ERROR: column reference "customerid" is ambiguous 

Any advice?

2

@HerbT765 please log a support issue via the MSP and provide the INC id here so that we can help track it.

3

@HerbT765 Hi, did you get the solution for the above issue as I am facing the same. Can you help with the details please.