topic Re: Error while loading data in tSalesforceOutputBulkExec in Talend Studio

Error while loading data in tSalesforceOutputBulkExec

varun1949 — Sat, 16 Nov 2024 04:20:40 GMT

Error while loading data in tSalesforceOutputBulkExec

Error is :-

Exception in component tSalesforceBulkExec_2 (SalesforceErrorLoadFile)
java.io.IOException: [AsyncApiException exceptionCode='InvalidBatch'
exceptionMessage='Records not processed'
]

at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(SalesforceBulkExecReader.java:75)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at talendjobswithouttac.salesforceerrorloadfile_0_1.SalesforceErrorLoadFile.tSalesforceBulkExec_2Process(SalesforceErrorLoadFile.java:2970)
at talendjobswithouttac.salesforceerrorloadfile_0_1.SalesforceErrorLoadFile.tFileList_4Process(SalesforceErrorLoadFile.java:2123)
at talendjobswithouttac.salesforceerrorloadfile_0_1.SalesforceErrorLoadFile.runJobInTOS(SalesforceErrorLoadFile.java:4348)
at talendjobswithouttac.salesforceerrorloadfile_0_1.SalesforceErrorLoadFile.main(SalesforceErrorLoadFile.java:4015)
Caused by: [AsyncApiException exceptionCode='InvalidBatch'
exceptionMessage='Records not processed'
]

Now when i am trying to do the same using tSalesforceOuput then it is getting successfully loaded , Please let me know what's the issue with bulkExec

Re: Error while loading data in tSalesforceOutputBulkExec

TRF — Fri, 18 Oct 2019 07:23:36 GMT

Bulk is not allowed for attachment.

Re: Error while loading data in tSalesforceOutputBulkExec

varun1949 — Fri, 18 Oct 2019 07:50:54 GMT

I am not sending the attachment , i am sending the Version Data as encoded data in Content Version Object nin Salesforce

Re: Error while loading data in tSalesforceOutputBulkExec

TRF — Fri, 18 Oct 2019 08:02:38 GMT

Sorry, I thought that is was the same post as this one https://community.talend.com/t5/Design-and-Development/Error-in-tSalesforceOutputBulkExec-component/m-p/204902#M112105

However, ContentVersion is special and actually I'm not sure you can address it with tSalesforceOutputBulkExec component.

What do you see if you go to salesforce setup page then Jobs > Bulk Data Load Jobs and move the mouse pointer over the message "InvalidBatch"?

Did you try to load your documents using DataLoader?

What happens in this case?

Re: Error while loading data in tSalesforceOutputBulkExec

varun1949 — Thu, 05 Dec 2019 10:29:31 GMT

sorry for late reply , I have used the salesforce output component instead

Re: Error while loading data in tSalesforceOutputBulkExec

PriyankaReddy — Mon, 28 Oct 2024 20:31:59 GMT

Hi,

I am getting the below error while trying to load using salesforce output component.

Starting job Job_ODS_ContentVersion_to_SF_ContentVersion at 14:50 28/10/2024.
[statistics] connecting to socket on port 3959
[statistics] connected
[FATAL] 14:50:44 dev.job_ods_contentversion_to_sf_contentversion_0_1.Job_ODS_ContentVersion_to_SF_ContentVersion- tSalesforceOutput_1 [UnexpectedErrorFault [ApiFault exceptionCode='EXCEEDED_MAX_SIZE_REQUEST'
exceptionMessage='Maximum size of request reached. Maximum size of request is 52428800 bytes.'
extendedErrorDetails='{[0]}'
]
]

Could you please suggest on how you resolved the issue?