topic NB_LINE returns wrong values in tSalesforceInput component in Talend Studio

NB_LINE returns wrong values in tSalesforceInput component

Anonymous — Sat, 16 Nov 2024 08:33:17 GMT

Hi,

I ma getting wrong number of extracted records from Salesforce. I have used NB_LINE of tSalesforceInput component. If anybody has any idea about this, please help me.

Here you can see, 297 records are coming from Salesforce, but only 296 is showing by NB_LINE

Re: NB_LINE returns wrong values in tSalesforceInput component

Anonymous — Thu, 15 Mar 2018 10:35:22 GMT

This is interesting, but not terribly unusual. The db components can have issues like this in certain configurations, so I guess the salesforce ones may be no different..... although it's not correct and should be reported. Can you test moving your tJava where you print the total to the very end of the job to see what happens?

Re: NB_LINE returns wrong values in tSalesforceInput component

Anonymous — Thu, 15 Mar 2018 11:32:23 GMT

Hi Rhall,

I tested the same by connecting the tJava component with tPostjob component, but still the result is same. It is printing only 296 records.

Re: NB_LINE returns wrong values in tSalesforceInput component

Anonymous — Fri, 16 Mar 2018 09:12:14 GMT

This sounds like a bug with either the display on the screen or what is held in the variable. You will need to raise this with support. Before doing that, put a tLogRow after your salesforce component and see if you can count the actual number of records.

As a temporary workaround you could put a tJavaFlex component and put.....

int count =0;
if(globalMap.get("count")!=null) {
count = ((Integer)globalMap.get("count")) +1;
}
globalMap. put("count", count);

..... this will keep an accurate count for you.

...... excuse the potentially dodgy code, this was written on a smart phone from memory 🙂

Re: NB_LINE returns wrong values in tSalesforceInput component

TRF — Sun, 18 Mar 2018 18:23:31 GMT

Hi,

I just checked the behaviour with TOS 6.4.1 for which the variable NB_LINE of my tSalesforceInput component is equal to the number of records retrieved by the corresponding select.

What's the version you're using?

Re: NB_LINE returns wrong values in tSalesforceInput component

TRF — Tue, 20 Mar 2018 10:06:55 GMT

Did this help?
If so, thank's to mark your case as solved (Kudo also accepted).

Re: NB_LINE returns wrong values in tSalesforceInput component

Anonymous — Tue, 20 Mar 2018 15:02:16 GMT

Thanks rhall for the reply.

Re: NB_LINE returns wrong values in tSalesforceInput component

Anonymous — Tue, 20 Mar 2018 15:04:51 GMT

Hi TRF,

Thanks for your time to reply on this.

Currently we are using Talend 6.3v (Open Studio) and still I am facing the same.