Salesforce - Metadata import schema NumberFormatException

[Anonymous]

Hi,

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!!)

• https://jira.talendforge.org/browse/TAPACHE-76?focusedCommentId=478528&page=com.atlassian.jira.plugi...
• https://community.talend.com/t5/Design-and-Development/Salesforce-Metadata-Error-when-saving-the-con...

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.daikon.properties.PropertiesDynamicMethodHelper.doInvoke(PropertiesDynamicMethodHelper.java:78)
at org.talend.daikon.properties.PropertiesDynamicMethodHelper.afterFormFinish(PropertiesDynamicMethodHelper.java:117)
at org.talend.daikon.properties.service.PropertiesServiceImpl.afterFormFinish(PropertiesServiceImpl.java:92)
at org.talend.components.api.service.internal.osgi.ComponentServiceOsgi.afterFormFinish(ComponentServiceOsgi.java:142)
at org.talend.repository.generic.ui.GenericConnWizard$1.run(GenericConnWizard.java:258)
... 51 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.talend.daikon.properties.PropertiesDynamicMethodHelper.doInvoke(PropertiesDynamicMethodHelper.java:74)
... 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(FloatingDecimal.java:2043)
at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
at java.lang.Double.parseDouble(Double.java:538)
at org.talend.core.model.metadata.MetadataToolAvroHelper.convertToAvro(MetadataToolAvroHelper.java:162)
at org.talend.core.model.metadata.MetadataToolAvroHelper.convertToAvro(MetadataToolAvroHelper.java:63)
at org.talend.designer.core.generic.utils.SchemaUtils.convertTalendSchemaIntoComponentSchema(SchemaUtils.java:99)
at org.talend.designer.core.generic.utils.SchemaUtils.updateComponentSchema(SchemaUtils.java:146)
at org.talend.designer.core.generic.utils.SchemaUtils.updateComponentSchema(SchemaUtils.java:138)
at org.talend.designer.core.generic.utils.SchemaUtils.createSchema(SchemaUtils.java:71)
at org.talend.repository.generic.persistence.GenericRepository.storeProperties(GenericRepository.java:78)
at org.talend.repository.generic.persistence.GenericRepository.storeProperties(GenericRepository.java:1)
at org.talend.components.salesforce.SalesforceModuleListProperties.afterFormFinishMain(SalesforceModuleListProperties.java:126)
... 60 more

[Anonymous]

Hello,

Here is online document about:TalendHelpCenterupported 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

Sabrina