Hash file lookup

johnorr · Post by **johnorr** » Mon Nov 08, 2004 9:08 pm

We are running a hash lookup on a flat file which has about 1718 records. When I run the job the following error appears

xfmValidateMerge3C11.QICLINKC1101.hfDSError.lnkProductMissing: DSD.UVOpen Unable to open file hfDSErrorFileC113648.

and in the next event

xfmValidateMerge3C11.LINKC1101.t2_xfm_product: |xfmValidateMerge3C11.LINKC1101.hfDSError.lnkProductMissing: DSD.UVOpen Unable to open file hfDSErrorFileC113648.|

Can some please explain what is the problem and how to troubleshoot it.

Thanks
John

kcbland · Post by **kcbland** » Mon Nov 08, 2004 10:21 pm

Your error message is that the hash file, as named, does not exist and could not be opened. The name of your hash file is "hfDSErrorFileC113648" and it exists in your project. You need to verify that whatever job creates this hash file has run and did create the file under the name and metadata you are expecting.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 08, 2004 11:29 pm

Beware that hashed file names not only must be spelled correctly but also are case-sensitive.

rasi · Post by **rasi** » Mon Nov 08, 2004 11:42 pm

If you had created the hash file in a directory then make sure you specify the directory correctly.

Thanks
Siva