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
Error at lookup stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Re: Error at lookup stage
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
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