Exception in tSalesforceInput component

One Star

Exception in tSalesforceInput component

I am using tSalesforceInput component in bulk mode in studio version 6.4.1 to export records to further process it however it am getting this exception - 

I dont have any clue how to resolve it. Please help me to understand the error code - DefaultErrorCode@1ff4931d

 

Exception in component tSalesforceInput_1 (Test_Export)
org.talend.components.api.exception.ComponentException: org.talend.daikon.exception.error.DefaultErrorCode@1ff4931d:{failedBatch=[BatchInfo id='7515700000DyTCDAA3'  jobId='7505700000BRDolAAH'  state='Queued' stateMessage='null'
createdDate='java.util.GregorianCalendar[time=1513247579000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2017,MONTH=11,WEEK_OF_YEAR=50,WEEK_OF_MONTH=3,DAY_OF_MONTH=14,DAY_OF_YEAR=348,DAY_OF_WEEK=5,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=10,HOUR_OF_DAY=10,MINUTE=32,SECOND=59,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'
systemModstamp='java.util.GregorianCalendar[time=1513247579000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2017,MONTH=11,WEEK_OF_YEAR=50,WEEK_OF_MONTH=3,DAY_OF_MONTH=14,DAY_OF_YEAR=348,DAY_OF_WEEK=5,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=10,HOUR_OF_DAY=10,MINUTE=32,SECOND=59,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]' 

Forteen Stars TRF
Forteen Stars

Re: Exception in tSalesforceInput component

Hi,

Did you check for more detail in Monitor Bulk Data Load Jobs?


TRF
One Star

Re: Exception in tSalesforceInput component

Yes, I have checked it and job is listed under In Progress jobs with status open. It shows the correct number under Records Processed while zero under Records Failed.

All these records got processed in one batch and thats also completed. I can see completed status for this batch. 

Also Queued batches and In Progress batches are zero.

That is why i am clueless that where is the exact problem?

One Star

Re: Exception in tSalesforceInput component

Finally i got some clue. It works fine when i change query mode = query from bulk. It seems that there is some bug in this component in 6.4.1 version also. It used to give exception when we have more than 10000 records to process in earlier versions.