Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

GetSFTP error

Highlighted

GetSFTP error

New Contributor

62936-getsftp-error1.png

62937-getsftp-config2.png

Can anyone pls help to solve the below error.

File has complete permission

-rwxrwxrwx. 1 root root 120801311 Mar 15 06:32 kafka_experiment.csv

still im getting filenot found error while i try to get the data from remote machine.

and i tried all the ways to give remote path different way.

9 REPLIES 9

Re: GetSFTP error

@hema moger Any reason why you are using a back slash in the path?

Re: GetSFTP error

New Contributor

there s no specific reason for that, i am just trying all possible ways wheather it will work or not @Sandeep Nemuri

Re: GetSFTP error

New Contributor

HEma,

Can you correct remote path...

It should /root/template_writing/kafka_experiment.csv

Re: GetSFTP error

New Contributor

It's giving the same error.

Re: GetSFTP error

@hema moger can you please do a pwd and see the actual path where the file is present?

Re: GetSFTP error

Master Guru
@hema moger

It appears your GetSFTP processor configuration is wrong. You entered the filename in the "Remote Path" field, so the processor is treating that filename as part of the directory path and then trying to look for all files within that complete target directory path.

If you only want the processor to consume that 1 file, try setting that file name in the "File Filter Regex" instead:

64706-screen-shot-2018-03-19-at-10221-pm.png

Thank you,

Matt

Re: GetSFTP error

New Contributor

@Matt Clarke

I tried the above setting file filter regex,but still its giving could not find the file on remote path.i am not understanding this how to solve.

but manually if i do sftp on nifi running machine its connecting to remote machine.

kindly help.

Re: GetSFTP error

Master Guru

@hema moger

Make sure you do not have any leading or trailing whitespaces in either the "Remote Path" or "File Filter Regex" property values.

Can you share some screenshots of you connecting manually from command line on the nifi server to this SFTP server?

Once connected execute following:

pwd

cd \root\template_writing

ls -latrh

Thank you,

Matt

Re: GetSFTP error

New Contributor

@hema moger please could you supply the answer i.e. what worked for you to be able to resolve this error.