Six 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

7 REPLIES
Forteen 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?
Rilhia Solutions
Six 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

Highlighted
Forteen 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 🙂
Rilhia Solutions
Thirteen Stars TRF
Thirteen 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
Thirteen Stars TRF
Thirteen 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
Six Stars

Re: NB_LINE returns wrong values in tSalesforceInput component

Thanks rhall for the reply.
Six 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.