Data warehouse error sending report via to FTP server | Community
Skip to main content
M
myradio_digital
Level 2
April 11, 2021
Solved

Data warehouse error sending report via to FTP server

  • April 11, 2021
  • 3 replies
  • 5351 views

Hi, I'm trying to send a basic report using Data Warehouse to a FTP server (basically is a server in Azure) where it receives files from other sources. I included in the firewall the list of IPs (https://experienceleague.adobe.com/docs/analytics/technotes/ip-addresses.html?lang=en#all-adobe-analytics-ip-address-blocks) but the report seem to fail. Error description: Request failed to send. Please check send parameters and destination connectivity.

 

I've ensured that the login parameters are right using an ftp client and ensuring that I've at least 2GB of free space. The parameters I used are:

host: ip of the host server, lets say 178.178.178.178

port: 22

directory: /load

username: user1

password: pwd1

 

The report has failed and is constantly sending me emails with the notification of the error, how can I stop this? 

The report I created is scheduled for being send just once (send immediately). Can I erase the report so it doesn't appear in the request Manager tab? I don't see any remove button or unsuscribe option anywhere

 

Regards

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by akt0m3r

Hi @myradio_digital,

Could you please clarify if you are using Azure Blob or you have configured the server to work as FTP/SFTP? If it's Azure Blog, you will need to create a ticket with Client Care team to get this done manually. Currently this option is not available via the UI.

 

However, if the server is configures as FTP/SFTP, please note Adobe uses the port 22 for SFTP requests only. If the server don't support secure protocol I would recommend using port 21 instead of 22 for FTP.

In case the server works with SFTP, there is no need to use the password (Adobe don't use Password based authentication for SFTP and require to use SSH key-pair) and you will need to configure your server based on the document: https://experienceleague.adobe.com/docs/analytics/export/ftp-and-sftp/secure-file-transfer-protocol/ftp-sftp-dw.html?lang=en#ftp-and-sftp

 

Hope this explains and clarifies the doubts!

 

 

3 replies

A
amgup
Level 7
April 12, 2021

Hi @myradio_digital  . Have you included the sftp:// before the IP address ? If not than can you please write the hostname as sftp://178.178.178.178 . Since you are using SFTP server so it is mandatory to write sftp:// before the IP address.

    M
    myradio_digitalAuthor
    Level 2
    April 12, 2021

    Thank you for your quick reply, I've tested the request also writing sftp:178.178.178.178 but it also fails. If I try to connect with a tool like filezilla or winscp it works perfectly and I can upload files to the machine. Is there any configuration such as using other ports like the 21 to try to connect to the service? Can it be that the path is not correctly set? --> /load  

     

    akt0m3r
    Adobe Employee
    akt0m3rAdobe EmployeeAccepted solution
    Adobe Employee
    April 12, 2021

    Hi @myradio_digital,

    Could you please clarify if you are using Azure Blob or you have configured the server to work as FTP/SFTP? If it's Azure Blog, you will need to create a ticket with Client Care team to get this done manually. Currently this option is not available via the UI.

     

    However, if the server is configures as FTP/SFTP, please note Adobe uses the port 22 for SFTP requests only. If the server don't support secure protocol I would recommend using port 21 instead of 22 for FTP.

    In case the server works with SFTP, there is no need to use the password (Adobe don't use Password based authentication for SFTP and require to use SSH key-pair) and you will need to configure your server based on the document: https://experienceleague.adobe.com/docs/analytics/export/ftp-and-sftp/secure-file-transfer-protocol/ftp-sftp-dw.html?lang=en#ftp-and-sftp

     

    Hope this explains and clarifies the doubts!

     

     

      M
      myradio_digitalAuthor
      Level 2
      April 12, 2021

      I'm not using Azure Blob storage, the service is a SFTP that is currently using working and I can upload files to it (so at least I know we can access it with SSH-2). I also want to know why is the service sending notifications about the reports that failed even a few days later and they are not scheduled, they are required to be sent immediately.  On the other hand is it possible that Adobe access the SFTP service using the user/password credentials provided or is it mandatory to use a key (Adobe’s authorized_keys file is in the .ssh directory within the root directory of the user you log in with) to access the service. I'm asking this because the idea is to ask for a few reports and I don't know if I have to ask for a different key for each of them or can I operate only with one (Adobe ssh key)?. 

      jantzen_b
      Adobe Employee
      jantzen_bAdobe Employee
      Adobe Employee
      May 24, 2021
      Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?
      Terms & ConditionsAccessibility statement

      Loading footer...