Preview data fails for JBDS7.0.0.GA and Teiid Designer 8.2.0.Final ------------------------------------------------------------------ Key: TEIIDDES-1866 URL: https://issues.jboss.org/browse/TEIIDDES-1866 Project: Teiid Designer Issue Type: Feature Request Components: Data Preview Affects Versions: 8.2 Environment: java.version=1.7.0_60 openjdk, JBDS 7.0.0.GA, Teiid Designer 8.2.0.Final and 8.2.0.Nightly-v20130919, JBoss AS 7.1, Teiid 8.3.0.Final Reporter: Lucie Fabrikova Previewing a table (after starting server, creating data sources) causes exceptions: - 8.2.0.Final: Validate the JDBC username and password in the default Teiid instance. [1] - 8.2.0.Nightly-v20130919: Error running preview [2] [1] org.teiid.jdbc.TeiidSQLException: TEIID40046 VDB "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_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:1) at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:103) 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:81) 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:620) at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:397) at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:262) at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99) at org.eclipse.jface.action.Action.runWithEvent(Action.java:499) 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:1392) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3742) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3363) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997) at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:138) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:610) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150) 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:354) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591) at org.eclipse.equinox.launcher.Main.run(Main.java:1450) at org.eclipse.equinox.launcher.Main.main(Main.java:1426) Caused by: org.teiid.net.ConnectionException: TEIID40046 VDB "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_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) ... 43 more Caused by: org.teiid.client.security.LogonException: TEIID40046 VDB "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_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:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) Caused by: org.teiid.dqp.service.SessionServiceException: TEIID40046 VDB "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_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 [2] 16:41:27,602 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC00001: Failed to start service jboss.deployment.unit."PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb".STRUCTURE: org.jboss.msc.service.StartException in service jboss.deployment.unit."PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb".STRUCTURE: Failed to process phase STRUCTURE of deployment "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb" at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_60] at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_60] Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: Failed to mount deployment content at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:91) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] ... 5 more Caused by: java.util.zip.ZipException: zip file is empty at java.util.zip.ZipFile.open(Native Method) [rt.jar:1.7.0_60] at java.util.zip.ZipFile.<init>(ZipFile.java:215) [rt.jar:1.7.0_60] at java.util.zip.ZipFile.<init>(ZipFile.java:145) [rt.jar:1.7.0_60] at java.util.jar.JarFile.<init>(JarFile.java:153) [rt.jar:1.7.0_60] at java.util.jar.JarFile.<init>(JarFile.java:117) [rt.jar:1.7.0_60] at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:97) at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:83) at org.jboss.vfs.VFS.mountZip(VFS.java:408) at org.jboss.vfs.VFS.mountZip(VFS.java:434) at org.jboss.as.server.deployment.DeploymentMountProvider$Factory$ServerDeploymentRepositoryImpl.mountDeploymentContent(DeploymentMountProvider.java:95) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:87) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] ... 6 more 16:41:27,621 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015877: Stopped deployment PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb in 3ms 16:41:27,621 INFO [org.jboss.as.server] (management-handler-thread - 4) JBAS015870: Deploy of deployment "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb" was rolled back with failure message {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb\".STRUCTURE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb\".STRUCTURE: Failed to process phase STRUCTURE of deployment \"PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb\""}} 16:41:27,623 INFO [org.jboss.as.controller] (management-handler-thread - 4) JBAS014774: Service status report JBAS014777: Services which failed to start: service jboss.deployment.unit."PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb".STRUCTURE: org.jboss.msc.service.StartException in service jboss.deployment.unit."PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb".STRUCTURE: Failed to process phase STRUCTURE of deployment "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_WSDLImport_project.vdb" 16:41:57,136 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb" 16:41:57,138 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-3) MSC00001: Failed to start service jboss.deployment.unit."PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb".STRUCTURE: org.jboss.msc.service.StartException in service jboss.deployment.unit."PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb".STRUCTURE: Failed to process phase STRUCTURE of deployment "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb" at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_60] at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_60] Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: Failed to mount deployment content at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:91) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] ... 5 more Caused by: java.util.zip.ZipException: zip file is empty at java.util.zip.ZipFile.open(Native Method) [rt.jar:1.7.0_60] at java.util.zip.ZipFile.<init>(ZipFile.java:215) [rt.jar:1.7.0_60] at java.util.zip.ZipFile.<init>(ZipFile.java:145) [rt.jar:1.7.0_60] at java.util.jar.JarFile.<init>(JarFile.java:153) [rt.jar:1.7.0_60] at java.util.jar.JarFile.<init>(JarFile.java:117) [rt.jar:1.7.0_60] at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:97) at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:83) at org.jboss.vfs.VFS.mountZip(VFS.java:408) at org.jboss.vfs.VFS.mountZip(VFS.java:434) at org.jboss.as.server.deployment.DeploymentMountProvider$Factory$ServerDeploymentRepositoryImpl.mountDeploymentContent(DeploymentMountProvider.java:95) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:87) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final] ... 6 more 16:41:57,148 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb in 0ms 16:41:57,151 INFO [org.jboss.as.server] (management-handler-thread - 4) JBAS015870: Deploy of deployment "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb" was rolled back with failure message {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb\".STRUCTURE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb\".STRUCTURE: Failed to process phase STRUCTURE of deployment \"PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb\""}} 16:41:57,154 INFO [org.jboss.as.controller] (management-handler-thread - 4) JBAS014774: Service status report JBAS014777: Services which failed to start: service jboss.deployment.unit."PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb".STRUCTURE: org.jboss.msc.service.StartException in service jboss.deployment.unit."PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb".STRUCTURE: Failed to process phase STRUCTURE of deployment "PREVIEW_48b67d3f-36b4-48e6-b0d9-02bc2eb791de_xx_project.vdb"