Support Article

Segment Population Error

SA-32838

Summary



A Segment-Population error occurs while running a segment.

Error Messages



java.sql.SQLSyntaxErrorException: ORA-00904: "PC0S"."CUSTOMERID": invalid identifier

Steps to Reproduce



Create a segment, and run it.

Root Cause



The custom data class has an incorrect key column mapped in the general tab of class definition. This was changed by the user during the custom data class creation using the Database Class mappings tool.

Resolution



The key property on the custom data class must be CustomerID. This property can be mapped to any one database column (of the appropriate type) through the External Mappings on the Class rule.

Published January 24, 2017 - Updated August 23, 2017

Have a question? Get answers now.

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