Cannot Save Snowflake Connection

rajesh_tup · ‎2023-03-15

Hi Team,

I am trying to connect to Snowflake and insert/Retrieve data from it for the connection purpose I use SnowFlake in MetaData section I have given all the details correctly and the connection is successful , when I click on Finish it shows Save Failed! error with below details

When I try with Snowflake Input component the connection gets successful but when I run Nothing happens

I use Talend 8.0.1

Snowflake JDBC Version 3.13

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

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

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}

I tried with JDK 19/JDK 1.8/JDK 11 still I get the above error, please help

Anonymous · ‎2023-03-16

Hello,

You should be using v11 of the Java jdk.

JDK v19 is not supported for Talend open studio V 8 at the moment. That may not be issue here, but it also could be.

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

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

In addition to that, please make sure there is no problem with the same login on other DB tools (DBeaver -->Connection, listing, select) and no a firewall problem from your end.

Best regards

Sabrina

rajesh_tup · ‎2023-03-16

Thanks, I have tried with v11 of the Java JDK also, will ask DBA's to check the permission

Anonymous · ‎2023-03-16

Hello,

Don't hesitate to post your issue here.

Best regards

Sabrina

rajesh_tup · ‎2023-03-16

Hi

We have tried to give highest permission for the user ACCOUNTADMIN / SYSADMIN both of it did not work out, it is connecting but I am not able to save the connection

Anonymous · ‎2023-03-16

Hello,

Could you please post your studio log here which will be helpful for us to address your issue?

It is located in <Talend Studio installation path>/workspace/.metadata/.log

Best regards

Sabrina

shusant · ‎2024-04-24

I am also encountering the same issue. I am using Java 11, with talend version 8.0.1.
Please find my log below:

!ENTRY org.talend.platform.logging 4 0 2024-04-24 10:12:32.580

!MESSAGE 2024-04-24 10:12:32,571 ERROR org.talend.commons.exception.CommonExceptionHandler - Error when saving the connection

!STACK 1