NB_LINE returns wrong values in tSalesforceInput component

Seven Stars

NB_LINE returns wrong values in tSalesforceInput component

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

 

1.JPG

2.JPG3.JPG

Sixteen Stars

Re: NB_LINE returns wrong values in tSalesforceInput component

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?
Seven Stars

Re: NB_LINE returns wrong values in tSalesforceInput component

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.

 

5.JPG

Sixteen Stars

Re: NB_LINE returns wrong values in tSalesforceInput component

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 🙂
Forteen Stars TRF
Forteen Stars

Re: NB_LINE returns wrong values in tSalesforceInput component

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?


TRF
Forteen Stars TRF
Forteen Stars

Re: NB_LINE returns wrong values in tSalesforceInput component

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


TRF
Seven Stars

Re: NB_LINE returns wrong values in tSalesforceInput component

Thanks rhall for the reply.
Seven Stars

Re: NB_LINE returns wrong values in tSalesforceInput component

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.