dataset file reading error

[India2000]

HI
I get this error while executing my job

/Transaction.ds: Data set initialization for "/usr/local/input/Transaction.ds": This input-file data set does not exist: /usr/local/input/Transaction.ds.

any one please What is the reason for this eror.This file exist in the directory.How to resolve this issue?

Thanks,

[Developer9]

1.What are you trying to do exactly ??Here you could be more specific by specifying the job flow..then you can get more responses..

Ex:Dataset stage >>>xfm>>peek/sequential file

2.Did you Souce file pathname correctly??
Output link >properties tab>>source/file

3.Did you specify the meta data correctly ??
Dataset stage >>columns tab

4.Can you able to view the data in the source (dataset)??

you can go to Designer >>>Tools>>Dataset Management>>select your dataset >>Dataset viewer option

I think these are some of preliminary items to be checked before we run the job

Experts:please correct my explanation if any changes

Thank you

[qt_ky]

That's the error to expect when the file actually does not exist. Can you show the ls -l /usr/local/input/Transaction.ds output? Make sure the file doesn't have anything strange in the filename, like a trailing space.

[jwiles]

Another possibility is related to file permissions. Can the userid running the datastage job actually see the file? If they have no permissions to the file at any level (user, group, world), it will not be seen by the job.

[chulett]

Could it possibly mean that the while descriptor file may still exist that the actual dataset files it references could not be found?

[ray.wurlod]

I would expect the error message to name the segment file it couldn't find in that case, not the descriptor (.ds) file.

[chulett]

Ok, fair enough. Then I suspect our friend is incorrect about it existing in that location with that exact spelling... with enough permissions to allow it to be read.

[qt_ky]

Here are some possible errors from 8.5.

View Data error when the *.ds file does not exist:

Code: Select all

</path/file.ds> Data set initialization for "/path/file.ds": This input-file data set does not exist: /path/file.ds.
Creation of a step finished with status = FAILED.

View Data error when the *.ds file exists but you don't have read permissions on it:

Code: Select all

Unable to open descriptor file  to read from: Permission denied
Error reading ORCHESTRATE File Dataset descriptor for '/path/file.ds'.
</path/file.ds> Data set initialization for "/path/file.ds": Input-file data set open failure: /path/file.ds.
Creation of a step finished with status = FAILED.

View Data error when one of the dataset data files does not exist:

Code: Select all

Failure during execution of operator logic.
Input 0 consumed 0 records.
Output 0 produced 0 records.
Fatal Error: I/O subsystem: Open of /path/file.ds....0000.0000.0000.3e0156.d04366cf.0000.20ce707d failed: No such file or directory
Player 1 terminated unexpectedly.
APT_PMsectionLeader(1, node1), player 1 - Unexpected exit status 1.
Step execution finished with status = FAILED.

View Data error when one of the dataset data files exist but you don't have read permissions on it:

Code: Select all

Failure during execution of operator logic.
Input 0 consumed 0 records.
Output 0 produced 0 records.
Fatal Error: I/O subsystem: Open of /path/file.ds....0000.0000.0000.3e0156.d04366cf.0000.20ce707d failed: Permission denied
Player 1 terminated unexpectedly.
APT_PMsectionLeader(1, node1), player 1 - Unexpected exit status 1.
Failure during execution of operator logic.
Input 0 consumed 0 records.
Output 0 produced 0 records.
Fatal Error: waitForWriteSignal(): Premature EOF on node node_name Socket operation on non-socket
Player 2 terminated unexpectedly.
APT_PMsectionLeader(1, node1), player 2 - Unexpected exit status 1.
Step execution finished with status = FAILED.

[India2000]

Thanks all for your analysis .

If hard code the dataset path through the sequence job activity properties it does read the file from the location but if I pass the path as a parameter job aborts saying Controller problem: Unhandled abort encountered in job ...and in the job it says .ds file in the file pathe location /../../file.ds doesn' exist. Could anyone please let me know how to fix this issue?


Thanks