SFTP connector now saying the provided path does not exist?

Options
Dan Snyder
Dan Snyder
Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper
in SKY Developer General Discussions

Hello wise ones. I have been successfully moving files from our hosted files to Sharepoint to refresh our Power BI reports. However, last week (Thursday or Friday) it started to not run with the error that my provided path in my SFTP-SSH trigger does not exist. It is just the path to the folder where all my files are added by Queue and yes, the files are exporting from Queue correctly.

My password that resets every 45 does does not expire until next week, but I readded it to the connection just in case. I tried deleting and re-adding the trigger, no luck. While I can use this as an excuse to move some of these over to the new Query API, many of them are created by exports in database view (not query output) so I would still like to use this process.

I have a flow that uses another folder within my hosted files and that still works. Any ideas?

Tagged:

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Dan Snyder
    i'm not using sftp anymore as i have fully turnover to Query API. So can't really speak to if there is a general ftp issue or not, however, since you said another flow is working fine then it is not a general server side issue.

    You can try to determine what is the differences between the 2 flows:

    are they using same exact connection?

    are they doing same thing? (trigger by sftp file change or just connect and get file)

    any screenshot of error and error message (the exact message, did you try kb on the error?)

  • Dan Snyder
    Dan Snyder
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Alex Wong

    Here is the PA error and also showing that the path does exist. Now this morning I got a 504 Bad Gateway with Request to the SFTP server has taken more than '00:00:30' seconds. error message.

    2b9c320c10a173932f92c132b0f6e48c-huge-im
    PA error
    ebb54c79c6575111087fc946ff214e71-huge-im
    File location does exist


  • Carol Grant
    Carol Grant
    Seventh Anniversary Kudos 3 Name Dropper Participant

    @Dan Snyder- I was just remembering Blackbaud had that change in Oct 2023 that is in this KB Article about removing /C:/FTPHome from your path in Power Automate to grab files.

    I can't see your file path but make sure that it looks something like this:

    4b62a6ece66d4090d2b07a8b157b73c8-huge-im

    (taken from the KB article- not mine)


  • Dan Snyder
    Dan Snyder
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Carol Grant
    Thanks, yes I did make that change when it was necessary.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Dan Snyder
    You said a flow of yours is working, was it going to the same folder ?

    I see your screenshot is pointing to ……./Power BI

    is it ……./FTP/Power BI or ……/Power BI?

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Dan Snyder
    also instead of “typing/copy/paste" into the Folder field, try to “navigate” to it:

    a524d5e5b921ebbb1d0b02a1ce2bbb74-huge-im
    0ee5befe69220a3b1a227c5eca8e17e3-huge-im
    c9234a58dc2af709fe6183a6cb6eaa2f-huge-im
    75eb7cf5e63863529d529e4b36fbd3cf-huge-im
  • Dan Snyder
    Dan Snyder
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Alex Wong
    The flow that is working is going to the general FTP folder while this is a separate folder, just …/Power BI.

    Also, when I go to navigate to the folder as you suggested, the Power BI folder does not show up so there must be a permissions thing going on.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Dan Snyder
    permission maybe.

    You can check this by using a standalone sFTP client (i.e. FileZilla) and login using the username/password that you use on the SFTP PA flow connection object and see if the Power BI folder shows.

    Also possible that sFTP can only see folder inside the FTP folder. That's where I put subfolder for my sftp work before, everything inside the FTP folder.

  • Dan Snyder
    Dan Snyder
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Alex Wong Thanks for asking those questions. I nested the Power BI folder within the FTP folder and that seemed to have fixed the issue. Still need to update to using Query API, but for those others I think you have solved the issue for now!

  • Carol Grant
    Carol Grant
    Seventh Anniversary Kudos 3 Name Dropper Participant

    @Dan Snyder- this started happening to me last night with my files and I have my folders inside the FTP one. It ran yesterday at 2pm then tried to run again this am. It wasn't just you.

    d272840b633883ed720edb52344ac8df-huge-im


  • Dan Snyder
    Dan Snyder
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Carol Grant Good to know and at least it is an easy fix. You're welcome customer support, @Alex Wong has provided the answer for all of today's cases. ?

Categories