Page 1 of 1

Error while truncating data set

Posted: Wed Sep 10, 2008 3:37 am
by sateeshbabu
Hi,

We are using Dataset in one of the jobs.

We are using the update policy as "Overwrite" for Dataset.This job is running fine but some times we are getting like below.

Unable to open descriptor file to update: Permission denied

Error updating ORCHESTRATE File Dataset descriptor segment information for '/tmp//meas.ds'.

Error while truncating data set "/tmp//meas.ds".
filesystem related error

Can you please let us know what is the problem causing.

Posted: Wed Jul 29, 2009 9:14 am
by sjordery
I had this - tried to work around it, with little joy. Permissions fine on all the relevant directories etc.

In the end, I had to delete (manually) and recreate the dataset, at which point the error ceased. I think it was a corrupted pointer.

Posted: Wed Jul 29, 2009 9:24 am
by ArndW
I would guess that the DataStage user has only "R" and not "RW" rights to "tmp//meas.ds" because of the error message
"Unable to open descriptor file to update: Permission denied "

Posted: Wed Jul 29, 2009 9:45 am
by priyadarshikunal
/tmp//meas.ds
why the double slash?

Have you stripped the absolute path or it is the exact value you are passing?

Posted: Wed Jul 29, 2009 10:40 am
by sjordery
[quote="ArndW"]I would guess that the DataStage user has only "R" and not "RW" rights to "tmp//meas.ds" because of the error message
[quote] "Unable to open descriptor file to update: Permission denied "[/quote][/quote]

Oops - my bad, sorry. The Group had R only permissions.

Posted: Wed Jul 29, 2009 6:36 pm
by keshav0307
was the job run by same user everytime?