× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi All

We are using Scott Klement's FTPAPI as the foundation for a generic routine to retrieve CSV files and after working perfectly for months we're now experiencing a strange problem that appears to do with file sizes.

The process we have in place will retrieve a file and then use the FTP_Rename procedure to append a '.done' to the name before it calls a validation routine. If any errors are detected in the file then the file is renamed a second time and the '.done' replaced with '.error'. This process has worked since it was introduced, however, while testing a new interface a colleague is having the problem where the first rename is successful, however the second fails.

I have debugged the FTP_Rename procedure and at the point the SendLine procedure is called for the RNFR command a -1 is returned. The joblog, however, doesn't record any information other than showing the RNFR command that was sent and the usual "350 Pending further information" is not displayed. Stepping through the SendLine and subsequent tsend procedures shows a return code of -1 being returned by the send() procedure.

The file is 28,854KB in size and contains 51,136 records, but if I reduce the number of records in the file it will rename successfully which makes me think it's size related. However, as the initial rename works successfully I wonder how this can be the case. Has anybody using the FTPAPI come across a similar thing before or do you know if there is any limitation with the send() function? I'm struggling to find documentation to the send() function so any advice would be gratefully received.

Thanks in advance
Jonathan

________________________________
Proud partner of The Ageas Bowl and the Ageas Salisbury International Arts Festival.

Registered Address: Ageas House, Hampshire Corporate Park, Templars Way, Eastleigh, Hampshire, SO53 3YA Registered Number: 354568 England

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority

This e-mail together with any attachments are intended for the addressee only and may be private and confidential. If you are not the intended recipient, or the person responsible for delivering it to the intended recipient, you must not open any attachments, or copy, disclose, distribute, retain or use this e-mail, including any attachments, in any way whatsoever; please return it to us immediately using the reply facility on e-mail.

Consider the environment and think before you print this email.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.