DSXchange

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

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

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.

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

Check the permissions on every directory in the path

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

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

Thanks

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.

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

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.