Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Save Failed! - Error With Snowflake Metadata

Hello, 

 

I am trying to connect to snowflake and import some table metadata. Test Connection Returns Success but i am getting the following message : 

"Save Failed!" with a bunch of Java output which I dont understand. Please can someone point me to the correct way of importing snowflake metadata ? 

Details : Talend V7.1 
Details on Error : 
Save failed!
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:673)
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:3496)
at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:2312)
at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:686)
at org.talend.repository.viewer.action.RepoDoubleClickAction.executeAction(RepoDoubleClickAction.java:252)
at org.talend.repository.viewer.action.RepoDoubleClickAction.run(RepoDoubleClickAction.java:141)
at org.eclipse.ui.actions.RetargetAction.run(RetargetAction.java:229)
at org.eclipse.ui.navigator.CommonNavigatorManager$3.open(CommonNavigatorManager.java:185)
at org.eclipse.ui.OpenAndLinkWithEditorHelper$InternalListener.open(OpenAndLinkWithEditorHelper.java:48)
at org.eclipse.jface.viewers.StructuredViewer$2.run(StructuredViewer.java:853)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:50)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:178)
at org.eclipse.jface.viewers.StructuredViewer.fireOpen(StructuredViewer.java:850)
at org.eclipse.jface.viewers.StructuredViewer.handleOpen(StructuredViewer.java:1142)
at org.eclipse.ui.navigator.CommonViewer.handleOpen(CommonViewer.java:462)
at org.eclipse.jface.viewers.StructuredViewer$6.handleOpen(StructuredViewer.java:1249)
at org.eclipse.jface.util.OpenStrategy.fireOpenEvent(OpenStrategy.java:278)
at org.eclipse.jface.util.OpenStrategy.access$2(OpenStrategy.java:272)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:313)
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)
... 63 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)
... 67 more
Caused by: org.apache.avro.SchemaParseException: Illegal initial character: 691_SALEABLEBIN_INVENTORY_ZER
at org.apache.avro.Schema.validateName(Schema.java:1147)
at org.apache.avro.Schema.access$200(Schema.java:81)
at org.apache.avro.Schema$Name.<init>(Schema.java:489)
at org.apache.avro.Schema.createRecord(Schema.java:161)
at org.apache.avro.SchemaBuilder$RecordBuilder.fields(SchemaBuilder.java:1732)
at org.talend.core.model.metadata.MetadataToolAvroHelper.convertToAvro(MetadataToolAvroHelper.java:59)
at org.talend.designer.core.generic.utils.SchemaUtils.convertTalendSchemaIntoComponentSchema(SchemaUtils.java:260)
at org.talend.designer.core.generic.utils.SchemaUtils.updateComponentSchema(SchemaUtils.java:307)
at org.talend.designer.core.generic.utils.SchemaUtils.updateComponentSchema(SchemaUtils.java:299)
at org.talend.designer.core.generic.utils.SchemaUtils.createSchema(SchemaUtils.java:232)
at org.talend.repository.generic.persistence.GenericRepository.storeProperties(GenericRepository.java:79)
at org.talend.repository.generic.persistence.GenericRepository.storeProperties(GenericRepository.java:1)
at org.talend.components.snowflake.SnowflakeTableListProperties.afterFormFinishMain(SnowflakeTableListProperties.java:103)
... 72 more

 

Many Thanks in Advance! 
Thanks, 

Som

Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello All,

 

Found the solution - this error is related to permission on schema set by DBA. 

Also sometimes this error is thrown when I try to import metadata for too many tables at once. 

 

I requested Snowflake DBA to set my permissions ( on the new schema ) same as "Public" schema and I was able to save the metadata.

 

Thanks,

- Som

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hello All,

 

Found the solution - this error is related to permission on schema set by DBA. 

Also sometimes this error is thrown when I try to import metadata for too many tables at once. 

 

I requested Snowflake DBA to set my permissions ( on the new schema ) same as "Public" schema and I was able to save the metadata.

 

Thanks,

- Som

ASekar1672390878
Contributor
Contributor

Hi Som,

 

I am facing the same problem , can you explain in brief the steps taken to solve this problem?

 

Thanks in advance