NB_LINE_INSERTED is null On Subjob?

Highlighted
Four Stars

NB_LINE_INSERTED is null On Subjob?

I am trying to count the number of rows inserted during a job, but I can't seem to get a value from ((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_INSERTED")) other than null.

 

Any suggestionsjob.PNGtFixedFlow.PNG


Accepted Solutions
Highlighted
Four Stars

Re: NB_LINE_INSERTED is null On Subjob?

Thank you to anyone who took the time to look at this. I figured out the issue.

 

I was apparently using the tDBOutput component this whole time, and not the TMSSqlOutput component. As soon as I changed the tFixedFlowInput component value to ((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED")) It began to work!

 

return.PNGtFixedFlow.PNG

View solution in original post


All Replies
Highlighted
Moderator

Re: NB_LINE_INSERTED is null On Subjob?

Are you doing Insert operation in tdboutput?
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Four Stars

Re: NB_LINE_INSERTED is null On Subjob?

The "Action on Data" is "Update or Insert". Is that an issue?

 

Edit: I tried changing it to "Insert" and that did not seem to have any affect. It still returns the following result.

 

return.PNG

Highlighted
Four Stars

Re: NB_LINE_INSERTED is null On Subjob?

Thank you to anyone who took the time to look at this. I figured out the issue.

 

I was apparently using the tDBOutput component this whole time, and not the TMSSqlOutput component. As soon as I changed the tFixedFlowInput component value to ((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED")) It began to work!

 

return.PNGtFixedFlow.PNG

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog