Four Stars

Salesforce - Metadata import schema NumberFormatException


I've been trying to connect Salesforce and import MetaData - seems to get the same issue on

  • TOS_BD-20170623_1246-V6.4.1 (Open Source Big Data ) 
  • Talend-Studio-6_4_1 (Open Studio/DI)

This is running on Win2k10, however seems to behave the same in the Big Data VM (Ubuntu ) instance.


See stack trace below. I've checked bugs and this looks close => TAPACHE-76


Looks to be complaining about a field with a datatype in salesforce Number(3, 2) however I didn't even select this specific table ( so can't even exclude tables with these fields )


This looks like the same issue as referenced here ( shame that old forum not converted!!)

Also old forum mentions a page which apparently defines which version of Salesforce API is certified to work with TALEND - however link no longer works.


**** Relevant part of stack Trace *****

Caused by: org.talend.daikon.exception.TalendRuntimeException: FAILED_INVOKE_METHOD:{class=org.talend.components.salesforce.SalesforceModuleListProperties, method=afterFormFinishMain}
at org.talend.components.api.service.internal.osgi.ComponentServiceOsgi.afterFormFinish(
at org.talend.repository.generic.ui.GenericConnWizard$
... 51 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
... 55 more
Caused by: java.lang.NumberFormatException: For input string: "$Setup.loan__Fractionalization_Parameters__c.loan__Default_Service_Rate__c"
at sun.misc.FloatingDecimal.readJavaFormatString(
at sun.misc.FloatingDecimal.parseDouble(
at java.lang.Double.parseDouble(
at org.talend.core.model.metadata.MetadataToolAvroHelper.convertToAvro(
at org.talend.core.model.metadata.MetadataToolAvroHelper.convertToAvro(
at org.talend.designer.core.generic.utils.SchemaUtils.convertTalendSchemaIntoComponentSchema(
at org.talend.designer.core.generic.utils.SchemaUtils.updateComponentSchema(
at org.talend.designer.core.generic.utils.SchemaUtils.updateComponentSchema(
at org.talend.designer.core.generic.utils.SchemaUtils.createSchema(
at org.talend.repository.generic.persistence.GenericRepository.storeProperties(
at org.talend.repository.generic.persistence.GenericRepository.storeProperties(
at org.talend.components.salesforce.SalesforceModuleListProperties.afterFormFinishMain(
... 60 more


Re: Salesforce - Metadata import schema NumberFormatException


Here is online document about:TalendHelpCenterSmiley Frustratedupported systems, databases and business applications by Talend components.

Is it what you are looking for?

This jira issue TAPACHE-76 status is open and the resolution is unresolved.

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.