Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Sanjay5
Contributor III
Contributor III

inputstream is closed in tFTPGet component

Hi All,

 

While running my job to download the file from FTP, sometimes my job is failing due to "inputstream is closed"

Below is the complete error message details,

 

Is there any specific setting in tFTPGet component which is required to resolve this issue.

 

Exception in component tFTPGet_1
4:
at com.jcraft.jsch.ChannelSftp._get(ChannelSftp.java:1160)
at com.jcraft.jsch.ChannelSftp.get(ChannelSftp.java:961)
at xyz_150986136.ABCD_job_0_1.ABCD_Job$1SFTPGetter_tFTPGet_1.downloadFile(ABCD_Job.java:2969)
at xyz_150986136.ABCD_job_0_1.ABCD_Job$1SFTPGetter_tFTPGet_1.getFiles(ABCD_Job.java:2947)
at xyz_150986136.ABCD_job_0_1.ABCD_Job.tFTPFileList_1Process(ABCD_Job.java:3075)
at xyz_150986136.ABCD_job_0_1.ABCD_Job.runJobInTOS(ABCD_Job.java:18824)
at xyz_150986136.ABCD_job_0_1.ABCD_Job.main(ABCD_Job.java:18477)
Caused by: java.io.IOException: inputstream is closed
at com.jcraft.jsch.ChannelSftp.fill(ChannelSftp.java:2884)
at com.jcraft.jsch.ChannelSftp.header(ChannelSftp.java:2908)
at com.jcraft.jsch.ChannelSftp._get(ChannelSftp.java:1062)
... 6 more
[WARN ]: xyz_150986136.ABCD_job_0_1.ABCD_Job - Job End Date - Time : 2017-08-16 09:07:21
[FATAL]: xyz_150986136.ABCD_job_0_1.ABCD_Job - tJava_2 null
Exception in component tJava_2
java.lang.NullPointerException
at xyz_150986136.ABCD_job_0_1.ABCD_Job.tJava_2Process(ABCD_Job.java:14667)
at xyz_150986136.ABCD_job_0_1.ABCD_Job.tPostjob_1Process(ABCD_Job.java:14559)
at xyz_150986136.ABCD_job_0_1.ABCD_Job.runJobInTOS(ABCD_Job.java:18839)
at xyz_150986136.ABCD_job_0_1.ABCD_Job.main(ABCD_Job.java:18477)

Labels (1)
4 Replies
Anonymous
Not applicable

Hello
Are there many files are downloaded? Does the job create multiple FTP connection? Can you upload a screenshot of your job design?

Regards
Shong
Sanjay5
Contributor III
Contributor III
Author

Hi Shong,

 

Yes, There are multiple files getting downloaded.

My Job has two tFTPConnection component (One for tFTPGet, other for tFTPPut)

I am using two, because file download takes around 2 hours and while uploading I want to check if connection is still open or not.

I have one Child Job as well, which is also having same tFTPConnection and tFTPPut components.

 

See attached screen shot for the job.  

 


EMM_FTP_JOB.docx
Sanjay5
Contributor III
Contributor III
Author

Do you think using "resume" option would help here?

 

See attached


Resume Option in tFTPGet.png
KRane1690544063
Contributor
Contributor

No, it doesn't help. I have a SFTP from where I am downloading 2 files.

One file is of 60 KB & another one is of 14 MB. Now tFTPGet downloads all the files that are less than 1 MB. But moment it gets file that are big, it gives me the same error 'inputstream is closed'.

I used the 'resume' option on Overwrite File of tFTPGet, but it doesn't help.

I have other folders in the same SFTP which has like multiple files all of size in KBs. It extracts all these files successfully.