java.io.IOException: inputstream is closed - Send file over SFTP

Question

Hello, 
 I'm extracting data from the database using the 'Export SQL to Excel' smart service and then using the 'Send file over SFTP' smart service. I'm doing this for 4 different tables but the issue 'java.io.IOException: inputstream is closed' seems to appear only for one of the tables. The issue seems to appear randomly as it usually works correctly. 
 I found an article that addresses the issue directly so I followed the advice by adding a timer (first 1 min then 3 min) before the send over SFTP but the issue persists at random occurrences. KB-1113 SFTP smart service transfers a blank file to its destination - Appian Knowledge Base - Support - Appian Community 
 
 What could be the problem? 
 
 Thanks in advance

David Jimenez · Answer

Does the issue occurs always with the same table? is that table the last one inserted?

David Jimenez · Answer

Try running the extraction sequentially instead of in parallel, just for testing purposes. 
 It seems that one of the branches is closing the socket when it finishes, and the last one &mdash; which is also the slowest &mdash; is the one that fails.

java.io.IOException: inputstream is closed - Send file over SFTP

Top Replies