Errors on a Lookup Stage
Posted: Mon May 07, 2007 11:39 am
Hi,
I'm trying to run a job that takes 5 lookup files, and does some replace on a transaction file. I created this job on a dev box and it worked fine. The job just got promoted to the production server and errors began appearing. Here is the primary error:
LUP_Join_and_Replace,2: Could not map table file "D:/IBM/Datasets/lookuptable.20070507.i1q4boc" of length 1136: Permission denied
The 'D' drive was the drive the job was created on in the dev system. There is no 'D' drive on the production server
However I never map to any files that I know of. My question is what is this talking about, and can I fix it? The error isn't static either, the ending of the file name changes between runs. e.g.:
LUP_Join_and_Replace,0: Could not map table file "D:/IBM/Datasets/lookuptable.20070507.ukfohxb" of length 1136: Permission denied
These were back to back runs, but the file name changed. This I believe is the main error I need fixed. Another problem that has shown up is that all of my records from an input file come with this warning:
APT_CombinedOperatorController(0),1: Field 'Res' from input dataset '0' is NULL. Record dropped.
This error repeats for every record, but I've been over that file and recreated it several times to no avail.
Any suggestions?
I'm trying to run a job that takes 5 lookup files, and does some replace on a transaction file. I created this job on a dev box and it worked fine. The job just got promoted to the production server and errors began appearing. Here is the primary error:
LUP_Join_and_Replace,2: Could not map table file "D:/IBM/Datasets/lookuptable.20070507.i1q4boc" of length 1136: Permission denied
The 'D' drive was the drive the job was created on in the dev system. There is no 'D' drive on the production server
However I never map to any files that I know of. My question is what is this talking about, and can I fix it? The error isn't static either, the ending of the file name changes between runs. e.g.:
LUP_Join_and_Replace,0: Could not map table file "D:/IBM/Datasets/lookuptable.20070507.ukfohxb" of length 1136: Permission denied
These were back to back runs, but the file name changed. This I believe is the main error I need fixed. Another problem that has shown up is that all of my records from an input file come with this warning:
APT_CombinedOperatorController(0),1: Field 'Res' from input dataset '0' is NULL. Record dropped.
This error repeats for every record, but I've been over that file and recreated it several times to no avail.
Any suggestions?