‘Save failed’ error when create metadata connection from snowflake

piexpert — Fri, 09 Sep 2022 19:24:46 GMT

Hi,

I tried to create metadata to build a connection from snowflake, the connection is successful in the first step, but it failed in the next step.

The error message is ‘Save failed’, and the detailed error message is appended at the end.

Could you please let me know any suggestions on this?

Thanks.

1. Connection successful

2. Save failed error

-----detailed error message---

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)

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.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)

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

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.snowflake.SnowflakeTableListProperties, 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)

... 50 more

Caused by: java.lang.reflect.InvocationTargetException

at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:119)

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

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

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

at org.talend.daikon.properties.Properties$Helper.fromSerializedPersistent(Properties.java:277)

at org.talend.designer.core.generic.utils.ComponentsUtils.getComponentPropertiesFromSerialized(ComponentsUtils.java:860)

at org.talend.designer.core.generic.utils.ComponentsUtils.getComponentPropertiesFromSerialized(ComponentsUtils.java:854)

at org.talend.repository.generic.util.GenericConnectionUtil.synNamePropertyWithItem(GenericConnectionUtil.java:54)

at org.talend.repository.generic.handler.GenericRepositoryContentHandler.save(GenericRepositoryContentHandler.java:107)

at org.talend.repository.localprovider.model.LocalRepositoryFactory.save(LocalRepositoryFactory.java:2671)

at org.talend.repository.localprovider.model.LocalRepositoryFactory.save(LocalRepositoryFactory.java:2527)

at org.talend.core.repository.model.ProxyRepositoryFactory.save(ProxyRepositoryFactory.java:1649)

at org.talend.core.repository.model.ProxyRepositoryFactory.save(ProxyRepositoryFactory.java:1643)

at org.talend.repository.generic.persistence.GenericRepository.storeProperties(GenericRepository.java:91)

at org.talend.repository.generic.persistence.GenericRepository.storeProperties(GenericRepository.java:1)

at org.talend.components.snowflake.SnowflakeTableListProperties.afterFormFinishMain(SnowflakeTableListProperties.java:93)

at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)

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

... 76 more

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

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

at com.cedarsoftware.util.io.Resolver.getEnum(Resolver.java:515)

at com.cedarsoftware.util.io.Resolver.createJavaObjectInstance(Resolver.java:380)

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

... 77 more

Re: ‘Save failed’ error when create metadata connection from snowflake

ppatel — Mon, 12 Sep 2022 09:18:10 GMT

Hello Team,

1)Can you please check the same connection working fine outside of Talend?

2)Can you please open the studio with the new workspace and try to create the snowflake metadata connection?

3)Can you please let us know the snowflake jar which you are using?

Re: ‘Save failed’ error when create metadata connection from snowflake

ppatel — Mon, 12 Sep 2022 09:18:34 GMT

Also please check the patch version which you are using in the Talend?

Re: ‘Save failed’ error when create metadata connection from snowflake

piexpert — Mon, 12 Sep 2022 23:34:28 GMT

Hi @Pooja Patel ,

Thanks for your reply. Could you have a look at my below comment and give further suggestions? Thanks.

The same connection works fine in other applications, like DbVisualizer.
Tried but still did not work.
The jar is 'snowflake-jdbc-3.13.1.jar' in path studio\configuration\.m2\repository\net\snowflake\snowflake-jdbc\3.13.1.
The Talend version is '8.0.1.20211109_1610'

Re: ‘Save failed’ error when create metadata connection from snowflake

Anonymous — Wed, 14 Sep 2022 08:22:37 GMT

Hello,

Did you install your studio completely? Does this issue only repro when create metadata connection from snowflake? Have you tried to set up other DB connection in metadata successfully in your current Talend '8.0.1'?

Best regards

Sabrina

topic Re: ‘Save failed’ error when create metadata connection from snowflake in Talend Studio

‘Save failed’ error when create metadata connection from snowflake

Re: ‘Save failed’ error when create metadata connection from snowflake

Re: ‘Save failed’ error when create metadata connection from snowflake

Re: ‘Save failed’ error when create metadata connection from snowflake

Re: ‘Save failed’ error when create metadata connection from snowflake