Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
ves_diego
Contributor

Error file not found "The system cannot find the file specified"

Hello !

i've a little problem with the tFileInput. In the main Job i read correctly a csv file (configuration file with same context variabile), with the "On Component Ok" connected to a tContextLoad.

Into this job i call another job, where i have to read the same csv, and here there is the problem. When i call the tFileInput in the subjob, talend return the error "The system cannot find the file specified", but in the parent job the csv file was opened successully!

Any idea?

Thanks,

Diego

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II

In tRun component have you configured context section?

Please check the below example

​https://help.talend.com/r/1RJ7TatgS73nP1RPGjT50w/RGvRFDFE3zpmX_rYN63gUw

Thanks,

Manohar ​

View solution in original post

6 Replies
manodwhb
Champion II

@Diego Vescovi​ , could you please share your job design so that I can help you where it is missing.

 

Thanks,

Manohar

ves_diego
Contributor
Author

Thank you.

 

This is the parent job:

0693p00000AbH3hAAF.png 

and this is the child job:

0693p00000AbH3rAAF.png 

in the tJava i wrote this:

System.out.println("PARENT");

System.out.println(context.mailSMTPHost);

System.out.println(context.mailSMTPAuthUser);

System.out.println(context.mailSMTPAuthPass);

System.out.println(context.mailSMTPPort);

 

System.out.println(context.mailCC);

System.out.println(context.mailFROM);

System.out.println(context.mailTO);

System.out.println(context.mailBCC);

 

("PARENT" for parent job, "CHILD" for child job)

 

and this is the output when i ran the parent job:

 

Starting job parent at 15:36 11/12/2020.

 

[statistics] connecting to socket on port 3478

[statistics] connected

PARENT

smtp.gmail.com

XXXXXXXXXXXX

465

XXXXXXXXXXXX

XXXXXXXXXXXX

XXXXXXXXXXXX

 

Null value will be used for context parameter totalCount: For input string: ""

 

CHILD

 

 

 

 

 

 

 

 

[statistics] disconnected

 

Job parent ended at 15:36 11/12/2020. [exit code=0]

 

(i replaced the data with XXX)

 

Thank you,

Diego

manodwhb
Champion II

In tRun component have you configured context section?

Please check the below example

​https://help.talend.com/r/1RJ7TatgS73nP1RPGjT50w/RGvRFDFE3zpmX_rYN63gUw

Thanks,

Manohar ​

ves_diego
Contributor
Author

ok, now i add the context in tRun component and it works. But i don't undestand: why do i have to configure the context section in tRun if I already entered the the context in the job?

 

Thank you,

Diego

manodwhb
Champion II

You are trying to take parent context value into sub level that you need to configured in tRunJob context otherwise it will not pick the parent context value.

manodwhb
Champion II

@Diego Vescovi​ ,please accept the solution and like it appreciate the community people.

 

Thanks,

Manohar