Page 1 of 1

Unable to open Hash File

Posted: Thu Aug 03, 2006 2:18 pm
by vardhan354
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

Posted: Thu Aug 03, 2006 2:41 pm
by kcbland
Are sure the files exist?

Posted: Thu Aug 03, 2006 2:54 pm
by vardhan354
Yes...I could see those files in that directory.....

Posted: Thu Aug 03, 2006 2:58 pm
by kris007
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?

Posted: Thu Aug 03, 2006 3:49 pm
by vardhan354
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.................. :idea:
Thanks... :lol: