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]' 

Fifteen Stars TRF
Fifteen 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. 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog