One Star

Error on tSalesforceOutputBulk

Hi everyone,

 

I'm facing an odd error:

Exception in component tSalesforceOutputBulk_7
java.lang.ClassCastException: java.lang.Long cannot be cast to java.util.Date
	at org.talend.components.common.runtime.GenericAvroRegistry$DateToStringConvert.convertToDatum(GenericAvroRegistry.java:135)
	at org.talend.components.common.runtime.GenericIndexedRecordConverter$GenericIndexedRecord.get(GenericIndexedRecordConverter.java:88)
	at org.talend.components.salesforce.runtime.SalesforceBulkFileWriter.getValues(SalesforceBulkFileWriter.java:99)
	at org.talend.components.common.runtime.BulkFileWriter.write(BulkFileWriter.java:106)
	at p_etl.ETL_0_1.ETL.tFileInputDelimited_4Process(ETL.java:2799)
	at p_etl.ETL_0_1.ETL.tSalesforceConnection_1Process(ETL.java:702)
	at p_etl.ETL_0_1.ETL.tSetGlobalVar_1Process(ETL.java:518)
	at p_etl.ETL_0_1.ETL.runJobInTOS(ETL.java:5881)
	at p_etl.ETL_0_1.ETL.main(ETL.java:5730)

The weird error is that my output doesn't have any Date declared.

Captura.PNG

 

The Talend version I'm using is: Big Data 6.3.2 

2 REPLIES
Twelve Stars TRF
Twelve Stars

Re: Error on tSalesforceOutputBulk

Hi,

 

I suggest you to convert all fields to String datatype before to tSalesforceOutBulk (and of course also change the schema datatype).

Let us know.


TRF
One Star

Re: Error on tSalesforceOutputBulk

Actually, the Long datatype for that field was launching a non-optional auto-process conversion to Date (why? do not know) So I fix it changing that to BigDecimal and now it works like a charm.

 

Thank you for reading.