File to File (as400) error 501 unexpected reply codeUnkown extension

[Former Member]

Hi

i have a scenario (as400) file to file , but when my communication channel sender trys to conect to the as400 ftp, i get the following message in the communication channel monitoring.

An error occurred while connecting to the FTP server '10.XX.X.XX:21'. The FTP server returned the following error message: 'com.sap.aii.adapter.file.ftp.FTPEx: 501 Unexpected reply codeUnknown extension in database file name.'. For details, contact your FTP server vendor.

first time doing this scneario, could it be beacuse a ineed to have in message protocol "file content conversion" or could it be that the ftp problem?

any body has a information how should it be the connection or any example.

Regards.

[iaki_vila · Accepted solution]

Hi Erick,

As far as i know in as400 ftp protocol the file extension is mandatory.

Check these links:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/18974dd3-4d38-4ee9-bb69-295a3f108d83/cannot-...

http://dillieodigital.wordpress.com/2010/10/22/ftp-501-error-woes-with-ssis-and-as400/

Regards.

[manigram]

Hi,

"Unexpected reply codeUnknown extension in database file name"

Check the file extension  which you configured in Channel and what is the file which is avilable in FTP folder.

Ex: In channel file name you specified is test.csv

In FTP folder the file extension is some other , other then .csv.

Regards,

Manigandan

[former_member1229124]

Hi Erick,

FTP error code 501 is related to Syntax errors in Parameters or arguments.

As per the error message you got 'com.sap.aii.adapter.file.ftp.FTPEx: 501 Unexpected reply codeUnknown extension in database file name.' there should be error in the file name scheme given correctly in the File access parameters section, check and correct it.

Regards,

Pranay