Failure in Lookups using Lookup File Set and Data Set
Posted: Wed Jan 21, 2009 12:23 pm
I have this simple text file that i converted both to LookupFileStage and DataSet so that i can use them as reference in Lookup stage.
In both cases i am having hard time getting them to work with similar reasons. (I think)
When I generate the lookup file set and dataset I make sure that the field is clicked as 'Key'. Despite this I am getting this error.
The next record I see is this ..
These are the messages I got when I used DataSet stage to look up the values. When I use LookupFileStage I get similar problems.
In both cases i am having hard time getting them to work with similar reasons. (I think)
When I generate the lookup file set and dataset I make sure that the field is clicked as 'Key'. Despite this I am getting this error.
Code: Select all
Lookup_14,0: Failed a key lookup for record 1 Key Values: SCACCode: Code: Select all
Lookup_14,1: The runLocally() of the operator failed.
Lookup_14,1: Operator terminated abnormally: runLocally() did not return APT_StatusOk
Code: Select all
Lookup_14,1: Failed a key lookup for record 1 Key Values: SCACCode:
Lookup_14,0: Failed a key lookup for record 1 Key Values: SCACCode:
Lookup_14,0: The runLocally() of the operator failed.