Unable to open hash file
Moderators: chulett, rschirm, roy
Unable to open hash file
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.
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.
Actaully i am not able to read hash file.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. ...
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]
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'.chulett wrote:please post the exact and complete error from the log.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Correct terminology is "hashed" file, not "hash" file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 22
- Joined: Mon Apr 02, 2007 4:02 am
- Location: MUMBAI
- Contact:
All above datastage proffessionals says right
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
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
Smrutiranjan Nayak
Re: Unable to open hash file
I think this is where he is going wrong. Giving different names while creating and reading the hashed file.Das wrote:and i the input tab file name as input link name and in output tab output ink name.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Unable to open hash file
The input tab file name and output tab file name shud be same. else it wont work. make both the names common say input linkDas 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.
SMB
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,chulett wrote:Please. Also, what DSGuru posted goes without saying - the names must be the same, not should be. And on ...chulett wrote:please post the exact and complete error from the log.
Thanks.
I am getting the following error in director
WDF..Staff_hash.Hash_staff: DSD.UVOpen Unable to open file '/ABC/Dasl/Hash_staff'.
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!