Salesforce Metadata: Error when saving the connection

[Anonymous]

I have successfully created a connection to my Salesforce instance using the basic authentification and manage to retrieve two schemas. 
When I want to add the contact schema to the repository I have the following error: 

Save failed!
  org.eclipse.core.runtime.CoreException: Error when saving the connection
      at org.talend.repository.generic.ui.GenericConnWizard$1.run(GenericConnWizard.java:271)
      at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)
      at org.talend.repository.generic.ui.GenericConnWizard.createOrUpdateConnectionItem(GenericConnWizard.java:279)
      at org.talend.repository.generic.ui.GenericConnWizard.performFinish(GenericConnWizard.java:235)
      at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:853)
      at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:438)
      at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:619)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
      at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4454)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1388)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3799)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3409)
      at org.eclipse.jface.window.Window.runEventLoop(Window.java:832)
      at org.eclipse.jface.window.Window.open(Window.java:808)
      at org.talend.repository.generic.action.CreateGenericConnectionAction.doRun(CreateGenericConnectionAction.java:51)
      at org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:632)
      at org.talend.repository.RepositoryWorkUnit.executeRun(RepositoryWorkUnit.java:99)
      at org.talend.core.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(AbstractRepositoryFactory.java:258)
      at org.talend.repository.localprovider.model.LocalRepositoryFactory.executeRepositoryWorkUnit(LocalRepositoryFactory.java:3311)
      at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:2080)
      at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:641)
      at org.eclipse.jface.action.Action.runWithEvent(Action.java:519)
      at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:595)
      at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:511)
      at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:420)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
      at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4454)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1388)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3799)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3409)
      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
      at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
      at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
      at org.talend.rcp.intro.Application.start(Application.java:243)
      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
      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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
      at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
      at org.eclipse.equinox.launcher.Main.main(Main.java:1438)
  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:180)
      at org.talend.repository.generic.ui.GenericConnWizard$1.run(GenericConnWizard.java:267)
      ... 52 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)
      ... 56 more
  Caused by: java.lang.NumberFormatException: For input string: "ABS(1)"
      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:160)
      at org.talend.core.model.metadata.MetadataToolAvroHelper.convertToAvro(MetadataToolAvroHelper.java:61)
      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:97)
      ... 61 more

I have already restarted Talend and restarted my machine. 
I can add other objects schema except the contact one. 
TOS version 6.3.1
Ubuntu 16.04 LTS
Java Version: 

openjdk version "1.8.0_121"
OpenJDK Runtime Environment (build 1.8.0_121-8u121-b13-0ubuntu1.16.04.2-b13)
OpenJDK 64-Bit Server VM (build 25.121-b13, mixed mode)

[Anonymous]

I've tried to set up a new connection and a new Talend project with the same error 
Same error with TOS 6.2.2/ 
Any tips are welcomed .... 

[Anonymous]

I manage to export the item from an old version of the project build in 5.6.x and reimport the Contact object in my new project in 6.3.1.
Not an ideal workflow but it worked. 

[Anonymous]

Hello! 

Hope You are doing great! 

I am getting a similar error while trying to import Snowflake Table Metadata. 

Is there any solution to this ? or shall i download a lower version and do the import and then use V7.1 ? 

Thanks, 

- Som

[Anonymous]

Hi, 

I am having same error when trying to retrieve the schema after creating salesforce connection. Please share if you find any solution for this.

Thanks!

[Anonymous]

Hi, 

I am having same error when trying to retrieve the schema after creating salesforce connection. Please share if you found any solution for this.

Thanks!

[Anonymous]

Hello,

What does your salesforce URL look like? We need more information to address your issue.

Best regards

Sabrina

[HQF_SCCF]

Hello

The problem seems to be with talend. In the request it makes to feed its metadata, it does access the objects, but for those that have a default value that does not suit it, it cannot save it. For example, in a salesforce date column, a default function is used to calculate today's date when the field is empty. I think this function not interpreted by Talend is the cause of the blocking of the loading of the object.

By using a tSalesForceInput component with only manual parameterization of the Salesforce object to load, I was able to obtain the complete schema of the object in PJ XML importable in the Studio

Best regards

Emma

[thesuda]

I am having this issue in latest version of Talend Version: 8.0.1

Can't save metadata connection of salesforce at all. All googling brings me back this thread. Anyone ever manage to solve this?

[Anonymous]

Hello @Sudarshan K​ 

With your talend version 8.0.1, please make sure that you are using v11 of the Java jdk. Is it Free or licensed/subscription product? Any patch taken?

No problem with the same login on other tools and not a firewall problem from your end (salesforce connection ip)?

Best regards

Sabrina