Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

0683p000009LrM1.png

 

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

Labels (5)
2 Replies
TRF
Champion II
Champion II

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.

Anonymous
Not applicable
Author

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.