Unble to open hash file ,& not able to delete hash file

bhaskarjha · Post by **bhaskarjha** » Thu May 25, 2006 8:42 am

hi

i have one job which was running previously , but nw its not able to open the same hash files which are there. and also i tried with renaming the hash files still same error the job is getting aborted ,

when i tried to delete these hash files from server it gives messages as sharing voilation and not able to delete it.

kris007 · Post by **kris007** » Thu May 25, 2006 8:45 am

Could you please post the correct error message you are getting when you try to run the job or delete the hashed files. That would be more helpful.

Also, When you rename the hashed files do you also check the "delete file before create" option for that hashed file??

Kris.

DSguru2B · Post by **DSguru2B** » Thu May 25, 2006 8:48 am

Do an exact match search on the key words 'unable to open hash file'. THat will return you a couple of posts. Check them out. IF the error messages in those posts (returned by search) is similar to yours then you might be in luck as the solution is outlined in those earlier posts.
Good Luck.

I_Server_Whale · Post by **I_Server_Whale** » Thu May 25, 2006 9:59 am

Are the hashed files being accessed by any other process???

sb_akarmarkar · Post by **sb_akarmarkar** » Thu May 25, 2006 11:31 pm

I think there is problem with your OS permission......
Please check with your administrator....

Thanks,
Anupam

bhaskarjha · Post by **bhaskarjha** » Thu May 25, 2006 11:38 pm

Hi

the exact error is as

'JOB_CDW_FACT_PEX_TD..TRANSIT_DTLS_H.IDENT9: |JOB_CDW_FACT_PEX_TD..TRANSIT_DTLS_H.LINK_TRANSIT_DTLS_H: DSD.UVOpen Unable to open file 'C:\AFL\HASH_FILE\LINK_TRANSIT_DTLS'.|'

ray.wurlod · Post by **ray.wurlod** » Fri May 26, 2006 12:12 am

What are the permissions on the folder C:\AFL\HASH_FILE ? Particularly for the user ID that executes DataStage jobs.