PI is not able to pick the file from the FTP folder

[Former Member]

This is the FILE TO IDOC scenario. We have configured the file adapter. But its not able to pick the file from the specified directory. We have tried changing the transfer mode from Binary to Txt & also we have tried to put advance selection for source file but it didn't work. Its throwing the below error:

PI Adapter Log:

An error occurred while connecting to the FTP server '10.130.150.21:8529'. The FTP server returned the following error message: 'com.sap.aii.adapter.file.ftp.FTPEx: 451 Unexpected reply coderequested action aborted: local error in processing'. For details, contact your FTP server vendor.

Also we have contacted the FTP team & they told that PI is sending an unsupported command. So instead of taking the file TLOG.txt, its treating this file name a s a directory. Please find the logs from FTP end below:

FTP Log:

(207197)2/5/2013 14:48:25 PM - sysisappi (63.130.82.16)> 230 Logged on

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> FEAT

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> 211-Features:

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  MDTM

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  REST STREAM

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  SIZE

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  MLST type*;size*;modify*;

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  MLSD

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  AUTH SSL

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  AUTH TLS

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  PROT

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  PBSZ

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  UTF8

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  CLNT

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)>  MFMT

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> 211 End

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> PBSZ 0

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> 200 PBSZ=0

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> PROT P

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> 200 Protection level set to P

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> CWD /Qas

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> 250 CWD successful. "/Qas" is current directory.

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> CWD SAP_ORION

(207197)2/5/2013 14:48:26 PM - sysisappi (63.130.82.16)> 250 CWD successful. "/Qas/SAP_ORION" is current directory.

(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> CWD Inbound

(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> 250 CWD successful. "/Qas/SAP_ORION/Inbound" is current directory.

(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> CWD IRIIN04

(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> 250 CWD successful. "/Qas/SAP_ORION/Inbound/IRIIN04" is current directory.

(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> CWD TLOG.txt

(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> 550 CWD failed. "/Qas/SAP_ORION/Inbound/IRIIN04/TLOG.txt": directory not found.

(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> QUIT

(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> 221 Goodbye

It should list  *TLOG.txt*  but instead it is trying to get into a directory named  *TLOG.txt*.  same for other interface.

So me & my team is struggling for last couple of days to fix this issue.Please share your suggestion

[Former Member]

In your File Sender have you accidentally put the file name as part of the Source Directory?

The File Name should only be defined in its own parameter.

[Former Member]

No Aaron.Please check the screenshot for complete details.

[prateek]

Try to provide the filename exactly same as the name of the file in the directory i.e., without any placeholder like * and see if it is the same issue.

Regards,

Prateek Raj Srivastava

[Former Member]

Hi ,

>>Can you try once again by putting the exact name of the file in channel.

Now compare the new FTP log with earlier FTP log .

>>If it showing the log as earlier ;then it might be the cache issue.

Regards

Venkat

[Former Member]

Also, what is the PI log tell you, does it show any errors with parameters and correspond with the timings of the FTP server log?

[Former Member]

Please find the screenshot attached of the adapter log.

An error occurred while connecting to the FTP server '10.130.150.21:8529'. The FTP server returned the following error message: 'com.sap.aii.adapter.file.ftp.FTPEx: 451 Unexpected reply coderequested action aborted: local error in processing'. For details, contact your FTP server vendor.

[anand_shankar10]

Hi Sisir,

I can see that you have already tried all possible options.

Kindly try once with a different connection Mode as well.

Put slash "/" in the end of Source Directory.

Regards

Anand

[Former Member]

No, already tried with this option.

[Former Member]

Did you tried accessing the file by connecting to FTP via CMD and able to access the file ?

if not checked try this ?

HTH

Rajesh

[Former Member]

Hi Sisir

The screen shot of your config doesn't seem to correspond to the FTP log. I say this because the * is dropped from file name pattern "*TLOG.txt" (comparing your config and the FTP log). Can you share an updated FTP log?

Sisir Das wrote:
"/Qas/SAP_ORION/Inbound/IRIIN04" is current directory.
(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> CWD TLOG.txt
(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> 550 CWD failed. "/Qas/SAP_ORION/Inbound/IRIIN04/TLOG.txt": directory not found.
(207197)2/5/2013 14:48:27 PM - sysisappi (63.130.82.16)> QUIT

Also, like Rajesh suggested, have you tried to manually check permissions by logging in, traversing the directory, and getting the file?

By the way, we always use backslash \ instead of forward slash in our configs. Not sure this would make any difference for you though. Also, I don't normally use a trailing \ at the end of the source directory path.

[MichalKrawczyk]

Hi,

attach the screenshot of your channel,

Regards,

Michal Krawczyk

[Former Member]

[MichalKrawczyk]

Hi,

can you put / at the end of the source directory just for a check?

Regards,

Michal Krawczyk

[Former Member]

Hi Michal..Already tried but its not working...

[Former Member]

Hi,

Check your communication channel configuration for what you provided the file schema.

thanks,

Satish.