Page 1 of 1
Unable to open hash file
Posted: Fri Apr 20, 2007 10:53 pm
by Das
hi,
I getting the error while running the job with hash file lookup"unable to open hash file"I have used directory path option while creating the hash file.and i the input tab file name as input link name and in output tab output ink name.
Please help me out.
Posted: Fri Apr 20, 2007 10:56 pm
by chulett
You are unable to
create the hashed file, or to
read it once you've created it? In any case, please post the
exact and complete error from the log.
Posted: Fri Apr 20, 2007 11:28 pm
by Das
chulett wrote: You are unable to
create the hashed file, or to
read it once you've created it? In any case, please post the
exact and complete error from the log. ...
Actaully i am not able to read hash file.
From input stage to hash file the data got transfered.from threre i can not read,or view data.The link from input stage to Hash showing some data got transfered[say 1000 rows,500rows/sec]
Posted: Fri Apr 20, 2007 11:30 pm
by DSguru2B
The hashed file name should be the same while creating and reading the hashed file.
Posted: Fri Apr 20, 2007 11:57 pm
by chulett
chulett wrote:please post the exact and complete error from the log.
Please. Also, what DSGuru posted goes without saying - the names
must be the same, not should be. And on UNIX that means
exactly the same, case and all: 'MyHash' != 'myHash'.
Posted: Sat Apr 21, 2007 2:20 am
by ray.wurlod
You must use identical directory pathname in both Hashed File stages, and you must use the identical hashed file name in both Hashed File stages, irrespective of the link names.
Correct terminology is "hashed" file, not "hash" file.
All above datastage proffessionals says right
Posted: Sat Apr 21, 2007 8:34 am
by smrutiranjannayak
When you ask for some suggestion always give the error details .
Still if you have followed the suggestion above means keeping the directory and file name same for hash while reading and writing and you still got error .
Then just check your hash file it might got corrupted . I am not sure but i had faced such a scenareo .
Open your hash folder and try seeing the type.30 file . If you will see some junk value then it was corrupted . Create it again.
Cheers 
Re: Unable to open hash file
Posted: Sat Apr 21, 2007 9:48 am
by DSguru2B
Das wrote:and i the input tab file name as input link name and in output tab output ink name.
I think this is where he is going wrong. Giving different names while creating and reading the hashed file.
Posted: Sat Apr 21, 2007 11:51 am
by chulett
Could very well be. The complete error should reveal all, at least to them.
Re: Unable to open hash file
Posted: Sun Apr 22, 2007 11:57 pm
by baglasumit21
Das wrote:hi,
I getting the error while running the job with hash file lookup"unable to open hash file"I have used directory path option while creating the hash file.and i the input tab file name as input link name and in output tab output ink name.
Please help me out.
The input tab file name and output tab file name shud be same. else it wont work. make both the names common say
input link
Posted: Mon Apr 23, 2007 12:08 am
by ray.wurlod
Aaarrggh! Use meaningful names. Don't use the default of using the link name as the hashed file name! I wish they'd never introduced this default. It can lead to too many problems, not least wasted disk space.
Posted: Mon Apr 23, 2007 1:10 am
by Das
chulett wrote:chulett wrote:please post the exact and complete error from the log.
Please. Also, what DSGuru posted goes without saying - the names
must be the same, not should be. And on ...
Hi,
Thanks.
I am getting the following error in director
WDF..Staff_hash.Hash_staff: DSD.UVOpen Unable to open file '/ABC/Dasl/Hash_staff'.
Posted: Mon Apr 23, 2007 6:49 am
by chulett
Ok. Is that exactly the same name you used when creating the hashed file? From your O/S can you verify if that directory exists and is accessable?
Posted: Mon Apr 23, 2007 11:13 am
by baigdw
Hi
I suggest the following:
1. Check if you have the read permissions on the directory where you are creating the hashed file.
2. Check if you using the same path name for the directory. Sometimes a white space is all that is causing the error.
3. Before you run the job again try opening the file from Designer from the input tab and the output tab and make sure you have the same number of columns on input and output files.
Cheers!