cancel
Showing results for 
Search instead for 
Did you mean: 

SFTP Sender channel issue

former_member200386
Active Participant
0 Kudos
991

Dear Experts,

I am working in SFTP to file scenario. where i need to pick all .csv files from source SFTP server . In the SFTP channel configuaration source parameters  i mentioned filename as *.csv then i am getting error.

Exception received: java.util.regex.PatternSyntaxException: Dangling meta character '*' near index 0 *.csv ^
Directory under file Path returned 3. These include directories and links.

please find the screen shots for more reference.

Thanks & Regards,

Pavan

View Entire Topic
gagandeep_batra
Active Contributor
0 Kudos

Hi Pavan,

did you try with * also,

check once that ,

i think *.CSV should work.

in our case it work like that:

Regards

Gagan

former_member200386
Active Participant
0 Kudos

Hi Gagan,

Thank you very much for your help. I tried with '*' only , then SFTP channel started polling. Issue resolved.

Thanks & Regards,

Pavan

former_member278111
Participant
0 Kudos

Hi,

I am unable to pick the files from SFTP server in PI 7.31.

Sender channel is working fine with green status & below is the message which i received in RWB channel monitoring.

Does any one came across this issue?

Thanks & Regards

Anil Kumar

Former Member
0 Kudos

Just in case someone wonders why *.csv cannot work:

In the SFTP-Adapter you got to use a regular expression, not a commandline filepattern as in the file adapter.

Meaning, to select all csv files, you got to enter: .*\.csv

. = any character

* = any occurrency

\. = a period

csv = csv

Check your regex for example with Regex Tester

Actually, I wonder why plain * works, but that's a different story.

Former Member
0 Kudos

it works man, thanks a lots

Former Member
former_member278111
Participant
0 Kudos

Hi,

Issue got resolved by applying latest patch of SFTP adapter.

Thanks & Regards

Anil Kumar