file not picking

[Former Member]

Dear Team ,

hi ,

i have a scenario of file to rfc in which i have to pick files from the location which is not in the Domain but the same path can be accessible by pi server 7.0 with user authentication

kindly let me know what are the steps to be followed while configuring File sender adapter for this Requirement

note : if i given the path in the domain the file is getting picked properly

with Regards

Srinivas

[Former Member]

Srinivas ,

check the authorizations on file also..

It should have write 777 authorization..for read write and execute.

Regards ,

[Former Member]

dear santhosh ,

its an windows system and i have given full authorisation for file but even though it is not picking the file

note i have changed data connection to passive

regards,

Srinivas

[Former Member]

Hi Srinivas ,

Lets go step by step :

1.

dataconnection -active

---> make it passive

connection security -none

username -ftp

password -password

connectionmode -permenantly

-

---

> make it on connection basis

transfer mode -binary

2. Try to connect to the FTP site from url only from your PI box ...from operating system level...

like ftp://server:port

It should ask for ID and password..

later on passing the values it will show the the file in your browser window.

If this didn't works..it means the connection is not able to setup from PI box to FTP site..

else there is possibility of authorization issue with file.

Regards ,

[Former Member]

dear santhosh ,

i have checked as u said and it is working fine

note : i have changed source path as //172.32.0.56/mrpl/ and file name as *.xml

data connection -passive

connection mode -perfile transfer

transfermode - binary

regards,

srinivas

[Former Member]

So is the interface working now ?

wot is the situation ?

Regards ,

[Former Member]

no santhosh , its not working

i mean to say that from os level as u said i can access the file from PI server

[Former Member]

Srinivas ,

1. Make sure that you are hitting the right directpory for pikcing the file

2. file name should be exactly same...It is case sensitive

3. Please copy paste the full error log of RWB .

Regards ,

[Former Member]

Dear santhosh,

kindly check the communicational channel monitoring error

Processing started

12/21/09 12:16:51 PM Retry interval started. Length: 30.0 seconds

12/21/09 12:16:51 PM Error occurred while connecting to the FTP server "172.32.0.56:21": java.net.ConnectException: Connection timed out: connect

12/21/09 12:16:30 PM Processing started

12/21/09 12:16:21 PM Retry interval started. Length: 30.0 seconds

12/21/09 12:16:21 PM Error occurred while connecting to the FTP server "172.32.0.56:21": java.net.ConnectException: Connection timed out: connect

12/21/09 12:16:00 PM Processing started

12/21/09 12:15:50 PM Retry interval started. Length: 30.0 seconds

12/21/09 12:15:50 PM Error occurred while connecting to the FTP server "172.32.0.56:21": java.net.ConnectException: Connection timed out: connect

12/21/09 12:15:30 PM Processing started

with regards,

Srinivas

[Former Member]

Srinivas ,

Pls check below notes :

Note 1085539 - XI JDBC/FTP connection Test and XML Validation Application

Note 1052867 - XI / PI File Adapter: Known Problems / Incompatibilities

Regards ,

[Former Member]

Hi,

Are you able to connect to the ftp server manually with credentials provide by you.

Also in the source directory path you need not mention as
172.32.0.56... you need to mention this only in the server name

Jus the folder is enough

aand in the file name you specify *.xml

Regards,

Nithiyanandam

[Former Member]

Hi Srinivas,

After going throgh the above discussions,

I think FTP port for your SAP XI system is not opened.

Login to XI System and check wither it is connecting to that FTP server

use telnet ipaddress port.

If that is problem ,then try to open the port and test it once again.

Thanks&Regards

Sridhar Goli

[Former Member]

dear sridhar ,

thx for your answer i have checked through command prompt in xi server

telnet 172.32.0.56 then i have got a message that

couldnot host connection to the host on port 23 : connection failed

kindly let me know whether to access files from FTP we need to have access to telnet port

so that i can make a request my nw team to open the ports

regards,

srinivas

[Former Member]

Srinivas ,

Telnet's default port is 23.

you have to check it for port 21.

Sridhar correct me if wrong..

Regards ,

[Former Member]

Hey Srinivas,

Test the telnet with the ipaddress and port ( in ur case it is 21)

Santosh, you are correct....

If you get the same problem with the port 21also, means you have to ask the Network team/NW team to open the port for XI system.

Once u open the port run the scenario.

Regards

Goli Sridhar

[Former Member]

Goli/Sridhar ,

Goli, I already asked srinivas to get FTP connection check from PI box...and it worked .

how it is different from checking the FTP connection from command prompt ?

Regards ,

[Former Member]

Dear Sridhar / santhosh

kindly let me know whether to access files from FTP we need to have access to telnet port

so that i can make a request my nw team to open the ports

thanks a lot for your valuable inputs

regards

Srinivas

[Former Member]

Hi,

Check the ftp folder have all access rights( write,read,delete)...

and change the dataconnection to passive..

Regards,

Prakasu.M

[Former Member]

Hi,

You need to go with ftp..If file in the local system(with in XI system) then that time only NFS protocol will support.

Regards,

Prakasu.M

[Former Member]

Hi,

if u are able to connect to the ftp server (not in domain) using PI server then you can configure the same details used during testing...can be given in the FTP sender adapter...

Do post if you are having problem in connecting the same via adapter...

HTH

Rajesh

[Former Member]

Hi Srinivas,

Let me know if u have populated the following fields in the INtegration Builder(Content Conversion Tab)

1. row.fieldNames

2. row.fieldSeparator

3. ignoreRecordsetName

[Former Member]

i am not using any content conversion

[Former Member]

Dear Rajesh

i am using

Transport protocol - FTP

message protocol - file

adapter engine -integration server

File access parameters

source directory //172.32.0.56/mrpl/*.xml

file name - *.xml

ftp connection parameters

server 172.32.0.56

port 21

dataconnection -active

connection security -none

username -ftp

password -password

connectionmode -permenantly

transfer mode -binary

kindly let me know am i doing any wrong config

with regards

srinivas

[Former Member]

Srinivas ,

Rajesh ....has given valuable inputs ,

other than that :

1. Plz check file name

2.--->i have a scenario of file to rfc in which i have to pick files from the location which is not in the Domain but the same path can be accessible by pi server 7.0 with user authentication

when file can be accessed by PI with user authentication inside/outside domain ...there should not be any issue..Plz chjeck the logs in RWB .

Pbponikhil ,

what type of answer was that....How FCC is related to picking of file..Can you explain ?

Regards ,

[Former Member]

dear santhosh

in RWB in component monitoring of RWB i am getting following error

Error occurred while connecting to the FTP server "172.32.0.56:21": java.net.ConnectException: Connection timed out: connect

with regards,

Srinivas

[former_member187339]

Hi Srinivas,

I guess the source directory should be

>>source directory //172.32.0.56/mrpl

and not

>>source directory //172.32.0.56/mrpl/*.xml

Regards

Suraj

[Former Member]

Hello

There can be a couple of reasons why the FTP server is not accessible:

1) The pi server connects to the ftp but due to a network failure is unable to complete connection

--please use a third party ftp tool such as cereberus to test the connection. It allows you setup a connection from your position in the network and connect to the ftp folder.

2) there is some network congestion or authority issue. The ftp user might not have the authorization, the tool can help you with that as well.

3) the file format may not be properly defined in the string type- the fields etc-