Unable to connect Snowflake

[jenn3]

Hello,

I have a problem accessing Snowflake data.

When I create a Snowflake metadata and test the connection, everything is OK.

I visualize the tables of my database.

However, the setting cannot be saved ("Failed to save").

Can you help me please ?

[jenn3]

Now, I'm using Java jdk v11 but still the same error

[Anonymous]

OK. This is strange. I am running this version and have no issue here at all. Never have. This is the reason I wanted to make sure you are running a fully supported environment. Can you go to your workspace folder, then go to the .metadata folder and add your log here for me to look at? Before you do this, take a quick look and make sure there is nothing private in there that you are not comfortable with sharing.

[Charly1]

I got this log :

Échec de la sauvegarde.

 org.eclipse.core.runtime.CoreException: Error when saving the connection

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

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

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

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

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

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

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

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

   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.GenericAction.doRun(GenericAction.java:71)

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

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

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

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

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

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

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

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

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

   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(Unknown Source)

   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

   at java.lang.reflect.Method.invoke(Unknown Source)

   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)

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

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

   ... 51 more

 Caused by: java.lang.reflect.InvocationTargetException

   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

   at java.lang.reflect.Method.invoke(Unknown Source)

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

   ... 55 more

 Caused by: org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION

   at org.talend.components.common.avro.JDBCAvroRegistry$1.apply(JDBCAvroRegistry.java:57)

   at org.talend.components.common.avro.JDBCAvroRegistry$1.apply(JDBCAvroRegistry.java:47)

   at org.talend.daikon.avro.AvroRegistry.inferSchema(AvroRegistry.java:154)

   at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getSchema(SnowflakeSourceOrSink.java:230)

   at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getEndpointSchema(SnowflakeSourceOrSink.java:205)

   at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getSchema(SnowflakeSourceOrSink.java:200)

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

   ... 60 more

 Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: Timeout waiting for the download of chunk #0(Total chunks: 1).

   at net.snowflake.client.jdbc.SnowflakeChunkDownloader.getNextChunkToConsume(SnowflakeChunkDownloader.java:397)

   at net.snowflake.client.core.SFResultSet.fetchNextRowUnsorted(SFResultSet.java:200)

   at net.snowflake.client.core.SFResultSet.fetchNextRow(SFResultSet.java:156)

   at net.snowflake.client.core.SFResultSet.next(SFResultSet.java:247)

   at net.snowflake.client.jdbc.SnowflakeResultSetV1.next(SnowflakeResultSetV1.java:73)

   at net.snowflake.client.jdbc.SnowflakeDatabaseMetaData$3.next(SnowflakeDatabaseMetaData.java:1531)

   at org.talend.components.common.avro.JDBCAvroRegistry.inferSchemaResultSet(JDBCAvroRegistry.java:112)

   at org.talend.components.common.avro.JDBCAvroRegistry$1.apply(JDBCAvroRegistry.java:55)

   ... 66 more

[Anonymous]

Hi @Charly MEDINA​,

I have been looking into this to see if I can recreate it. Unfortunately I cannot recreate this. However, I have found something that could provide a solution. If you take a look at this question in Community (https://community.talend.com/s/question/0D53p00007vCmYZCA0/save-failed-error-with-snowflake-metadata) you will see that the symptoms look pretty much the same and the user has provided a solution. Can you try this?

[jenn3]

This is my logs

[Anonymous]

It says you are using java.version=18.0.2.1. Java 18 is not supported.

After changing your Java version to 11, can you try the solution suggested here?

https://community.talend.com/s/question/0D53p00007vCmYZCA0/save-failed-error-with-snowflake-metadata

[Charly1 · Accepted solution]

Hello,

Thanks for your help!

That was a firewall problem... I try outside my compagnie, all works fine with same talend & java version.

I call my network support for open snowflake ip on our firewall and all work fine !

Regards

Charly