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.
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.
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