Skip to Content
0

File to File Scenario

Mar 17, 2017 at 10:13 AM

122

avatar image

I have a scenario in which a CSV file is created by SAP and resides on a server.

Whenever this file is created, I need to move this file to a SFTP server, using SAP PI in between.

SAP PI version is 7.1.

I tried this link http://www.saptechnical.com/Tutorials/XI/File2File/Demo1.htm, but could not complete the scenario.

Any guidance would be helpful.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Iñaki Vila Mar 17, 2017 at 10:33 AM
0

Hi Ather,

Do you have any problem or exception?

AFAIK SAP SFTP adapter is available since PI 7.1 EHP1 sp 08. Can you see the adapter when you choose one in the communication channel monitoring?

For SAP SFTP adapter this link will be helpful for you

https://assets.cdn.sap.com/sapcom/docs/2015/08/c28709e4-557c-0010-82c7-eda71af511fa.pdf

Regards.

Show 13 Share
10 |10000 characters needed characters left characters exceeded

Hi,

Thank you for your response.

No, I cant see the adapter.

The problem in the link I followed was, that when I created Interface Determination, I could not add any Receiver Interface (Error: Specify at least one inbound interface). I thought no design objects were required.

Is there any workaround?

0

Hi Ather,

You have to set in the receiver business component the interface, a dummy one it is not necessary that the interface is in the ESR because i suppose you dont want any mapping.

However, you scenario is not possible if you client don't upgrade the PI or it purchase a third party adapter like this

https://www.advantco.com/product/adapter/sftp

In a old PI 7.0 i did a java mapping to connect via SFTP.

Regards.

0

Hi Inaki,

I could not get what you mean by "You have to set in the receiver business component the interface, a dummy one it is not necessary that the interface is in the ESR".

Yes you are right, I dont need any mapping.

I will see how to do this via Java Mapping.

Regards

0
0

This is what I have created in the Integration Builder

My Business Component looks like this

I have added dummy and namespace to it. To be sure, i dont have to create any thing in ESR?

0

File is being picked up from my server, but not created on FTP site.

0

This is the error I am getting now in CC

Error when getting an FTP connection from connection pool: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: FTPEx: Unexpected reply code2.0-7.26 FlowSsh:

0

Hi Ather,

Which type of Connection Security level have you chosen in your CC?

Have you tried to change it?

Regards,

Andrzej

0

I am using this

When I check 'User X.509', it makes mandatory to add Key Store and Private Key.

cc-security.png (4.1 kB)
0

Please leave 'Use X.509' option unchecked.

Have you tried to change Connection Security level to 'FTPS (FTP Using SSL/TLS) for Control and Data Connection'?

Regards,

Andrzej

0

Yes, tried your setting

This is the error again

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when getting an FTP connection from connection pool: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: FTPEx: Unexpected reply code2.0-7.26 FlowSsh: Bitvise SSH Server (WinSSHD) 7.28

Regards

0

Could you use an XPI Inspector please? Maybe you will get more details from its trace.

Regards,

Andrzej

0

I will have to ask BASIS to do that. In the meantime, I saw this link

https://blogs.sap.com/2010/04/13/how-to-configure-ftps-in-file-adapter/

I haven't configured this yet.

0
Andrzej Filusz Mar 17, 2017 at 10:35 AM
0

Hi Ather,

I recommend you to read the documentation of file and SFTP adapters on help.sap.com. Then try to search this forum to find example/ similar scenarios. This approach will be also useful when you encounter any problem/issue. If you wouldn't be able to find a solution for your problem/issue then please post a message here. But in a such case please try to describe your problem in details and ask a specific question.

Regards,

Andrzej

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Maybe I did not explain the problem properly, but as I mentioned in my comment earlier, we don't have an SFTP adapter, and installing is not an option (Will have to upgrade PI version too), so there is no point in reading SFTP documentation.

As for the file adapter, this is what I tried with, as you see in the link I mentioned in my question.

I followed this link too https://archive.sap.com/discussions/thread/3257823, and in test configuration, i got error in Receiver Determination

Runtime error Message is incomplete. No Sender found
0