bulk and bulkv2 options not working in tSalesforceInput component

Vishu1 — Fri, 15 Nov 2024 22:18:29 GMT

Hi,

I am using tSalesforceInput Component to fetch the data from salesforce.

I am using Talend studio - 7.3.1 (Patch - R2022-02)

Using query mode = query, I am able to fetch the data.

But with query mode = bulk and bulkV2, I am getting below error.

for bulkV2 :

BulkV2ClientException exceptionMessage='Bad Request'

for bulk :

org.talend.components.api.exception.ComponentException: org.talend.daikon.exception.error.DefaultErrorCode@44de94c3:{failedBatch=[BatchInfo id='7513L000003FXC2QAO'

jobId='7503L000002lbsqQAA'

state='Failed'

stateMessage='InvalidBatch : Failed to process query: FUNCTIONALITY_NOT_ENABLED: Selecting compound data not supported in Bulk Query'

createdDate='java.util.GregorianCalendar[time=1669971251000,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=2022,MONTH=11,WEEK_OF_YEAR=49,WEEK_OF_MONTH=1,DAY_OF_MONTH=2,DAY_OF_YEAR=336,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=8,HOUR_OF_DAY=8,MINUTE=54,SECOND=11,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'

systemModstamp='java.util.GregorianCalendar[time=1669971261000,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=2022,MONTH=11,WEEK_OF_YEAR=49,WEEK_OF_MONTH=1,DAY_OF_MONTH=2,DAY_OF_YEAR=336,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=8,HOUR_OF_DAY=8,MINUTE=54,SECOND=21,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'

numberRecordsProcessed='0'

numberRecordsFailed='0'

totalProcessingTime='0'

apiActiveProcessingTime='0'

apexProcessingTime='0'

]

}

Re: bulk and bulkv2 options not working in tSalesforceInput component

Anonymous — Fri, 02 Dec 2022 10:11:19 GMT

Hello,

"Failed to process query: FUNCTIONALITY_NOT_ENABLED: Selecting compound data not supported in Bulk Query'"

The error message is clear and maybe you could search the string on google and it gives plenty of explanations.

Actually we didn't support query compound field

all the data can be shown with individual fields, they are duplicated data.
it's complex type and not easy to build this kind of field data, on the Salesforce web ui. they display the value which is only concatenations individual fields.
Only soap api support query compound field, bulk query didn't support it.

Please try to remove the compound type field , and try bulk query again.

http://salesforcexytools.com/salesforce/2017/08/09/sfdc-Selecting-compound-data-not-supported/

Best regards

Sabrina

topic Re: bulk and bulkv2 options not working in tSalesforceInput component in Talend Studio

bulk and bulkv2 options not working in tSalesforceInput component

Re: bulk and bulkv2 options not working in tSalesforceInput component