Unable to open hash file

[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.

[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.

[Das]

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]

[DSguru2B]

The hashed file name should be the same while creating and reading the hashed file.

[chulett]

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'.

[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.

[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

[DSguru2B]

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.

[chulett]

Could very well be. The complete error should reveal all, at least to them.

[baglasumit21]

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

[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.

[Das]

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'.

[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?

[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!