error while using lookup stage

logic · Post by **logic** » Thu Aug 11, 2005 5:23 pm

Hi,
While using lookup stage in a job I am getting the following error

Lookup_14,0: Could not map table file "/dsresource01/hr_dev/datasets/lookuptable.20050811.4k2zscc (size 496 bytes)": Invalid argument
Error finalizing / saving table /tmp/dynLUT3483346a65d3a7

Lookup_14,0: Operator's runLocally() failed

What could be causing this error? I am using a fileset for lookup and i am feeding the output to a transformer which in turn populates an oracle table. The input is coming from a join stage via a transformer.
Thanks.
Ash.

Kirtikumar · Post by **Kirtikumar** » Fri Aug 12, 2005 5:17 am

Is it generating some other warning messages or errors along with this message?
I have once faced a problem with lookup stage due to unsufficient space on tmp drive to create a temp lookup table.

If you can post any other errors or warnings in addition to the mentioned one it will be helpful.

logic · Post by **logic** » Fri Aug 12, 2005 9:39 am

Hi KirtiKumar,
Thanks for the reply. It is not generating any other errors than mentioned above. The other errors that follow the above errors are:

Code: Select all

Lookup_14,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

main_program: Unexpected exit status 1

main_program: Step execution finished with status = FAILED

I think the tmp drive has sufficient space, still i will double check. What else could be possibly causing this problem

Thanks