Unable to open hash file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
arunverma
Participant
Posts: 90
Joined: Tue Apr 20, 2004 8:20 am
Location: MUMBAI
Contact:

Unable to open hash file

Post by arunverma »

Hi ,

In our devlopment server prjoect directory mount point reahed 100 %
and this cause one hash file got corrupt ( unable to make entry in VOC file ) now we tried to analyze , clear , delete this hash file from universe but could not . giving following error - ( Hash file name is H_CUST_PHONE_CAF. )


Cannot open file "H_CUST_PHONE_CAF".
*** Processing cannot continue. ***

we tried to create hash file from DS job but got following error in Log

J05MshCustDetail..H_CUST_PHONE_CAF.toHFile2: Creating File H_CUST_PHONE_CAF, Executing Command =
CREATE.FILE H_CUST_PHONE_CAF DYNAMIC

DSD.UVOpen "H_CUST_PHONE_CAF" is already in your VOC file as a file definition record.
File name =
File not created.
.|

can any one help me how to create hash file with this same name . We don't require data .


Regards

Arun
Arun Verma
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Hello Arun,

it looks like someone might have physically deleted the UNIX file from outside of DataStage. Go to the Administrator and execute the command "LIST VOC H_CUST_PHONE_CAF". If you get an entry of the type "F" and you are sure that the file system H_CUST_PHONE_CAF doesn't exist then you can enter the command "DELETE VOC H_CUST_PHONE_CAF" to delete the entry, then a subsequent creation attempt from within a DataStage job run will work. Another option available to you (if the VOC entry exists) is to copy another file at UNIX level to the name "H_CUST_PHONE_CAF". The data & metadata for the file are now completely wrong, but if you drop & create the file from within DataStage that will re-create it into the correct form.
arunverma
Participant
Posts: 90
Joined: Tue Apr 20, 2004 8:20 am
Location: MUMBAI
Contact:

Post by arunverma »

Great !!!!

Thanks Mr Arndw ,

We have followup your first suggestion , now we are able to create same hash file name :lol:

Thanks again

Regards

Arun
Arun Verma
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Hello Arunverma,

it was my pleasure to be able to help! Good luck on the project.
Post Reply