Permission denied

mtechnocrat · Post by **mtechnocrat** » Wed May 16, 2007 11:50 pm

Hi All

I have a job which extracts data from Oracle and writes to Flat File .We are runnig this from past 1 year on daily basis.from past 2 days job is aborting and throwing error message .

Error Message :

FF_NewMaster.write_NewMaster: ds_seqopen() - error in 'open()' - Permission denied

Can any one suggest me , how to over come from this issue ? What is the reason for this error.

Thanks in Advance

JoshGeorge · Post by **JoshGeorge** » Thu May 17, 2007 12:20 am

What has changed? File access permissions? User process running the DataStage job might be different from your user.

ray.wurlod · Post by **ray.wurlod** » Thu May 17, 2007 1:09 am

Check the permissions on every directory in the path of the file you are attempting to write. Also check the permission on the file itself. Find out when and by whom the change was wrought. Complain to them.

mtechnocrat · Post by **mtechnocrat** » Thu May 17, 2007 1:09 am

The file permissions has not changed and job is runing through DSADMIN in scheduling tool.

ray.wurlod · Post by **ray.wurlod** » Thu May 17, 2007 1:20 am

Check the permissions on every directory in the path

Something HAS changed. "Permission denied" does not magically appear out of thin air.

mtechnocrat · Post by **mtechnocrat** » Thu May 17, 2007 5:24 am

Hi Ray
All the folders are having correct rights( Write access ) in the file path , still I am facing the issue.

Thanks

Maveric · Post by **Maveric** » Thu May 17, 2007 6:12 am

Ideally the permissions should be 2777 i.e read write and delete access to everyone in the same GroupID as the owner of the file. If anyone not in the GroupID runs the job then it will give the permission error.

ray.wurlod · Post by **ray.wurlod** » Thu May 17, 2007 4:43 pm

2775, surely? Actually, just 775 will do. Prefer 2770 or 770 if there are nosey people on the server.

mtechnocrat · Post by **mtechnocrat** » Fri May 18, 2007 12:05 am

One of my team has run this job manually , and file was created on his name , that was causing the issue . I have deleted those files and run thejob through DSADMIN through control M .The job completed sucesfully.

Thanks a lot for all the suggestions.