PDA

View Full Version : Get FTP Error with proxy



Mathayus
11-21-2008, 06:33 AM
Hello,


Sorry for my bad English…


I try to download files via ftp. I must pass via a proxy. If I try to download the files via IE manually, that functions well.
But via Pentaho I always receive the error:


2008/11/21 11:20:52 - Download XXXX files - Start of FTP job entry
2008/11/21 11:20:57 - Download XXXX files - Opened FTP connection to proxy server [xxx.xxx.xx]
2008/11/21 11:20:57 - Download XXXX files - set passive ftp connection mode
2008/11/21 11:20:57 - Download XXXX files - set timeout to 0
2008/11/21 11:20:57 - Download XXXX files - set control encoding to ISO-8859-1
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : Error getting files from FTP : Unexpected null reply received
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : java.io.IOException: Unexpected null reply received
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at com.enterprisedt.net.ftp.FTPControlSocket.readReply(FTPControlSocket.java:855)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at com.enterprisedt.net.ftp.FTPControlSocket.validateConnection(FTPControlSocket.java:340)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at com.enterprisedt.net.ftp.FTPControlSocket.<init>(FTPControlSocket.java:319)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at com.enterprisedt.net.ftp.FTPControlSocket.<init>(FTPControlSocket.java:290)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at com.enterprisedt.net.ftp.FTPClient.connect(FTPClient.java:849)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at org.pentaho.di.job.entries.ftp.JobEntryFTP.execute(JobEntryFTP.java:890)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at org.pentaho.di.job.Job.execute(Job.java:409)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at org.pentaho.di.job.Job.execute(Job.java:510)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at org.pentaho.di.job.Job.execute(Job.java:295)
2008/11/21 11:22:56 - Download XXXX files - ERROR (version 3.1.0-M2, build 709 from 2008/10/13 11:32:54) : at org.pentaho.di.job.Job.run(Job.java:220)
2008/11/21 11:22:56 - Load XXXX and codemapping tables - Starting entry [Abort job]



The `test connection' is ok and the `check folder' also
Somebody to help me?


In advance thank you.


My version: 3.1.0-m2 build 709

sboden
11-21-2008, 06:49 AM
First upgrade to the 3.1-GA version... I remember changes in that entry somewhere in the M versions.

Then rerun with loglevel to detailed, and attach the log again.

Regards,
Sven

Mathayus
11-21-2008, 07:13 AM
Hi,

I've rerun with 3.1-GA version.
The error is not explained as before but the result is same :

2008/11/21 12:07:15 - Download XXXX files - Start of FTP job entry
2008/11/21 12:07:19 - Download XXXX files - Opened FTP connection to proxy server [xxx.xxx.xx]
2008/11/21 12:07:19 - Download XXXX files - set passive ftp connection mode
2008/11/21 12:07:19 - Download XXXX files - set timeout to 0
2008/11/21 12:07:19 - Download XXXX files - set control encoding to ISO-8859-1
2008/11/21 12:08:33 - Spoon - edit job graph entry: Download XXXX files
2008/11/21 12:09:19 - Download XXXX files - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Error getting files from FTP : Unexpected null reply received
2008/11/21 12:09:19 - Download XXXX files - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Error quiting FTP connection: The FTP client has not yet connected to the server. The requested action cannot be performed until after a connection has been established.
2008/11/21 12:09:19 - Download XXXX files - =======================================
2008/11/21 12:09:19 - Download XXXX files - Nr errors : 1
2008/11/21 12:09:19 - Download XXXX files - Nr files downloaded : 0
2008/11/21 12:09:19 - Download XXXX files - =======================================
2008/11/21 12:09:19 - Load XXXX and codemapping tables - Starting entry [Abort job]
2008/11/21 12:09:19 - Thread[Load XXXX and codemapping tables (Load XXXX and codemapping tables (Thread-4)),5,main] - exec(2, 1, Abort job.0)
2008/11/21 12:09:19 - Abort job - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Aborting job.
2008/11/21 12:09:19 - Load XXXX and codemapping tables - Finished jobentry [Abort job] (result=[false])
2008/11/21 12:09:19 - Load XXXX and codemapping tables - Finished jobentry [Download XXXX files] (result=[false])
2008/11/21 12:09:19 - Spoon - Job has ended.

Thanks

sboden
11-21-2008, 07:17 AM
detailed log when running... you should get more information.

Mathayus
11-21-2008, 07:29 AM
I check detailled log but the result is the same :

2008/11/21 12:20:22 - StringSearcher - Unable to get access to method org.pentaho.di.job.entries.ftp.JobEntryFTP.getTargetFilename() : java.lang.IllegalAccessException: Class org.pentaho.di.core.reflection.StringSearcher can not access a member of class org.pentaho.di.job.entries.ftp.JobEntryFTP with modifiers ""
2008/11/21 12:20:22 - StringSearcher - Unable to get access to method org.pentaho.di.job.entries.ftp.JobEntryFTP.getTargetFilename() : java.lang.IllegalAccessException: Class org.pentaho.di.core.reflection.StringSearcher can not access a member of class org.pentaho.di.job.entries.ftp.JobEntryFTP with modifiers ""
2008/11/21 12:20:22 - StringSearcher - Unable to get access to method org.pentaho.di.job.entries.ftp.JobEntryFTP.getTargetFilename() : java.lang.IllegalAccessException: Class org.pentaho.di.core.reflection.StringSearcher can not access a member of class org.pentaho.di.job.entries.ftp.JobEntryFTP with modifiers ""
2008/11/21 12:21:01 - SharedObjects - Reading the shared objects file [file:///C:/Documents and Settings/SNN/.kettle/shared.xml]
2008/11/21 12:21:01 - Spoon - Starting job...
2008/11/21 12:21:01 - Thread[Load XXXX and codemapping tables (Load XXXX and codemapping tables (Thread-7)),5,main] - exec(0, 0, START.0)
2008/11/21 12:21:01 - Load XXXX and codemapping tables - Starting entry [Download XXXX files]
2008/11/21 12:21:01 - Thread[Load XXXX and codemapping tables (Load XXXX and codemapping tables (Thread-7)),5,main] - exec(1, 0, Download XXXX files.0)
2008/11/21 12:21:01 - Started FTP job to xxx.xxx.xxx.xxx
2008/11/21 12:21:01 - Download XXXX files - Start of FTP job entry
2008/11/21 12:21:06 - Download XXXX files - Opened FTP connection to proxy server [xxx.xxxx.xx]
2008/11/21 12:21:06 - Download XXXX files - set passive ftp connection mode
2008/11/21 12:21:06 - Download XXXX files - set timeout to 0
2008/11/21 12:21:06 - Download XXXX files - set control encoding to ISO-8859-1
2008/11/21 12:23:05 - Download XXXX files - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Error getting files from FTP : Unexpected null reply received
2008/11/21 12:23:05 - Download XXXX files - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Error quiting FTP connection: The FTP client has not yet connected to the server. The requested action cannot be performed until after a connection has been established.
2008/11/21 12:23:05 - Download XXXX files - =======================================
2008/11/21 12:23:05 - Download XXXX files - Nr errors : 1
2008/11/21 12:23:05 - Download XXXX files - Nr files downloaded : 0
2008/11/21 12:23:06 - Download XXXX files - =======================================
2008/11/21 12:23:06 - Load XXXX and codemapping tables - Starting entry [Abort job]
2008/11/21 12:23:06 - Thread[Load XXXX and codemapping tables (Load XXXX and codemapping tables (Thread-7)),5,main] - exec(2, 1, Abort job.0)
2008/11/21 12:23:06 - Abort job - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Aborting job.
2008/11/21 12:23:06 - Load XXXX and codemapping tables - Finished jobentry [Abort job] (result=[false])
2008/11/21 12:23:06 - Load XXXX and codemapping tables - Finished jobentry [Download XXXX files] (result=[false])
2008/11/21 12:23:06 - Spoon - Job has ended.

sboden
11-21-2008, 07:59 AM
So it's while connecting to the server that it fails.

As userid to the proxy it will try to use: "username@targetserver proxyUsername"
As password: "password proxyPassword"

Without the quotes... so try what it gives when you do that manually.

Regards,
Sven