Error while truncating data set

sateeshbabu · Post by **sateeshbabu** » Wed Sep 10, 2008 3:37 am

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.

sjordery · Post by **sjordery** » Wed Jul 29, 2009 9:14 am

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.

ArndW · Post by **ArndW** » Wed Jul 29, 2009 9:24 am

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 "

priyadarshikunal · Post by **priyadarshikunal** » Wed Jul 29, 2009 9:45 am

/tmp//meas.ds

why the double slash?

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

sjordery · Post by **sjordery** » Wed Jul 29, 2009 10:40 am

[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.

keshav0307 · Post by **keshav0307** » Wed Jul 29, 2009 6:36 pm

was the job run by same user everytime?