Bonjour à tous,
Je souhaite déposer un fichier sur un serveur via SFTP et Talend.
Le serveur fonctionne bien via FileZila mais avec Talend (version 6.1.1.20151214_1327) impossible d'établir la connexion.
J'ai essayé pas mal de truc genre ces deux solutions, essayé aussi avec le composant tFTPClose :
Mais j'ai toujours la même erreur time-out sur le composant de connexion...
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12 put this in the port text box. context.SFTP_PORT); session_tFTPConnection_1.setConfig("PreferredAuthentications","publickey,keyboard-interactive,password" It worked . Thanks Alot. -I tried one more solution, I downloaded latest jsch.jar and renamed it to jsch-0.1.51 and put it in talend_directory\configuration\lib\java this solution also worked for me. Thanks, Pankaj
Une aide serait pas de trop s'il vous plait !
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64 Exception in component tFTPConnection_1 com.jcraft.jsch.JSchException: java.net.ConnectException: Connection timed out: connect at com.jcraft.jsch.Util.createSocket(Util.java:349) at com.jcraft.jsch.Session.connect(Session.java:215) at com.jcraft.jsch.Session.connect(Session.java:183) at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.tFTPConnection_1Process(ImportToEloquaPicklist.java:2076) at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.tMSSqlInput_5Process(ImportToEloquaPicklist.java:1843) at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.tWarn_1Process(ImportToEloquaPicklist.java:791) at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.runJobInTOS(ImportToEloquaPicklist.java:3031) at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.runJob(ImportToEloquaPicklist.java:2725) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_12Process(Copy_of_Talend_Eloqua_13.java:8279) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_10Process(Copy_of_Talend_Eloqua_13.java:7875) [FATAL]: efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist - tFTPConnection_1 java.net.ConnectException: Connection timed out: connect [FATAL]: efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13 - tRunJob_12 Child job running failed at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_11Process(Copy_of_Talend_Eloqua_13.java:7720) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_6Process(Copy_of_Talend_Eloqua_13.java:7275) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_5Process(Copy_of_Talend_Eloqua_13.java:6817) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_4Process(Copy_of_Talend_Eloqua_13.java:6358) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_9Process(Copy_of_Talend_Eloqua_13.java:5894) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tSleep_1Process(Copy_of_Talend_Eloqua_13.java:5760) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_8Process(Copy_of_Talend_Eloqua_13.java:5627) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_10Process(Copy_of_Talend_Eloqua_13.java:5484) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_3Process(Copy_of_Talend_Eloqua_13.java:5015) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_2Process(Copy_of_Talend_Eloqua_13.java:4548) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_1Process(Copy_of_Talend_Eloqua_13.java:4080) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_7Process(Copy_of_Talend_Eloqua_13.java:3607) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tREST_1Process(Copy_of_Talend_Eloqua_13.java:3452) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tJava_1Process(Copy_of_Talend_Eloqua_13.java:2574) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tFileList_1Process(Copy_of_Talend_Eloqua_13.java:2263) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13$4.run(Copy_of_Talend_Eloqua_13.java:14473) Caused by: java.net.ConnectException: Connection timed out: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.<init>(Unknown Source) at java.net.Socket.<init>(Unknown Source) at com.jcraft.jsch.Util.createSocket(Util.java:343) ... 25 more Exception in component tRunJob_12 java.lang.RuntimeException: Child job running failed at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_12Process(Copy_of_Talend_Eloqua_13.java:8304) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_10Process(Copy_of_Talend_Eloqua_13.java:7875) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_11Process(Copy_of_Talend_Eloqua_13.java:7720) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_6Process(Copy_of_Talend_Eloqua_13.java:7275) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_5Process(Copy_of_Talend_Eloqua_13.java:6817) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_4Process(Copy_of_Talend_Eloqua_13.java:6358) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_9Process(Copy_of_Talend_Eloqua_13.java:5894) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tSleep_1Process(Copy_of_Talend_Eloqua_13.java:5760) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_8Process(Copy_of_Talend_Eloqua_13.java:5627) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_10Process(Copy_of_Talend_Eloqua_13.java:5484) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_3Process(Copy_of_Talend_Eloqua_13.java:5015) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_2Process(Copy_of_Talend_Eloqua_13.java:4548) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_1Process(Copy_of_Talend_Eloqua_13.java:4080) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_7Process(Copy_of_Talend_Eloqua_13.java:3607) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tREST_1Process(Copy_of_Talend_Eloqua_13.java:3452) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tJava_1Process(Copy_of_Talend_Eloqua_13.java:2574) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tFileList_1Process(Copy_of_Talend_Eloqua_13.java:2263) at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13$4.run(Copy_of_Talend_Eloqua_13.java:14473)
Merci
Partager