Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: 3.0.0RC1: Unable to get queryfields for SQL

  1. #1

    Default 3.0.0RC1: Unable to get queryfields for SQL

    I have setup 3.0.0RC1 and created two pgsql db conn to two diff db tables. One input, one output. So I create simple transform:
    TABLEINPUT ---->---- SELECTVALUES --->--- TABLEOUTPUT

    When I bring up SelectValues and click on Get fields to select, I see this error:

    Unable to get queryfields for SQL:
    null

    Couldn't get field info in part [exec query]
    at org.pentaho.di.ui.spoon.Spoon.main (Spoon.java:359)
    at org.pentaho.di.ui.spoon.Spoon.run (Spoon.java:5457)
    at org.pentaho.di.ui.spoon.Spoon.start (Spoon.java:5378)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch (Spoon.java:811)
    at org.eclipse.swt.widgets.Display.readAndDispatch (null:-1)
    at org.eclipse.swt.widgets.Display.runDeferredEvents (null:-1)
    at org.eclipse.swt.widgets.Widget.sendEvent (null:-1)
    at org.eclipse.swt.widgets.EventTable.sendEvent (null:-1)
    at org.eclipse.swt.widgets.TypedListener.handleEvent (null:-1)
    at org.pentaho.di.ui.spoon.trans.TransGraph$4.mouseDoubleClick (TransGraph.java:316)
    at org.pentaho.di.ui.spoon.trans.TransGraph.access$100 (TransGraph.java:120)
    at org.pentaho.di.ui.spoon.trans.TransGraph.editStep (TransGraph.java:2145)
    at org.pentaho.di.ui.spoon.Spoon.editStep (Spoon.java:6145)
    at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep (SpoonStepsDelegate.java:111)
    at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.open (SelectValuesDialog.java:460)
    at org.eclipse.swt.widgets.Display.readAndDispatch (null:-1)
    at org.eclipse.swt.widgets.Display.runDeferredEvents (null:-1)
    at org.eclipse.swt.widgets.Widget.sendEvent (null:-1)
    at org.eclipse.swt.widgets.EventTable.sendEvent (null:-1)
    at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog$2.handleEvent (SelectValuesDialog.java:144)
    at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.access$100 (SelectValuesDialog.java:76)
    at org.pentaho.di.ui.trans.steps.selectvalues.SelectValuesDialog.get (SelectValuesDialog.java:620)
    at org.pentaho.di.trans.TransMeta.getPrevStepFields (TransMeta.java:1573)
    at org.pentaho.di.trans.TransMeta.getPrevStepFields (TransMeta.java:1584)
    at org.pentaho.di.trans.TransMeta.getPrevStepFields (TransMeta.java:1610)
    at org.pentaho.di.trans.TransMeta.getStepFields (TransMeta.java:1562)
    at org.pentaho.di.trans.TransMeta.getThisStepFields (TransMeta.java:1707)
    at org.pentaho.di.trans.steps.tableinput.TableInputMeta.getFields (TableInputMeta.java:255)
    at org.pentaho.di.core.database.Database.getQueryFields (Database.java:1773)
    at org.pentaho.di.core.database.Database.getQueryFields (Database.java:2184)
    at org.pentaho.di.core.database.DatabaseMeta.stripCR (DatabaseMeta.java:1397)
    at java.lang.StringBuffer.<init> (null:-1)
    Both db conn have tested OK. Am I missing some step? How do I get list of fields?

    Gerry

  2. #2

    Default

    Ok, you need to put some SQL statement in the box. Now I can see list of fields.

    Gerry

  3. #3
    Join Date
    May 2006
    Posts
    4,882

    Default

    lol ... if you press "get fields" the step will ask the previous step for its output fields, that one will ask its predecessor for their fields, ... If you don't enter a query in the table input the step won't know what to return. Maybe the "error message" could be more clear.

    Regards,
    Sven

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Improved error message added in revision 5330.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.