Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
piexpert
Partner - Contributor
Partner - Contributor

‘Save failed’ error when create metadata connection from snowflake

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

0695b00000Uz0EZAAZ.png 

2. Save failed error

0695b00000Uz0EeAAJ.png 

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

Labels (2)
4 Replies
ppatel
Contributor III
Contributor III

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?

ppatel
Contributor III
Contributor III

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

piexpert
Partner - Contributor
Partner - Contributor
Author

Hi @Pooja Patel​ ,

 

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

 

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

 

Anonymous
Not applicable

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