UVOpen mkdbfile: cannot create file

maheshsada · Post by **maheshsada** » Mon Mar 27, 2006 11:30 am

Hi

In my job, selecting data from table(1077070) and writing to hashfile, and this hashfile is used as lookup for other job.
This job is running fine for more than 1 year, suddenly its giving an error DSD.UVOpen mkdbfile: cannot create file /opt/etlbatch/hashfiles/HAdcCharge_026

i have checked the space in the dir
13631488 11554281 1948288 86% /opt/etlbatch

I have checked the forum and not getting a clear picture.

regards
Magesh S

kcbland · Post by **kcbland** » Mon Mar 27, 2006 12:10 pm

Verify permissions of the directory, umask setting in ds.rc script, and userid with group.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 27, 2006 3:00 pm

What has changed?

Is there any other message, such as failed to delete /opt/etlbatch/hashfiles/HAdcCharge_026 ?

maheshsada · Post by **maheshsada** » Tue Mar 28, 2006 2:14 am

no its not giving any other message.

The day before it run, it has failed because of space issue in the server, so we deleted some unwanted files and created space. Then we restarted the job and the job got failed with the below error.
We reset the job and the error message is

DSD.UVOpen Unable to open file '/opt/etlbatch/hashfiles/HAdcCharge_026'., do we need to delete the hashfiles in hasdir in server and then continue. Any suggestions welcomed

regards
Magesh S

ArndW · Post by **ArndW** » Tue Mar 28, 2006 2:22 am

Magesh - note that you are now showing a different error than originally, which is why Ray asked the question. You have a pointer in your VOC file that points to a non-existant file on the system. I think if you were to modify your hashed file settings to also "DELETE file before create" it will remove the VOC pointer to the file as well and then not have a problem in re-creating the UNIX objects.

You can also take a small hashed file and copy it to your "'/opt/etlbatch/hashfiles/HAdcCharge_026" location if this file is being cleared before use.

maheshsada · Post by **maheshsada** » Tue Mar 28, 2006 5:42 am

Hi

Iam showing the error which i got in the director log, there is no log which says delete failed, moreover in the job design for hashfile stage -

we have checked the update action portion -

Clear file before writing and

Create File option is unchecked

Magesh S

maheshsada · Post by **maheshsada** » Tue Mar 28, 2006 5:43 am

Hi

Iam showing the error which i got in the director log, there is no log which says delete failed, moreover in the job design for hashfile stage -

we have checked the update action portion -

Clear file before writing and

Create File option is unchecked

Magesh S

ArndW · Post by **ArndW** » Tue Mar 28, 2006 6:21 am

In order to get back into sync, check the create and check the delete-before-create options.

maheshsada · Post by **maheshsada** » Wed Mar 29, 2006 1:00 pm

Hi
thank you , checked create and delete option, the job got completed
Magesh S