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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Start the next Component after the previous Subjob Completely finishes

Hello,
I have created a job where I have to copy the final output file to a particular ftp.
But the problem is I am not getting OnSubjobOk at tFileOutputDelimited to link it to the next component.
If i use OnComponentOk, the final file at FTP just gives the data of the last record from the input...the file gets appended after every loop.
Is there any alternate method where I can move the file (tFileOutputDelimited) only when it is completely filled with all the records ?

Thank You.

Labels (2)
6 Replies
Anonymous
Not applicable
Author

Hi
Link the OnSubjobOK from the first component of a subjob, eg:
tFileInputDelimited--main-->tFileOutputDelimited
  |
onsubjobok
  |
tFTPPut

Regards
Shong
Anonymous
Not applicable
Author

Hi Shong,
Yes it worked 0683p000009MACn.png
Thanks a lot !!!!
Anonymous
Not applicable
Author

Hi Shong,
The Job runs correctly now, the file transferred to the FTP is also correct.
But after the transfer of file, we have to kill the job every time, it doesn't stop automatically.
Can we use tDie component at the end ? Or is this issue something else ?
Best Regards,
Anonymous
Not applicable
Author

Hi 
It sounds not normal, does the job hang up all the time? If so, I think you need to test and debug to see which component cause the problem and why.
Can you please upload a overview screenshot of your job?

Regards
Shong
Anonymous
Not applicable
Author

Hi Shong,
Yes the job hangs up all the time now. 
The issue started after we linked the final Subjob ( Moving the output file to FTP ). 
There was no such issue before ( till Output file generation ).
Please check the screenshot of the Job.

Thank You.
0683p000009MGL1.png
Anonymous
Not applicable
Author

It seems the problem occurs on tFTPPut component? Please check this:
...tFTPConnection--onsubjobok--tftpput--oncomponent--tJava

on tJava, print a string to console for testing:
System.out.println("tftpput ends");

Regards
Shong