Page 1 of 1
UVOpen mkdbfile: cannot create file
Posted: Mon Mar 27, 2006 11:30 am
by maheshsada
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
Posted: Mon Mar 27, 2006 12:10 pm
by kcbland
Verify permissions of the directory, umask setting in ds.rc script, and userid with group.
Posted: Mon Mar 27, 2006 3:00 pm
by ray.wurlod
What has changed?
Is there any other message, such as failed to delete /opt/etlbatch/hashfiles/HAdcCharge_026 ?
Posted: Tue Mar 28, 2006 2:14 am
by maheshsada
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
Posted: Tue Mar 28, 2006 2:22 am
by ArndW
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.
Posted: Tue Mar 28, 2006 5:42 am
by maheshsada
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
Posted: Tue Mar 28, 2006 5:43 am
by maheshsada
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
Posted: Tue Mar 28, 2006 6:21 am
by ArndW
In order to get back into sync, check the create and check the delete-before-create options.
Posted: Wed Mar 29, 2006 1:00 pm
by maheshsada
Hi
thank you , checked create and delete option, the job got completed
Magesh S