DataSet problem

Havoc · Post by **Havoc** » Sun Aug 19, 2007 4:52 am

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..

JoshGeorge · Post by **JoshGeorge** » Sun Aug 19, 2007 5:52 am

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.

Havoc · Post by **Havoc** » Sun Aug 19, 2007 7:02 am

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?

ray.wurlod · Post by **ray.wurlod** » Sun Aug 19, 2007 7:29 am

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.

chulett · Post by **chulett** » Sun Aug 19, 2007 8:09 am

UNIX doesn't care, your issue lies elsewhere.

JoshGeorge · Post by **JoshGeorge** » Sun Aug 19, 2007 8:57 am

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

Havoc wrote: No such file or directory

ray.wurlod · Post by **ray.wurlod** » Sun Aug 19, 2007 3:14 pm

Some UNIXes do care.

chulett · Post by **chulett** » Sun Aug 19, 2007 3:24 pm

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.

ray.wurlod · Post by **ray.wurlod** » Sun Aug 19, 2007 3:31 pm

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.

gge · Post by **gge** » Mon Mar 10, 2008 4:47 am

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 !

venkat_april · Post by **venkat_april** » Mon Mar 10, 2008 5:55 am

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?

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2008 6:11 am

U has not participated thus far in this thread.

dsxuserrio · Post by **dsxuserrio** » Mon Mar 10, 2008 7:18 am

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