Error connecting to SFTP using File Transfer to collect files.

sonikad8559822

24-09-2018

Hello,

My requirement is to pick a file from SFTP location and then process it.

  • For that I am using, FILE TRANSFER Activity.
  • I had configured SFTP Details in External Accounts.
  • Below is my workflow:

          1578290_pastedImage_6.png

1578291_pastedImage_7.png

  • Now when I run workflow, below error I am getting:

1578296_pastedImage_11.png

So ideally, if File not found in SFTP location, it should go to FILE NOT FOUND flow and end there, as per my workflow, instead it's breaking before step.

Please let me know, how to solve it?

NOTE: One more question to transfer files from SFTP location in Adobe campaign, we should be using ideally File collector or File Transfer activity?

cc : Adhiyan

Accepted Solutions (1)

Accepted Solutions (1)

Amit_Kumar

MVP

24-09-2018

Hi,

From the error it seems, you have not assigned the proper directory+file name to file transfer activity. the error indicates that there is no file name so script considers folder name as file and fails.

you need to ensure that directory does exist and the existence of the file is optional.

The 'Server folder' contains the file path to the file on the sFTP that you wish to import, you will be provided the filename in the ticket. Simply paste in the filename provided after the folder directory (with extension) after '/custom-folder/file-name.csv'

Regards,

Amit

Answers (5)

Answers (5)

sonikad8559822

24-09-2018

We are currently using External SFTP folder, so I will be using FILE TRANSFER Activity as suggested.

So, coming back to the above error screenshot, let me know how to resolve it.

Vapsy

Employee

24-09-2018

Hi,

As stated above Use File Collector if you are trying to download file from Adobe provided sFTP to Adobe Campaign. For any other external sFTP you should use File Transfer.

File Collector is to fetch a file from a directory on the sevrver. As Campaign provided sFTP is basically another directly on the app server it is recommended to use File Collector.

File Transfer on the other hand is there to connect to any external sFTP through connection details provided on external account and then upload/download a file from there.

Regards,

Vipul

Vapsy

Employee

24-09-2018

Hi sonikad8559822,

Use File Collector if you are trying to download file from Adobe provided sFTP to Adobe Campaign. For any other external sFTP you should use File Transfer.

The error looks strange and definitely not the expected behavior.

Out of curiosity, I can see that the workflow says there is 1 file to transfer and then says File not found.

Regards,
Vipul