topic Re: Difference between Insert Outputmessage and Tablerecords in Talend Studio

Difference between Insert Outputmessage and Tablerecords

mungerboeck — Sat, 16 Nov 2024 09:35:54 GMT

Hi,

We insert with tMSSqlOutput a table with more than 5 Mio records. The targetable is empty.
In the Log-File we can see that these 5 Mio records are inserted (these Information come from tMSSqlOutput_2_NB_LINE_INSERTED).

In the targettable there are only 800.000 records.

When we start the job in Talend directly, you can see, that 5 Mio records are proceeded and inserted. But in the targettable it's the same problem.

The action on tMSSqlOutput is only insert and we use a reject path. But there are only 600 records.

Our Talendversion is 6.0.1 and the Database is a MSSql.

Can anyone help me.

Thanks.

Re: Difference between Insert Outputmessage and Tablerecords

Anonymous — Fri, 23 Jun 2017 03:54:44 GMT

Hi,

Have you already checked that if there are some rows rejected by your tMSSqlOutput?

Best regards

Sabrina

Re: Difference between Insert Outputmessage and Tablerecords

mungerboeck — Fri, 23 Jun 2017 06:37:57 GMT

Yes, but there are only 600 rows rejected.

Re: Difference between Insert Outputmessage and Tablerecords

Anonymous — Fri, 23 Jun 2017 08:24:11 GMT

Hi,

Would you mind posting your current job design screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Re: Difference between Insert Outputmessage and Tablerecords

mungerboeck — Mon, 26 Jun 2017 12:57:45 GMT

Hi Sabrina,

here you can see my job.

Re: Difference between Insert Outputmessage and Tablerecords

cterenzi — Mon, 26 Jun 2017 13:38:26 GMT

Hi @Mungerb, that doesn't appear to be a screenshot of your Talend job. Could you repost, please?

Re: Difference between Insert Outputmessage and Tablerecords

mungerboeck — Mon, 26 Jun 2017 14:05:46 GMT

Sorry, here is the right job.