Page 1 of 1

Key field "ID" was not found in the input schema

Posted: Wed Feb 04, 2009 10:27 am
by poorna_76
I am encountering a strange issue here.
When i run the job in parallel mode (using configuration 2x2) the job is failing with the following error message:

main_program: Error when checking operator: Key field "ID" was not found in the input schema.

main_program: Internal Error: (status == APT_StatusOk): sc/sc.C: 3731
Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH


when i run the job using 1x1 configuration , it executes fine without any issue.

I verified all the stages and partitioning, everything looks good.
Join & Aggregate stages i have it as 'Hash' partition.
SurrogateKey stage i have the 'Round Robin' partition.
Rest of all the stages are set to 'Auto' partition.

Thanks in Advance.

**Note: Subject field modified to insert spaces so search engine will find this later - Content Editor **

Posted: Wed Feb 04, 2009 3:01 pm
by ray.wurlod
Any other messages? In particular, are you able to establish from the logged messages which operator (stage) generated the "key not found" message? How is your Join defined (that is, what are its key columns)?