Failed to connect to FTP error on BPC package execution using Process chain /CPMB/IMPORT_USING_FTP

[former_member590808]

Hi,

We have a csv file saved in al11 directory at path /BHD/BHPFTP/BPC/HRIT/ on our BW server. We are trying to load the data of this file in our BPC cube , for this am using BPC package execution with process chain /CPMB/IMPORT_USING_FTP .

When am trying to execute the package post entering all the required details the package is failing with message "Failed to connect to FTP" . I want to know if there is any config that needs to be maintained at BPC front before I execute this package.

Below are the values which am passing for the prompts while executing package :

Package: /CPMB/IMPORT_USING_FTP

Enter FTP user: xyz

Password for above ID: **

File Path to download file from server: /BHD/BHPFTP/BPC/HRIT/Employee_data.csv

Folder Name: Assigning a server folder.

Transformation File: I have created separate transformation file with mapping

Regards,

Neha

[former_member590808]

vadim.kalinin can you please help me in this issue.

[former_member186338 · Accepted solution]

Please use search!

"If your import path is defined in AL11 then just use standard Import from File and use path as defined in AL11."

https://answers.sap.com/answers/339817/view.html

[former_member590808 · Accepted solution]

Hi Vadim,

Thanks for revert.

I checked this answer mentioned by you earlier, but I didn't understand what do you mean by 'import path defined in al11' .

How do we check that and what do you imply with that.

[former_member186338 · Accepted solution]

nehayadav0911

The path you mentioned!

/BHD/BHPFTP/BPC/HRIT/

Look on the sample I have explained in the comments to my old answer.

[former_member590808 · Accepted solution]

Understood! Working in that way.. Thanks Vadim!

Regards,

Neha