SafetySwitch property :

Seventeen Stars

SafetySwitch property :

When my job try to "parse" a tFileInputPositionnal" I've got this :
Maximum row record length of 100,000 exceeded in row in record 0. Set the safetySwitch property to false if you're expecting row record lengths greater than 100,000 characters to avoid this error.

but where can I set this value in Talend !?
In the advanced settings !?
and how !?
thanks for your help
Edit :
Hum .... in fact I'd put "/n" in place of "\n" for the return carriage pattern ... <shame on me !!!>
But my question 's still , because it could be helpfully one day .
I've seen this topic
about the same exception message

Re: SafetySwitch property :

Looks like nobody have tried the tFileInputPositional with such long rows.
You're right, we should add an advanced setting in the component for such cases.
See 5504
Seventeen Stars

Re: SafetySwitch property :

thanks for that ...
more I use Talend , more i enjoy ... even if sometimes it make me crazy (lol)
Five Stars

Re: SafetySwitch property :

Hi @kzone,


Can you please let me know what was the solution to this issue, I am in mid of a scheduled data upload and facing this issue?


@xdshi, I am using Talend DI Version 7.0 and Salesforce API 42 and facing below error. Please help to resolve the issue.


Looks like this the option Set the SafetySwitch is there in tSalesforceInput file but it says the error is in tSalesforceOutputBulkExec where I can't see this property. 



Starting job DemoContext_TasksDataUpload at 11:55 02/08/2018.
[statistics] connecting to socket on port 3728
[statistics] connected
Exception in component tSalesforceOutputBulkExec_5_tSalesforceBulkExec (DemoContext_TasksDataUpload) 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.
at com.csvreader.CsvReader.readRecord(Unknown Source)
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.getBaseFileRow(
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.getBatchLog(
at org.talend.components.salesforce.runtime.SalesforceBulkExecReader.start(
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(
at local_project.democontext_tasksdataupload_0_1.DemoContext_TasksDataUpload.tFileList_5Process(
at local_project.democontext_tasksdataupload_0_1.DemoContext_TasksDataUpload.tFileList_4Process(
at local_project.democontext_tasksdataupload_0_1.DemoContext_TasksDataUpload.tFileList_3Process(
at local_project.democontext_tasksdataupload_0_1.DemoContext_TasksDataUpload.tFileList_2Process(
at local_project.democontext_tasksdataupload_0_1.DemoContext_TasksDataUpload.tFileList_1Process(
at local_project.democontext_tasksdataupload_0_1.DemoContext_TasksDataUpload.tSalesforceConnection_1Process(
at local_project.democontext_tasksdataupload_0_1.DemoContext_TasksDataUpload.runJobInTOS(
at local_project.democontext_tasksdataupload_0_1.DemoContext_TasksDataUpload.main(
[statistics] disconnected


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.