Table Schema Disappear

Five Stars

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. 

Moderator

Re: Table Schema Disappear

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Table Schema Disappear

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. 

Moderator

Re: Table Schema Disappear

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Table Schema Disappear

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



Moderator

Re: Table Schema Disappear

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.