bulk and bulkv2 options not working in tSalesforceInput component

[Vishu1]

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'

]

}

[Anonymous]

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

1. all the data can be shown with individual fields, they are duplicated data.
2. 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.
3. 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