DSXchange

Hi,

This might sound like a stupid question.. When a job is run loading a dataset using one userId, and you try running another job reading from that dataset using another ID.. Will this cause a problem ? One job is aborting and I have a feeling that this could be the problem..

Are you getting the error message 'permission denied'? Does both userid's have same execution permission for that folder/file ?
This can be the reason.

JoshGeorge wrote:Are you getting the error message 'permission denied'? Does both userid's have same execution permission for that folder/file ?
This can be the reason.

No that's not the error... the error message being shown is :

Dataset,0: Fatal Error: I/O subsystem: Open of /Folder/Folder1//Dataset.ds.dsadm.etltest.0002.0000.0000.7130ac.c88f5755.0000.f72da55e failed: No such file or directory

Any idea why this could be happening?

There are two adjacent slash characters in the pathname. My guess is that you are using a job parameter for the directory path of the Data Set control file, have a trailing slash on the value supplied for it, and a slash between the job parameter reference and DataSet.ds in the File property of your Data Set stage.

UNIX doesn't care, your issue lies elsewhere.

Path or file name not the same as of your previous job?

Havoc wrote: No such file or directory

Some UNIXes do care.

Ok, I'll play since I'm curious. Do you happen to know which ones do? My experience is not as extensive as yours but haven't run across one that does care yet. Serious question, btw.

It would only take a couple seconds for the OP to check and see if it was an issue on their O/S.

MKS Toolkit (which I'm using this week) for one. (OK, it's not really UNIX.) I believe that, under some circumstances (relative pathnames?) AIX can also throw a hissy fit with // in a pathname.

I have the same problem :

I suppose somebody else created a dataset in the same directory, but not from the same environnement.

So For solution in TEST environnement :

I created a dataset with a different name.

Because my datasets can have diffrents name suffixs.

AND IT works ! fine !

I think there is now file for job run..because when job is running that time will be checking the file into the directory at that time there is no file means come like this abort.

U go ahead and check it into perticluar directory whethaer file will be there or already processed after if file not recieved means wait for some time till file come.after recieved file only we can execute.

Havoc wrote:

JoshGeorge wrote:Are you getting the error message 'permission denied'? Does both userid's have same execution permission for that folder/file ?
This can be the reason.

No that's not the error... the error message being shown is :

Dataset,0: Fatal Error: I/O subsystem: Open of /Folder/Folder1//Dataset.ds.dsadm.etltest.0002.0000.0000.7130ac.c88f5755.0000.f72da55e failed: No such file or directory

Any idea why this could be happening?

U has not participated thus far in this thread.

If it is DEV or TEST environment, it could also be due to usage of different config files. Use Orchadmin describe or dataset management to see if same config file was used by different users.

Thanks