Support Article

Segment generation fails with ORA-00904: "PC0"."CUSTOMERID"



Segment generation fails with ORA-00904: "PC0"."CUSTOMERID": invalid identifier error and generated SQL as below:

SELECT COUNT(1) as ".TestRowCount" FROM <DBName>.<CustomerTable> PC0 WHERE ((( PC0.CustomerID not in ( select PC0.CustomerID from <CustomerTable> PC0 where ((PC0.CUSTOM_NO like '3%')) )))) AND (1=2)

Generated SQL was incorrect and it is looking for a column called CustomerID, which does not exist.

Error Messages

Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 904: java.sql.SQLSyntaxErrorException: ORA-00904: "PC0"."CUSTOMERID": invalid identifier

Steps to Reproduce

Anytime a Segment is Run,
UI shows the exception in advance and does not allow you to confirm.

Root Cause

The CustomerID Property is mapped to database table key column was missing the "." (dot) before the CustomerID in the Customer class External Mapping tab.


Add the missing dot in the beginning of CustomerID in the External Mapping of Customer class.

Published August 4, 2016 - 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.