DSXchange

Hi All,

I am doing a lookup on a sequential file and the lookup file is also a sequential file,I am getting an error and the job gets aborted.The log shows:

Lookup_3,2: Failed a keylookup for record.
Lookup_3,2: The runLocally() of the operator failed.
Lookup_3,2: Operator terminated abnormally: runLocally did not return APT_StatusOk

The input has 3 records and the lookup is on id column with 2 matching records,the condition is to drop

Please throw some ideas,
Rafidwh

Incorrect data /partitions / keys / key types can be the cause. If your keys are varchar/char you might want to Trim() and then then look up.

Did you specify Drop for "Condition not met" or for "Lookup failure"?
You need to set it for "Lookup failure". Then you shouldn't get the warning that the keylookup failed

rafidwh wrote:Hi All,

I am doing a lookup on a sequential file and the lookup file is also a sequential file,I am getting an error and the job gets aborted.The log shows:

Lookup_3,2: Failed a keylookup for record.
Lookup_3,2: The runLocally() of the operator failed.
Lookup_3,2: Operator terminated abnormally: runLocally did not return APT_StatusOk

The input has 3 records and the lookup is on id column with 2 matching records,the condition is to drop

Please throw some ideas,
Rafidwh