on 01-14-2014 12:53 PM
Hi,
I've configured the FTP sender adapter. After activation if gives an error in communication channel monitoring.
“……An error occurred while connecting to the FTP server '[ip-address:port]'. The FTP server returned the following error message: 'com.sap.aii.adapter.file.ftp.FTPEx: 500 Unexpected reply codeNLST command failed'. For details, contact your FTP server vendor…..”
The logon credentials are OK, i'm sure of that.
I've also tried various changes in settings:
Every setting gives same result.
According to WIKI the 500 series means: "....Syntax error, command unrecognized and the requested action did not take place....."
Anybody has any idea what could be wrong here?
kr
Robert
Hi,
Do ftp from your PI server OS level to Source FTP server.Check whether you are able to FTP without any issues.
>>telnet yourPIserverhostname/IP
give the credentials
>ftp sourcefileserverhostname
give credentials
If you couldn't able to login ,then check with them whether their file server is available or not ,if it is available then ask them whether telnet service is enabled in their file server or not .If it not enabled ask them to enable it .
Regards
Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkat,
I've talked to Basis, they indicate that there is no connection from the PI server to the FTP server.
Basis say " getting host unknown "
But the strange thing is there are other FTP comms channels (receiver) that show no error.
So only the sender FTP comms channel is bothered by the no connection.
Regards
Robert
Hi all,
A bit later and we have found the problem. The FTP server was not able to connect to PI properly because it had an out-of-date software version of Cerberus FTP on it. This worked fine for PI to deliver the files, as was done in existing interfaces, but it just couldnt handle the NLST command that PI used to pick the files which was required in this interface.
So we ended up with a file interface and some script to get it to us.
Thx for all the reactions, and a lesson learned for the future
Regards
Robert
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you try with "/" in the source directory.
Seems like the directory format is different for LIST and NLST.
Hi Hareesh,
I tried your suggestion.
It gives a new error. The number is 550. Full text:
"....An error occurred while connecting to the FTP server '10.100.6.52:21'. The FTP server returned the following error message: 'com.sap.aii.adapter.file.ftp.FTPEx: 550 Unexpected reply codePath does not exist'. For details, contact your FTP server vendor....."
kr
Robert
Hi,
First of all as Hareesh mentioned you should to check the permissions of the OS PI user in the ftp server.
Do you have any reason to use the active data connection?, as far as i know the passive mode is the default. You are transferring a csv file then you can try also with the text transfer mode.
Regards.
Hi Iñaki,
I'll ask the FTP owner to recheck the FTP user. Unfortunately he is not the most cooperative person that i ever met. 😞
As i mentioned above there are other FTP channels (receiver) that have the same settings. They show green in the Comms Channel monitoring. So i just copied the settings to my new (sender) channel.
I've already changed it back to passive now, but still the error persists.
Kr
Robert
Hi,
Here is a screenshot of an ftp session.
User is same as used in PI.
So the user seems to have sufficient rights to get the files.
Still in the Comms Channel Monitoring the original error is still coming back:
'com.sap.aii.adapter.file.ftp.FTPEx: 500 Unexpected reply codeNLST command failed'
Any fresh ideas are much appreciated.
Kr
Robert
Hi
From the testing screen above , it looks that you are able to FTP to the location using the password.
Once you are in FTP location , can you give pwd and check in which location you are landing .
It looks like the remote FTP person needs to check the permissions on the root location ( / ) for your FTP Connect user.
Thanks
Rishi
Hi Den - Please try with "." for the target directory
Came across an interesting thing. May that might be the issue.
In the XI FTP communication channel is not possible to left “Target Directory” field empty. Command CWD will be called and it is not possible to skip it. Instead of the root directory symbol “/” it is possible to put current directory symbol “.” to the “Target Directory” field. In such way file will be uploaded / downloaded from the default directory and there is no call to the root directory of FTP server. Command “CWD .” doesn’t raise an error.
Source : http://xitricks.wordpress.com/2010/07/12/ftp-change-working-directory/
Also SAP Note :821267 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 File Adapter
FTP: Directory Specification / CWD Command
Message was edited by: Hareesh Gampa
Hi all,
Thx for your input. Unfortunately the problem is still with us.
My colleague yesterday had a suggestion which seemed to make sense. Apparently the FTP user from PI issues a "mget" command to the FTP server.
When we simulated this we got the following:
So the same message "NLST command failed" is returned here.
I asked the FTP admin about this, but he checked the ftp-user and said that the user has the authorization to issue the "mget" command. So that seems to be a dead-end for now.
I also tried substituting "/" with "." , but that didnt help.
I checked Michael's blog but all his suggestions are met i believe.
How can i find out more about exactly what PI does, how it approaches the FTP server?
Are there any documents regarding this? Is there a way to get a more detailed logging than we get in comms channel monitoring?
Regards
Robert
Hi Holt,
It seems that you have find the problem, that kind of FTP server doesnt support correctly the multiple get (files) command.
There is a reference in the point 36 in this note 821267 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 File Adapter
Try this workaround: 1052867 - XI / PI File Adapter: Known Problems / Incompatibilities
Regards.
Hi Inaki,
I think point 36 references a different problem, i.e. frequent polling, which is not my current problem.
I tried the workaround with the exclusion mask but no help there either.
I still suspect the authorizations to be an issue, and/or that the source directory should be a subdir instead of the root. However both issues need to be dealt with by the FTP administrator. Alas, not the easiest or most available person to work with.
I'll keep trying however and will succeed in the end, i'm sure,
Regards
Robert
What is your PI version?
Can you please go through the note 821267 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 File Adapter to understand the difference b/w NLST and LIST commands..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hareesh,
We're on PI7.1 EHP1
From question/answer 27 in the note i conclude that a LIST command was issued, then the result was not parsable and PI does a fallback to the NLST command.
I'm not very knowledgable in FTP though.
So i'm still unable to see what must be done now.
Is there some issue with the configuration of the PI that we can fix?
Or is there some issue with the FTP server that we look at?
Regards
Robert
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.