FTP Folder names with period

[KesavanElangovan]

#ra-ftp

There are some external vendors we FTP files to their servers. Some of the vendor's folder names are: 

/ExternalServer/Data.in

/ExternalServer/Data.out

 

In our existing scheduling system, we have the jobs configured as: 

Copy /InternalServer/Folder/File.dat to /ExternalServer/Data.in

 

However, as we converted the above to Automic RA FTP job and tested it, the below error is thrown. 

 2018-05-09 17:47:05             Copying from CONN.FTPAGENT.INTERNAL to CONN.FTPAGENT.EXTERNAL

2018-05-09 17:47:05             copy /NPD/SALE1064.dat to /NPD/express/data.in

4: File cannot replace a directory.

 

We updated the job to: 

Copy /InternalServer/Folder/File.dat to /ExternalServer/Data.in/File.dat 

and successfully test the transfer. 

 

However, not all scenarios are based on single named file. Some of the jobs are 

Copy /InternalServer/Folder/*.dat to /ExternalServer/Data.in

 

How do we get around this without having to have the vendors updated their folder names? is there a solution? 

 

Thanks, 

Kesavan

[FrankMuffke]

Hi

 

what about using a wildcard transfer - e.g. copy /NPD/SALE*.*t to /NPD/express/data.in/*.*

 

?

 

cheers, Wolfgang

[KesavanElangovan]

Negative, got the below error: 

 

4: ERROR:com.maverick.sftp.SftpStatusException: No such file: Mailbox [/data.in/*.*/] not found. com.uc4.ftpjob.DataTransferException:  4: ERROR:com.maverick.sftp.SftpStatusException: No such file: Mailbox [/data.in/*.*/] not found..      at com.uc4.ftpjob.commands.impl.CopyCommand.throwDataException(CopyCommand.java:705)      at com.uc4.ftpjob.commands.impl.CopyCommand.execute(CopyCommand.java:640)      at com.uc4.ftpjob.commands.ThreadPoolJobExecutor$ThreadRunner.run(ThreadPoolJobExecutor.java:86)      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)      at java.util.concurrent.FutureTask.run(FutureTask.java:266)      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)      at java.lang.Thread.run(Thread.java:748) Caused by: java.io.IOException: 4: ERROR:com.maverick.sftp.SftpStatusException: No such file: Mailbox [/data.in/*.*/] not found.      at com.jcraft.jsch.ChannelSftp$1.close(ChannelSftp.java:797)      at com.uc4.ftpjob.commands.impl.CopyCommand.execute(CopyCommand.java:630)      ... 6 more 2018-05-16 13:02:33             Command aborted with error message:  4: ERROR:com.maverick.sftp.SftpStatusException: No such file: Mailbox [/data.in/*.*/] not found.. 4: ERROR:com.maverick.sftp.SftpStatusException: No such file: Mailbox [/data.in/*.*/] not found. 2018-05-16 13:02:33             Job will continue to process commands.

[Carsten Schmitz]

I don't think the period is the problem.

 

The error message says:

 

copy /NPD/SALE1064.dat to /NPD/express/data.in

4: File cannot replace a directory.

 

It tries to copy /NPD/SALE1064.dat to /NPD/express/data.in and NOT to /NPD/express/data.in/SALE1064.dat

 

Please post screenshots of your RA FTP job and especially of the part where source and destination files, or the copy commands are specified. I suspect there is something wrong with the syntax there.

 

I admittedly don't have RA FTP jobs visualized right now, but it may possibly also help to add a slash to the end of the destination, to tell the underlying libraries that you want the target files placed INSIDE OF data.in, and not OVER data.in.

 

Hth,

Carsten