Automic Workload Automation

Expand all | Collapse all

FTP Folder names with period

  • 1.  FTP Folder names with period

    Posted 05-10-2018 06:57 AM

    #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



  • 2.  Re: FTP Folder names with period

    Posted 05-15-2018 03:44 PM

    Hi

     

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

     

    ?

     

    cheers, Wolfgang



  • 3.  Re: FTP Folder names with period

    Posted 05-16-2018 01:53 PM

    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.


  • 4.  Re: FTP Folder names with period

    Posted 05-18-2018 05:29 AM

    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