Four Stars

Salesforce - Metadata import schema NumberFormatException

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

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

  • Big Data
  • Data Integration
  • Sandbox
Tags (2)
1 REPLY
Moderator

Re: Salesforce - Metadata import schema NumberFormatException

Hello,

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

Sabrina

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