Page 1 of 1
Getting error while writing a dataset
Posted: Thu May 12, 2011 2:09 am
by vinodshinde369
In a simple datastage job in DS v8.5 I am writing two datasets X and Y. For both the datasets 'Update Policy=Overwrite'. job is able to write data in dataset X, but while writing data in dataset Y its giving error
'.ds : Rename .ds to .ds.being_deleted failed.'
Even I am not able to see the data from dataset Y by usnig dataset managment.
Please help.........
Posted: Thu May 12, 2011 5:14 am
by ray.wurlod
Check permissions.
Re: Getting error while writing a dataset
Posted: Thu Aug 09, 2012 6:07 am
by nehak
what was the solution..? Can you help me if you remember.
Re: Getting error while writing a dataset
Posted: Thu Aug 09, 2012 8:43 am
by synsog
Hi Ray,
This is similar error which I am facing in recent days.
but not every day.. its is occuring atleast once in a week, what could be the cause for this error other than permissions, if it was purely based on permissions, then we should get this error for every run.?
Re: Getting error while writing a dataset
Posted: Thu Aug 09, 2012 3:05 pm
by VineelPrem
I did encounter this problem a couple of times even though there were permissions .I dont know what causes the problem but changing the update policy to Use Existing(Discard schema & records) got rid of this error .
Posted: Mon Aug 08, 2016 3:50 am
by dbalzer
We had the same error because the DataStage job has been accidentally called 2 x at the same time in our UC4 job plan. Both jobs have been trying to write to the same file.