Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1299

Displaying execution plan in empty SQL scrapbook displays error dialog

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 7.7.1, 7.8
    • 7.7
    • VDB & Execution
    • None
    • Hide

      See description.

      Show
      See description.

    Description

      As per documentation:
      1) In ModelExplorer, select a previewable item, then Rt-click > Modeling > Show Execution Plan
      2) In SQL Scrapbook, the Execution Plan is available after each query execution
      3) In SQL Scrapbook, Rt-click > Teiid_7.x > Get Execution Plan

      If the scrapbook contains a query string then everything is fine. An empty scrapbook causes an error dialog
      to be displayed and the following stack trace in the console:

      !ENTRY org.teiid.datatools.connectivity.ui 4 0 2012-04-10 13:37:53.554
      !MESSAGE An Error occurred fetching the Execution Plan.
      !STACK 0
      org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: Parser cannot parse an empty sql statement.
      at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
      at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
      at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:617)
      at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:70)
      at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:537)
      at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
      at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
      at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
      at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:220)
      at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:255)
      at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:616)
      at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:110)
      at $Proxy18.read(Unknown Source)
      at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:349)
      at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:335)
      at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:546)
      at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:338)
      at org.teiid.datatools.connectivity.ui.plan.TeiidExplainSQLActionDelegate.getExecutionPlan(TeiidExplainSQLActionDelegate.java:230)
      at org.teiid.datatools.connectivity.ui.plan.TeiidExplainSQLActionDelegate.run(TeiidExplainSQLActionDelegate.java:181)
      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:1258)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)
      at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)
      at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)
      at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)
      at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)
      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
      at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)
      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:344)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
      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:616)
      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
      at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
      at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
      Caused by: [TeiidProcessingException]Remote org.teiid.api.exception.query.QueryParserException: Parser cannot parse an empty sql statement.
      at org.teiid.query.parser.QueryParser.parseCacheHint(QueryParser.java:160)
      at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:481)
      at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276)
      at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
      at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
      at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
      at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
      at java.lang.Thread.run(Thread.java:679)

      Attachments

        Activity

          People

            parichar@redhat.com Paul Richardson
            parichar@redhat.com Paul Richardson
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: