Hello, great minds!
I have designed a solution to upload the data to Salesforce which appears to work fine when I am using a small chunk of data but when I am doing actual data upload, it is throwing an error saying "java.io.IOException: Maximum column length of 100,000 exceeded in column 5 in record 1,079. Set the SafetySwitch property to false if you're expecting column lengths greater than 100,000 characters to avoid this error."
However, the error is coming in the tSalesforceOutputBulkExec component which doesn't have the option to set SafetySwitch property.
FYI, I am using Talend DI Version 7.0 and Salesforce API 42 and facing below error. Please help to resolve the issue.
It should be a new feature to set SafetSwitch value in tSalesforceOutputBulkExec component.
Are you using talend subscription data integration solution? If so, you could request a patch to fix your issue.
So far, the SafetySwitch option will be available when Bulk is selected from the Query Mode drop-down list in tSalesforceInput component since 7.0.1.
Feel free to create a jira issue on talend bug tracker for your requirement SafetySwitch property in tSalesforceOutputBulkExec
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema