Unable to open descriptor file to create - Fatal Error

vij · Post by **vij** » Thu Aug 23, 2007 7:23 am

hi all,

I have a strange problem. I have copied jobs from Production Environment to Development Environment and i have to modify the job with few additional stages. For the stages which are copied, if I right click, "Properties" option is not highlighted and for the other stages which are added newly, it is highlighted.

Also, when I have imported from Production it was "READ ONLY" and I have made it to NRO, inroder to use it.

And now, i get these fatal errors, wen i run the jobs:
1.main_program: Unable to open descriptor file to create: No such file or directory
2.main_program: Error writing ORCHESTRATE File Data Set descriptor for 'location/File_name'.

Can any one pls throw some light on it?

chulett · Post by **chulett** » Thu Aug 23, 2007 7:38 am

How, exactly, did you 'copy' the jobs? How did you make it NRO?

vij · Post by **vij** » Thu Aug 23, 2007 8:03 am

It is not copy, sorry, export from Production and imported to Development Environment and I made it NRO by the following command:
UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' NAME ='Jobname'

vij · Post by **vij** » Thu Aug 23, 2007 8:06 am

It is not copy, sorry, export from Production and imported to Development Environment and I made it NRO by the following command:
UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' NAME ='Jobname'

chulett · Post by **chulett** » Thu Aug 23, 2007 8:07 am

And how many records did that statement update? Hint: there's no job name in DS_JOBOBJECTS.

ds_debasis · Post by **ds_debasis** » Thu Aug 23, 2007 8:16 am

vij wrote:It is not copy, sorry, export from Production and imported to Development Environment and I made it NRO by the following command:
UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' NAME ='Jobname'

Hi
If you exported as .dsx file. Please open that on notepad or any text editor, find all readonly and set the value to 0 ( or 1 if it is 1 than 0 or vice versa). I had the same issue before.

-Debasis

ArndW · Post by **ArndW** » Thu Aug 23, 2007 3:21 pm

It also seems as if you have hard-code paths to file objects in your job and haven't changed them for the new machine.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 23, 2007 4:41 pm

There's a WHERE word missing from your UPDATE statement! You might also need to change the job's record in DS_JOBS.

vij · Post by **vij** » Thu Aug 23, 2007 10:08 pm

Hi all,

thanks for ur replies. yes there is a where clause missing in the command and I have used the correct command and made it unread and modified the jobs also, now when I run a job, following fatal errors, occured:

main_program: Unable to open descriptor file to create: No such file or directory
main_program: Error writing ORCHESTRATE File Data Set descriptor for '/work/data/ds_DATA.ds'.
main_program: Fatal Error: Could not create output file '/work/data/ds_DATA.ds. filesystem related error

And I had a doubt whether is the above error occured because the jobs are imported from different environment and is there a link between the above error with the "Properties" option not highlighted , when I right click on any stage.

Pls help me solving this.

Thanks,
Vij

ArndW · Post by **ArndW** » Thu Aug 23, 2007 10:40 pm

I guess you missed my earlier post, so I'll repeat myself:

It also seems as if you have hard-code paths to file objects in your job and haven't changed them for the new machine.

vij · Post by **vij** » Thu Aug 23, 2007 10:44 pm

Hi ArndW ,

We have not hard coded any values, all of them are parameters only, any ways let it check it again.

ArndW · Post by **ArndW** » Thu Aug 23, 2007 10:50 pm

You job is telling you that "'/work/data/ds_DATA.ds'" does not exist.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 24, 2007 12:02 am

... or that /work or /work/data do not exist

vij · Post by **vij** » Fri Aug 24, 2007 12:36 am

yes, the file path was incorrect, so it cant create the ouput file. Thanks all.