1 Reply Latest reply on Apr 22, 2013 2:13 PM by mdrillin

    Does Preview Data work in 8.0?

    skethire

      I am using designer 8.0 with Teiid 8.3.  When I try to preview a table in my view model, I am seeing the following exception.   However, when I deploy/execute the same vdb, and run a query against the same table, it works just fine.  What am I missing here?

       

      Thanks

      Srini

       

      !ENTRY org.teiid.designer.dqp.ui 4 0 2013-04-22 12:48:45.929

      !MESSAGE TEIID40046 VDB "PREVIEW_1755cbbf-0ae3-434b-b490-8481384cd6fe_TEST_FEDERATED_VIEW_project" version "latest" does not exist.

      !STACK 0

      org.teiid.jdbc.TeiidSQLException: TEIID40046 VDB "PREVIEW_1755cbbf-0ae3-434b-b490-8481384cd6fe_TEST_FEDERATED_VIEW_project" version "latest" does not exist.

      at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

      at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

      at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)

      at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

      at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

      at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:86)

      at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

      at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

      at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)

      at org.teiid.datatools.connectivity.TeiidJDBCConnectionFactory.createConnection(TeiidJDBCConnectionFactory.java:23)

      at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

      at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

      at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.getSqlConnection(PreviewDataWorker.java:611)

      at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:398)

      at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:263)

      at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)

      at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)

      at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)

      at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)

      at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)

      at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)

      at org.eclipse.jface.window.Window.open(Window.java:801)

      at org.eclipse.ui.internal.views.log.EventDetailsDialog.open(EventDetailsDialog.java:180)

      at org.eclipse.ui.internal.views.log.EventDetailsDialogAction.run(EventDetailsDialogAction.java:98)

      at org.eclipse.ui.internal.views.log.LogView$15.doubleClick(LogView.java:535)

      at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:845)

      at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)

      at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)

      at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)

      at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:843)

      at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1477)

      at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1246)

      at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:249)

      at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:246)

      at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:307)

      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)

      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)

      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1022)

      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:916)

      at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)

      at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:585)

      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:540)

      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

      at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)

      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)

      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)

      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:629)

      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)

      at org.eclipse.equinox.launcher.Main.run(Main.java:1438)

      at org.eclipse.equinox.launcher.Main.main(Main.java:1414)

      Caused by: org.teiid.net.ConnectionException: TEIID40046 VDB "PREVIEW_1755cbbf-0ae3-434b-b490-8481384cd6fe_TEST_FEDERATED_VIEW_project" version "latest" does not exist.

      at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:139)

      at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:92)

      at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:312)

      at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)

      ... 62 more

      Caused by: org.teiid.client.security.LogonException: TEIID40046 VDB "PREVIEW_1755cbbf-0ae3-434b-b490-8481384cd6fe_TEST_FEDERATED_VIEW_project" version "latest" does not exist.

      at org.teiid.transport.LogonImpl.logon(LogonImpl.java:116)

      at org.teiid.transport.LogonImpl.logon(LogonImpl.java:82)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      at java.lang.reflect.Method.invoke(Method.java:597)

      at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87)

      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264)

      at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:166)

      at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:152)

      at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:210)

      at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:100)

      at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

      at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:783)

      at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:149)

      at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

      at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:783)

      at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)

      at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)

      at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)

      at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)

      at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)

      at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)

      at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)

      at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274)

      at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261)

      at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:351)

      at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:282)

      at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:202)

      at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)

      at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:44)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

      at java.lang.Thread.run(Thread.java:662)

      Caused by: org.teiid.dqp.service.SessionServiceException: TEIID40046 VDB "PREVIEW_1755cbbf-0ae3-434b-b490-8481384cd6fe_TEST_FEDERATED_VIEW_project" version "latest" does not exist.

      at org.teiid.services.SessionServiceImpl.getActiveVDB(SessionServiceImpl.java:259)

      at org.teiid.services.SessionServiceImpl.createSession(SessionServiceImpl.java:140)

      at org.teiid.transport.LogonImpl.logon(LogonImpl.java:99)

      ... 33 more