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: 
profuse
Creator
Creator

Job runs twice before ending

Hi,

 

I have a job the reads a tFileInputDelimited and CSV Lookup through the tMap and outputs two TFileOutputDelimited files.

 

The job reads and process all the input data, creates the two output files and then restarts again. After processing the data the second time, the job completes and the output data looks correct.

 

Can anyone tell me why the job is running twice and how I can get this to end after processing the data the first time?

 

All the best.

Labels (3)
1 Solution

Accepted Solutions
nfz11
Creator III
Creator III

I think the reason is you have two triggers that point to your main flow, the tSetGlobalVars and tLibraryLoad.  You should chain those two inline to fix it.  Right now it runs like this so you process your rows twice:

 

tSetGlobalVars -> Your main logic subjob  -> tLibraryLoad -> Your main logic subjob

 

If you need the tSetGlobalVars and tLibraryLoad to run before your main logic then just set it up like this:

tSetGlobalVars

on component ok >

tLibraryLoad

on component ok >

Your main logic subjob

View solution in original post

7 Replies
Anonymous
Not applicable

What makes you think it is running twice? Can you show us a screenshot of the job?

profuse
Creator
Creator
Author

Hi,

When I watch the job run, I see the file row counts increase. After it finishes processing the input once, then the row counts reset to zero and its begins to run again. Once the job process the data twice, here is a look at the screen. Any idea why it cycles through the data twice?

 

 

 

TalendScreenPrint.png

 

nfz11
Creator III
Creator III

I think the reason is you have two triggers that point to your main flow, the tSetGlobalVars and tLibraryLoad.  You should chain those two inline to fix it.  Right now it runs like this so you process your rows twice:

 

tSetGlobalVars -> Your main logic subjob  -> tLibraryLoad -> Your main logic subjob

 

If you need the tSetGlobalVars and tLibraryLoad to run before your main logic then just set it up like this:

tSetGlobalVars

on component ok >

tLibraryLoad

on component ok >

Your main logic subjob

profuse
Creator
Creator
Author

nfz11,

By linking the two together, the job only reads the input files in once, processes and finishes!

 

Thank You NFZ11

 

 

 

 

Anonymous
Not applicable

Nice spot @nfz11!!

Anonymous
Not applicable

Can someone please check and let me know if this is something related to my issue?

 

https://community.talend.com/t5/Design-and-Development/Kafka-is-storing-messages-twice/m-p/161997/hi...

Anonymous
Not applicable

I doubt this is happening, but you can check by downloading a Kafka client to view the messages that are stored.