DSXchange

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

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.

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

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

Thanks
Siva