Getting error while writing a dataset

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vinodshinde369
Participant
Posts: 7
Joined: Tue Dec 21, 2010 4:30 am
Location: Pune

Getting error while writing a dataset

Post 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.........
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Check permissions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
nehak
Participant
Posts: 4
Joined: Thu Oct 25, 2007 3:18 am

Re: Getting error while writing a dataset

Post by nehak »

what was the solution..? Can you help me if you remember.
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

Re: Getting error while writing a dataset

Post 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.?
VineelPrem
Participant
Posts: 19
Joined: Tue Jun 26, 2012 11:14 am
Location: Houston

Re: Getting error while writing a dataset

Post 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 .
dbalzer
Premium Member
Premium Member
Posts: 2
Joined: Wed May 23, 2007 5:47 am
Location: Berlin

Post 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.
Detlef Balzer
Berlin, Germany
+49 171 7090014
Post Reply