OOPS:ftruncate error; script fails

Advertisement

sllynch
Joined:
Posts:
2
Location:
Arlington, VA

OOPS:ftruncate error; script fails

I have a simple WinSCP command in a SQL SSIS package to transfer 2 files to a remote server. When executing the package, frequently I'm getting OOPS:ftruncate errors, either for both files or just for one. What does this error signify? Most recent log is attached. If it's relevant, the .csv file I'm transferring is around 650 K; the .txt file only 1 K. Thanks!
  • winscp.log (6.78 KB, Private file)

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
33,008
Location:
Prague, Czechia

Re: OOPS:ftruncate error; script fails

The error comes from the server.
What is /integrations? Is that a regular file system? Or something special?
Can you upload the file using any other FTP client?

Reply with quote

sllynch
Joined:
Posts:
2
Location:
Arlington, VA

Re: OOPS:ftruncate error; script fails

martin wrote:

The error comes from the server.
What is /integrations? Is that a regular file system? Or something special?
Can you upload the file using any other FTP client?

/integrations is a subdirectory on the remote server; that's where the files are supposed to be dropped. Yes, I can upload using Filezilla, and can <sometimes> upload using my SSIS package. For what it's worth, below is a sample of a Filezilla session; I log in, switch to /integrations, and then drag & drop the two files. Sometimes there is an error, as in what shows below, but more often in Filezilla there is no error. Regardless of the error, the files both were finally transmitted successfully without my having to re-try the transfer.

Status: Resolving address of integrations-data.rasa.io
Status: Connecting to 18.237.207.147:21...
Status: Connection established, waiting for welcome message...
Status: Initializing TLS...
Status: Verifying certificate...
Status: TLS connection established.
Status: Server does not support non-ASCII characters.
Status: Logged in
Status: Retrieving directory listing...
Status: Directory listing of "/" successful
Status: Retrieving directory listing of "/integrations"...
Status: Directory listing of "/integrations" successful
Status: Resolving address of integrations-data.rasa.io
Status: Connecting to 18.237.207.147:21...
Status: Resolving address of integrations-data.rasa.io
Status: Connecting to 18.237.207.147:21...
Status: Connection established, waiting for welcome message...
Status: Connection established, waiting for welcome message...
Status: Initializing TLS...
Status: Initializing TLS...
Status: Verifying certificate...
Status: TLS connection established.
Status: Verifying certificate...
Status: TLS connection established.
Status: Server does not support non-ASCII characters.
Status: Server does not support non-ASCII characters.
Status: Logged in
Status: Starting upload of Z:\PPDaily.csv
Status: Logged in
Status: Starting upload of Z:\PPDailyCount.txt
Command: CWD /integrations
Response: 250 Directory successfully changed.
Command: TYPE A
Response: 200 Switching to ASCII mode.
Command: PASV
Response: 227 Entering Passive Mode (18,237,207,147,60,235).
Command: STOR PPDailyCount.txt
Error: GnuTLS error -15: An unexpected TLS packet was received.
Error: Disconnected from server: ECONNABORTED - Connection aborted
Error: File transfer failed
Status: Disconnected from server
Status: Resolving address of integrations-data.rasa.io
Status: Connecting to 18.237.207.147:21...
Status: Connection established, waiting for welcome message...
Status: Initializing TLS...
Status: File transfer successful, transferred 643,260 bytes in 1 second
Status: Verifying certificate...
Status: TLS connection established.
Status: Server does not support non-ASCII characters.
Status: Logged in
Status: Starting upload of Z:\PPDailyCount.txt
Status: Retrieving directory listing of "/integrations"...
Status: Calculating timezone offset of server...
Status: Timezone offset of server is 0 seconds.
Status: File transfer successful, transferred 7 bytes in 1 second
Status: Retrieving directory listing of "/integrations"...
Status: Directory listing of "/integrations" successful
Status: Disconnected from server
Status: Disconnected from server

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
33,008
Location:
Prague, Czechia

Re: OOPS:ftruncate error; script fails

I do not see any significant difference between what WinSCP and FileZilla are doing.
In FileZilla you have ascii/text mode selected. While in WinSCP you have binary mode. I doubt that it makes the difference, but it might be worth trying to use the binary mode in WinSCP.
Also FileZilla uploads each file using a new connection. You can try that too.

Reply with quote

Advertisement

You can post new topics in this forum