look up Stage Error

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
Billyqing
Participant
Posts: 44
Joined: Thu May 13, 2004 12:00 pm
Location: Canada

look up Stage Error

Post by Billyqing »

Hi All,

I have a lookup Stage error like:
Could not find input field: ID
ID is field of the look up file witch is generated before using it.
The PX job run fine before and not able to run now.
The only thing I have done to this look up file is modified the column data type and the length at previous job for generating this look up file.
I definitely modified the look-up file for current job.
But when I run this job, it failed because of the error list above.

Anyone knows how to fix this error?
Thanks in advance.
Bill
suse_dk
Participant
Posts: 93
Joined: Thu Aug 11, 2011 6:18 am
Location: Denmark

Post by suse_dk »

What is the source stage for the reference data (ID column)? Seq file stage? Connector? Are you able to view data from there?
_________________
- Susanne
Billyqing
Participant
Posts: 44
Joined: Thu May 13, 2004 12:00 pm
Location: Canada

Post by Billyqing »

Hi,

More info as below:

DS Version: 8.5 (EE)
Source Stage: Dataset Stage
View Source data: Yes.
Numbers of Culumns for Look up file: 3
3 columns are used as a key for refference link.
Errors:
Could not find input field "ID1".
Could not find input field "ID2".
Could not find input field "ID3".

The file was generated before it is used.


Thanks,
Bill
Post Reply