topic Re: Salesforce Metadata: Error when saving the connection in Talend Studio

Salesforce Metadata: Error when saving the connection

Anonymous — Sat, 16 Nov 2024 10:05:50 GMT

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)

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Sun, 12 Feb 2017 19:35:17 GMT

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 ....

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Mon, 13 Feb 2017 16:36:02 GMT

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.

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Mon, 04 Feb 2019 08:36:47 GMT

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

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Thu, 21 Mar 2019 18:24:02 GMT

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!

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Thu, 21 Mar 2019 18:24:53 GMT

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!

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Mon, 20 May 2019 05:46:58 GMT

Hello,

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

Best regards

Sabrina

Re: Salesforce Metadata: Error when saving the connection

HQF_SCCF — Fri, 31 Jul 2020 09:13:04 GMT

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

Re: Salesforce Metadata: Error when saving the connection

thesuda — Wed, 16 Nov 2022 15:36:29 GMT

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?

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Thu, 17 Nov 2022 07:03:35 GMT

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

Re: Salesforce Metadata: Error when saving the connection

thesuda — Thu, 17 Nov 2022 15:05:29 GMT

I am using jdk-17.0.4.1

No problem with salesforce even in Talend. I can click test connection successfully, on next screen I can get the list of salesforce objects too. But when I click finish I get 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:311)

at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)

at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2338)

at org.talend.repository.generic.ui.GenericConnWizard.createOrUpdateConnectionItem(GenericConnWizard.java:319)

at org.talend.repository.generic.ui.GenericConnWizard.performFinish(GenericConnWizard.java:259)

at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:832)

at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:472)

at org.eclipse.jface.dialogs.Dialog.lambda$0(Dialog.java:619)

at org.eclipse.swt.events.SelectionListener$1.widgetSelected(SelectionListener.java:84)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4209)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4026)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3626)

at org.eclipse.jface.window.Window.runEventLoop(Window.java:823)

at org.eclipse.jface.window.Window.open(Window.java:799)

at org.talend.repository.generic.action.GenericAction.doRun(GenericAction.java:71)

at org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:678)

at org.talend.repository.RepositoryWorkUnit.executeRun(RepositoryWorkUnit.java:103)

at org.talend.core.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(AbstractRepositoryFactory.java:259)

at org.talend.repository.localprovider.model.LocalRepositoryFactory.executeRepositoryWorkUnit(LocalRepositoryFactory.java:3767)

at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:2679)

at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:688)

at org.eclipse.jface.action.Action.runWithEvent(Action.java:474)

at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:580)

at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:414)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4209)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4026)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3626)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1157)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)

at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)

at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:644)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:551)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:156)

at org.talend.rcp.intro.Application.start(Application.java:303)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)

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:401)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:568)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:654)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)

at org.eclipse.equinox.launcher.Main.run(Main.java:1462)

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:109)

at org.talend.daikon.properties.PropertiesDynamicMethodHelper.afterFormFinish(PropertiesDynamicMethodHelper.java:323)

at org.talend.daikon.properties.service.PropertiesServiceImpl.afterFormFinish(PropertiesServiceImpl.java:135)

at org.talend.components.api.service.internal.osgi.ComponentServiceOsgi.afterFormFinish(ComponentServiceOsgi.java:177)

at org.talend.repository.generic.ui.GenericConnWizard$1.run(GenericConnWizard.java:307)

... 52 more

Caused by: java.lang.reflect.InvocationTargetException

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:568)

at org.talend.daikon.properties.PropertiesDynamicMethodHelper.doInvoke(PropertiesDynamicMethodHelper.java:105)

... 56 more

Caused by: com.cedarsoftware.util.io.JsonIoException: JsonIoException setting field 'status' on target: OK null with value: {name=null}

at com.cedarsoftware.util.io.ObjectResolver.assignField(ObjectResolver.java:229)

at com.cedarsoftware.util.io.ObjectResolver.traverseFields(ObjectResolver.java:85)

at com.cedarsoftware.util.io.Resolver.convertMapsToObjects(Resolver.java:184)

at com.cedarsoftware.util.io.JsonReader.convertParsedMapsToJava(JsonReader.java:747)

at com.cedarsoftware.util.io.JsonReader.readObject(JsonReader.java:694)

at com.cedarsoftware.util.io.JsonReader.jsonToJava(JsonReader.java:426)

at org.talend.daikon.serialize.SerializerDeserializer.fromSerialized(SerializerDeserializer.java:171)

at org.talend.daikon.serialize.SerializerDeserializer.fromSerialized(SerializerDeserializer.java:135)

... 61 more

Caused by: com.cedarsoftware.util.io.JsonIoException: Class listed in @type [org.talend.daikon.properties.ValidationResult$Result] is not found

at com.cedarsoftware.util.io.ObjectResolver.readIfMatching(ObjectResolver.java:629)

at com.cedarsoftware.util.io.ObjectResolver.assignField(ObjectResolver.java:151)

... 80 more

Caused by: java.lang.NullPointerException: Name is null

at java.base/java.lang.Enum.valueOf(Enum.java:271)

...

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Fri, 18 Nov 2022 03:39:55 GMT

Hello,

Is it Free or licensed/subscription product? Any patch taken?

Could you please let us know if there is any specific requirement to use JDK 17?

Here is online documentation for 8.0.1 about:

TalendHelpCenter: compatible-java-environments

Please refer the link above to know the compatible java versions and ensure proper version of JDK is installed.

In the documentation we provide a list of compatible java environments that are supported, in the sense that we do provide an SLA and technical support for them.

Best regards

Sabrina

Re: Salesforce Metadata: Error when saving the connection

thesuda — Fri, 18 Nov 2022 03:43:43 GMT

I am using the free version. I don't have any specific requirement to use jdk 17, it's just what I had. I will try the recommended version first. Regards, Sudarshan Kadam

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Fri, 18 Nov 2022 04:03:13 GMT

Hello,

As the supported versions of Java are limited due to the number of third party Jars that are used. These all have differing supported versions of Java, please try the recommended version first.

Don't hesitate to post your issue here.

Best regards

Sabrina

Re: Salesforce Metadata: Error when saving the connection

manuel_m_speranza — Sat, 11 Mar 2023 14:33:00 GMT

Hi,

I had the same issue using the Oracle JDK 19. So I fixed using one of these versions: 11, 15 or 17.

HTH

Re: Salesforce Metadata: Error when saving the connection

Anonymous — Mon, 13 Mar 2023 04:34:23 GMT

Hello,

Here is online documentation for 8.0.1 about:

TalendHelpCenter: compatible-java-environments

Please try the recommended version first.

Best regards

Sabrina

Re: Salesforce Metadata: Error when saving the connection

attilisatish — Tue, 17 Oct 2023 01:05:59 GMT

This is due to Java version, it can happen if you have an old version or multiple versions. Install JDK 11 or higher.

Suppose you have talend in c:\talend and jdk11 is in C:\jdk11. You can do like the following in windows environment.

Open command prompt.

Goto the bin folder location where jdk 11 is located. For example if you have jdk in C:\jdk11 then cd\

cd C:\jdk11\bin

Then from bin folder of jdk type the full uri of the executable and hit enter. In the above supposition c:\jdk11\bin>c:\talend\tos_di-xxxxx.exe

In the above statement tos_di-xxxxx.exe is the executable file depending on the os environment

This should resolve it.

I hope this helps.

Cheers

Satish