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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Table Schema Disappear

In TOS GUI, metadata->dbconnections I have retrieved schema of certain tables. Then I can re-use them as inputs. However, I have also built queries, and when I edit and save queries, all the previous table definitions disappear from the GUI. I don't understand why, this seems to be a bug.  Am I doing something wrong?

 

On Build 6.4.1.20170623_1246 MySQL5. 

Labels (2)
5 Replies
Anonymous
Not applicable
Author

Hello,

Did you follow up online document about:TalendHelpCenter:Centralizing database metadata

 to set up your DB connection and retrieve table schema?

Best regards

Sabrina

Anonymous
Not applicable
Author

Yes, and the table metadata is created going through that process. However, later on on the same session all the tables will just disappear from the tree. 

Anonymous
Not applicable
Author

Hello,

Could you please open error log to see if there is any message?

In your Studio, click Window to open the menu, then select Show View->General->Error Log. Once you see an error, double click it.

Best regards

Sabrina

Anonymous
Not applicable
Author

I isolated when it happens. The Tables disappear when a query is edited and
saved. It might be related to having the workspace on a shared drive, but I
cannot be sure. There is no error created on the query save, there was one
however earlier, when opening the query editor:


eclipse.buildId=unknown
java.version=1.8.0_151
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86_64

org.talend.platform.logging
Warning
Fri Jun 01 09:12:31 PDT 2018
2018-06-01 09:12:31,541 WARN
org.talend.commons.exception.CommonExceptionHandler -
org.eclipse.emf.ecore.resource.Resource$IOWrappedException: The object
'orgomg.cwm.resource.relational.impl.SchemaImpl@4a8cf621 (name: ,
visibility: vk_public)' is not contained in a resource.


org.talend.commons.exception.PersistenceException:
org.eclipse.emf.ecore.resource.Resource$IOWrappedException: The object
'orgomg.cwm.resource.relational.impl.SchemaImpl@4a8cf621 (name: ,
visibility: vk_public)' is not contained in a resource.
at
org.talend.commons.runtime.model.emf.EmfHelper.saveResource(EmfHelper.java:221)
at
org.talend.commons.runtime.model.emf.EmfHelper.saveResource(EmfHelper.java:199)
at
org.talend.core.repository.utils.XmiResourceManager.saveResource(XmiResourceManager.java:646)
at
org.talend.repository.localprovider.model.LocalRepositoryFactory.save(LocalRepositoryFactory.java:2481)
at
org.talend.core.repository.model.ProxyRepositoryFactory.save(ProxyRepositoryFactory.java:1364)
at
org.talend.core.repository.model.ProxyRepositoryFactory.save(ProxyRepositoryFactory.java:1359)
at
org.talend.sqlbuilder.repository.utility.SQLBuilderRepositoryNodeManager.saveMetaData(SQLBuilderRepositoryNodeManager.java:1002)
at
org.talend.sqlbuilder.repository.utility.SQLBuilderRepositoryNodeManager.saveEMFQuery(SQLBuilderRepositoryNodeManager.java:941)
at
org.talend.sqlbuilder.repository.utility.SQLBuilderRepositoryNodeManager.saveQuery(SQLBuilderRepositoryNodeManager.java:970)
at
org.talend.sqlbuilder.ui.AbstractSQLEditorComposite.doSaveSQL(AbstractSQLEditorComposite.java:205)
at
org.talend.sqlbuilder.actions.SaveAsSQLAction.run(SaveAsSQLAction.java:78)
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$6.handleEvent(ActionContributionItem.java:462)
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.sqlbuilder.actions.EditQueriesAction.doRun(EditQueriesAction.java:171)
at
org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:632)
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:3369)
at
org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:2119)
at
org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:641)
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:255)
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.eclipse.emf.ecore.resource.Resource$IOWrappedException: The
object 'orgomg.cwm.resource.relational.impl.SchemaImpl@4a8cf621 (name: ,
visibility: vk_public)' is not contained in a resource.
at org.eclipse.emf.ecore.xmi.impl.XMLSaveImpl.endSave(XMLSaveImpl.java:301)
at org.eclipse.emf.ecore.xmi.impl.XMLSaveImpl.save(XMLSaveImpl.java:265)
at
org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.doSave(XMLResourceImpl.java:389)
at
org.eclipse.emf.ecore.resource.impl.ResourceImpl.save(ResourceImpl.java:1430)
at
org.eclipse.emf.ecore.resource.impl.ResourceImpl.save(ResourceImpl.java:999)
at
org.talend.commons.runtime.model.emf.EmfHelper.saveResource(EmfHelper.java:215)
... 58 more
Caused by: org.eclipse.emf.ecore.xmi.DanglingHREFException: The object
'orgomg.cwm.resource.relational.impl.SchemaImpl@4a8cf621 (name: ,
visibility: vk_public)' is not contained in a resource.
at
org.eclipse.emf.ecore.xmi.impl.XMLHelperImpl.handleDanglingHREF(XMLHelperImpl.java:754)
at
org.eclipse.emf.ecore.xmi.impl.XMLHelperImpl.getURIFragment(XMLHelperImpl.java:725)
at
org.eclipse.emf.ecore.xmi.impl.XMLHelperImpl.getIDREF(XMLHelperImpl.java:747)
at
org.eclipse.emf.ecore.xmi.impl.XMLSaveImpl.saveIDRefMany(XMLSaveImpl.java:2023)
at
org.eclipse.emf.ecore.xmi.impl.XMLSaveImpl.saveFeatures(XMLSaveImpl.java:1370)
at
org.eclipse.emf.ecore.xmi.impl.XMLSaveImpl.saveFeatures(XMLSaveImpl.java:1224)
at
org.eclipse.emf.ecore.xmi.impl.XMLSaveImpl.saveElementID(XMLSaveImpl.java:2716)
at
org.eclipse.emf.ecore.xmi.impl.XMISaveImpl.writeTopObjects(XMISaveImpl.java:84)
at org.eclipse.emf.ecore.xmi.impl.XMLSaveImpl.traverse(XMLSaveImpl.java:595)
at org.eclipse.emf.ecore.xmi.impl.XMLSaveImpl.save(XMLSaveImpl.java:251)
... 62 more



Anonymous
Not applicable
Author

Hello,

Could you please give us some trouble screenshots of your issue? Does this issue also repro on other build version? V 6.5, V 7.0.

Best regards

Sabrina