Support Article

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

SA-26424

Summary



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.


Resolution



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.