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

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
poorna_76
Charter Member
Charter Member
Posts: 190
Joined: Thu Jul 08, 2004 10:42 am

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

Post 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 **
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply