FTP enterprise stage error

suryadev · Post by **suryadev** » Tue Nov 30, 2010 1:07 pm

Designed a job using FTP stage to read the files from a remote server.

It worked properly i.e read all the records and loaded in the DB on Development server

Now I imported the same job to another Information server i.e (development to test),In this test environment the job aborts with an error

FTP_User_psv: uri : ftp://HT2:21/user_information.psv is not valid remote file.

please suggest me any changes required

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Nov 30, 2010 1:12 pm

Can you do the ftp manually from your test box? You will usually get more information from the error messages generated by the ftp command at the O/S level.

However, in general it looks like it is saying the it can't see that file on the HT2 box.

suryadev · Post by **suryadev** » Tue Nov 30, 2010 1:22 pm

Thanks,

So you mean to say do manual FTP from the remote server to test server?

It is working on Development server with the same information,Is there anything to do on the test server.

ftp://HT2:21/user_information.psv
when I copy this url on in the explorer a prompt came and adked username and password.

After that I can view the data in the file,so the path is right but cannot read it through FTP enterprise.

Actually I used two FTP enterprise stage,does that make any difference?

ray.wurlod · Post by **ray.wurlod** » Tue Nov 30, 2010 1:23 pm

Can your test machine "see" HT2 machine? Is port #21 open?

suryadev · Post by **suryadev** » Tue Nov 30, 2010 1:24 pm

@ray,

how can I test the machine?

please let me know?

vinnz · Post by **vinnz** » Tue Nov 30, 2010 2:23 pm

suryadev, as suggested by Andy - you should try command line ftp from your test UNIX machine. Google for 'unix command line ftp' and you should get all the examples you need.

suryadev · Post by **suryadev** » Tue Nov 30, 2010 3:12 pm

yes,
used the command on test machine

ftp HT2

it says unknown host, but when I give the IP address it asks me for login name and password.

so do I need to use IP address in the path of the FTP stage in place of HT2.

please let me know!!

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Nov 30, 2010 3:18 pm

Have your unix administrator put an I.P. entry in /etc/hosts for HT2. Then your stage should start working.

suryadev · Post by **suryadev** » Tue Nov 30, 2010 3:44 pm

Actually I did not ask him to put an IP entry for HT2 but still its working as I replaced the IP address in place of server name in the path.

If the admin does that can I give the server name in the path?

another issue which I am facing now is there are two ftp stages in my job.

one is working and the other one gives me the below error.

FTP_user_summary,0: processing failed for output /tmp/aptfc2.4087.4cf56e3f.0, $pftpFifoConn: exit status = 255.FTP_user_summary

what causes this error?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Dec 01, 2010 8:34 am

1) Yes, if he puts an entry in /etc/hosts you can then use server name instead of IP address in the ftp stages.

2) No idea - did you try the FTP manually at UNIX level to see what happens? If I had to guess, I'd think the ftp connection is getting closed, but no idea why.

suryadev · Post by **suryadev** » Wed Dec 01, 2010 10:27 am

Thanks,

1) He has to put an entry in /etc/hosts for HT2 in my test server.

will let him know.

2)can 2 ftp stages used in one job?
there is space in the name of the file is that a matter?
i.e

Code: Select all

fgu user summary.psv

suryadev · Post by **suryadev** » Thu Dec 02, 2010 4:45 pm

1) admin has entered the IP and server name in host and that works.

2) removed the spaces from the name of the file ,can read the data now from the remote file.