FTP connect issue while loading data to bpc

[Former Member]

Hello All,

I am using a standard package /CPMB/IMPORT_USING_FTP to pull the data from FTP. I am getting the error Unable to coonect FTP. Where as we can connect successfully from backend NW and can extract the data. Is there any specific setting we need to do for this package?

Regards,

[former_member186338]

Please ask your network administrator to check packets between BPC server and ftp server...

Vadim

[Former Member]

Thanks Vadim for your response.

Our network team responded that there is no packet loss between both the servers. Also using the same FTP, we are taking the files in SAP BI and ECC. Where as in case of BPC i am getting the error attached in my initial thread.

Regards,

[former_member186338]

I am not talking about packet loss, I am talking about packet analysis using tool like Wireshark - during the negotiation between bpc server and ftp server.

Vadim

P.S. The attached error provide no information - just generic - unable to connect!

[former_member186338]

Sample - successful FTP import:

Vadim

[Former Member]

Thanks Vadim,

I have asked my network team to check on this.

Is there any Advance script we need to modify or does the package work in a standard way to load the data in BPC from FTP?

Do we need to perform any settings on BPC side to make this work.

Regards,

[former_member186338]

Absolutely standard:

PROMPT(TEXT,%FtpUser%,"Please enter ftp User ",)

PROMPT(TEXT,%FtpPassword%,"Please enter password ",PWD)

PROMPT(TEXT,%FtpSourceFile%,"Please enter File path to down load from Ftp site",)

PROMPT(OUTFILE,%DestinationFolder%,"Please enter Folder name to Put into server",)

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",1,{"Overwrite records with match key","Replace data in same data region of Entity, Category, Time and Audit ID"},{"1","2"})

PROMPT(RADIOBUTTON,%PREPROCESSMODE%,"Handling of duplicate records in source",0,{"Pre-aggregate records with same key records in source file","Last record wins in case of duplicate keys in source file"},{"0","1"})

PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%KEYDATE%,)

TASK(/CPMB/FTP,FTP_USER,%FtpUser%)

TASK(/CPMB/FTP,FTP_PASSWORD,%FtpPassword%)

TASK(/CPMB/FTP,FTP_DOCNAME,%FtpSourceFile%)

TASK(/CPMB/FTP,FTP_DESTINATION,%DestinationFolder%)

TASK(/CPMB/CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/CONVERT,SUSER,%USER%)

TASK(/CPMB/CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/CONVERT,SAPP,%APP%)

TASK(/CPMB/CONVERT,FILE,%DestinationFolder%)

TASK(/CPMB/CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/LOAD,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/LOAD,PREPROCESSMODE,%PREPROCESSMODE%)

TASK(/CPMB/LOAD,TARGETMODE,%TARGETMODE%)

TASK(/CPMB/LOAD,KEYDATE,%KEYDATE%)

[former_member186338]

P.S. I have tested ftp load with my PC - just enabled ftp server in Windows settings and placed test import file in the root folder of ftp server:

Vadim