Table Schema Disappear

Anonymous — Fri, 25 May 2018 16:07:05 GMT

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.

Re: Table Schema Disappear

Anonymous — Mon, 28 May 2018 05:17:10 GMT

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

Re: Table Schema Disappear

Anonymous — Tue, 29 May 2018 17:18:41 GMT

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.

Re: Table Schema Disappear

Anonymous — Fri, 01 Jun 2018 03:35:04 GMT

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

Re: Table Schema Disappear

Anonymous — Fri, 01 Jun 2018 17:18:48 GMT

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

Re: Table Schema Disappear

Anonymous — Wed, 06 Jun 2018 07:16:44 GMT

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

topic Table Schema Disappear in Talend Studio

Table Schema Disappear

Re: Table Schema Disappear

Re: Table Schema Disappear

Re: Table Schema Disappear

Re: Table Schema Disappear

Re: Table Schema Disappear