Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Error connecting to SFTP using File Transfer to collect files.

sonikad8559822
Level 2
Level 2

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

1 Accepted Solution
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

6 Replies
Vapsy
Employee
Employee

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

sonikad8559822
Level 2
Level 2

Vipul Raghav can you please specify which scenario I should be using File collector and File Transfer? And which purpose each one is for?

sonikad8559822
Level 2
Level 2

Vipul Raghav​,  Could you make out the error? I was confused with it. As not able to figure out is linking between SFTP and ACM is done properly or not.

Vapsy
Employee
Employee

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

sonikad8559822
Level 2
Level 2

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.

Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post