Unable to open Hash File

vardhan354 · Post by **vardhan354** » Thu Aug 03, 2006 2:18 pm

Hi folks,

Im trying to run an etl job which uses the hashed file as lookups.These files are located in /u02/HashFiles.
The jobs runs successfully for one run and some time the job gets aborted becoz of the following error.
DSD.UVOpen Unable to open file '/u02/HashFiles/yyyyyy.
Could any one help to get rid of this error.

Thanks

kcbland · Post by **kcbland** » Thu Aug 03, 2006 2:41 pm

Are sure the files exist?

vardhan354 · Post by **vardhan354** » Thu Aug 03, 2006 2:54 pm

Yes...I could see those files in that directory.....

kris007 · Post by **kris007** » Thu Aug 03, 2006 2:58 pm

Are you using the same hashed file in any other Jobs?
Do you have any Job which writes data to this hashed file?
If so, do you select the Option "delete before create" or "Clear before writing" action?

vardhan354 · Post by **vardhan354** » Thu Aug 03, 2006 3:49 pm

Hey Kris....
Your are right....there was one job going in parallel which is writing into the hashfile.So I just changed the execution order.Now it is working fine.
Some times,small things will effect everything..................

Thanks...