unable to create sequential file as debug file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
chitravallivenkat
Participant
Posts: 106
Joined: Thu Jun 08, 2006 8:51 am

unable to create sequential file as debug file

Post by chitravallivenkat »

Hi,

I am trying to create a debug file to check the data. Actually it is populating into table. I am just populating it to a file in the same way. It is saying unable to create file....

The error message is:


H:\\DEV_ZGP0GSAS\\Temp/NyScty_Ins_SctyDescADD.txt: Permission denied

I think the file got locked.


How to overcome this error.


Regards

Rudresh
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Make sure you are giving right path.
Try with H:/DEV_ZGP0GSAS/Temp/NyScty_Ins_SctyDescADD.txt instead of
H:\\DEV_ZGP0GSAS\\Temp/NyScty_Ins_SctyDescADD.txt
Also make sure the user id have permission to H:/DEV_ZGP0GSAS/Temp/ directory.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

kumar_s ,

Presumably those should be '\' characters under Windows ... ?

H:\DEV_ZGP0GSAS\Temp\NyScty_Ins_SctyDescADD.txt

J.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

My Bad... yes not Shlash '/' but Back slashes '\'.
Where you able to access it now with '\'?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Make sure that the user that ran the job has permissions to all sections of the pathname - drive, folders, etc. And the filename itself, of course.
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Re: unable to create sequential file as debug file

Post by DSguru2B »

chitravallivenkat wrote: I think the file got locked.
If the file was never created how can it get locked. And if the file was, infact, locked by some other process, you will get a different error message. This is clearly a permissions issue as other have noticed. Look into the permissions through and through.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chitravallivenkat
Participant
Posts: 106
Joined: Thu Jun 08, 2006 8:51 am

Post by chitravallivenkat »

Hi All,


I am able to create a file with forward slash only. I can able to run successfully for 5-6 times. After some time, this error will come.

The file was created when i ran the first time. The next time onwards, it will be overwritten. So, there is a chance of locking. I have all type of access for the folder.

Thanks in advance...

VC
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

By any chance, were you running the job in Multiple instance which targets the same file as target at the same time?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
chitravallivenkat
Participant
Posts: 106
Joined: Thu Jun 08, 2006 8:51 am

Post by chitravallivenkat »

Hi,

I am running one instance at a time and i am not using the same filename anywhere in the project..


VC
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

You are missing something to mention here. Just to try, keep deleting the file that been created on the output directory. So that you can come to a conclusion that its due to only the overwriting on a same file, which still is not a issue any ways.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply