Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-11097

Dimension Lookup / Update Step disables 'Version field'

    Details

    • Type: Bug
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.0.1 GA
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
    • Environment:
      Kettle - Spoon General Availability Release - 5.0.1-stable
      Build version : 5.0.1-stable
      Build date : 2013-11-15_16-08-58
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Ubuntu 12.x (64-bit)

      Description

      When using the "Dimension Lookup/Update" step in Lookup mode, the UI disables the "Version field" dropdown list, but if the wrong value is specified, the step will fail with an error.

      The version field is not necessary for a lookup-only situation, and users have to modify other step settings in order to specify a valid field name for Version.

      Workaround:
      Check the 'Update the dimension?' checkbox, set the 'Version field', uncheck the box again. It is evaluated then despite being greyed out.

      Reproduction Steps:

      1. Download the attached transformation
      2. Run the SQL statements embedded in the transformation as a note
      3. Preview the transformation (at the Dummy step)

      Expected Result: 2 rows are returned, with values for Anytown Mart v2 and Hometown Delights store names
      Actual Result: The transformation fails with an error

      2015/06/08 13:06:39 - Dimension lookup/update.0 - ERROR (version 5.4.0.0-128, build 1 from 2015-06-03_13-41-59 by buildguy) : Because of an error this step can't continue: 
      2015/06/08 13:06:39 - Dimension lookup/update.0 - Error looking up row in database
      2015/06/08 13:06:39 - Dimension lookup/update.0 - Unknown column 'version' in 'field list'
      2015/06/08 13:06:39 - Dimension lookup/update.0 - ERROR (version 5.4.0.0-128, build 1 from 2015-06-03_13-41-59 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
      2015/06/08 13:06:39 - Dimension lookup/update.0 - Error looking up row in database
      2015/06/08 13:06:39 - Dimension lookup/update.0 - Unknown column 'version' in 'field list'
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at org.pentaho.di.core.database.Database.getLookup(Database.java:2740)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at org.pentaho.di.core.database.Database.getLookup(Database.java:2717)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:448)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:230)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at java.lang.Thread.run(Thread.java:745)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'version' in 'field list'
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at sun.reflect.GeneratedConstructorAccessor137.newInstance(Unknown Source)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.Util.getInstance(Util.java:360)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
      2015/06/08 13:06:39 - Dimension lookup/update.0 - 	at org.pentaho.di.core.database.Database.getLookup(Database.java:2724)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sniechzial Simon Niechzial
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: