Page 1 of 1

look up Stage Error

Posted: Mon Sep 26, 2011 10:49 am
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.

Posted: Mon Sep 26, 2011 10:57 am
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?

Posted: Mon Sep 26, 2011 12:10 pm
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,