org.pentaho.di.core.exception.KettleDatabaseException: Error looking up row in database Unknown column 'version' in 'field list'

Pentaho BI Platform Tracking | Simon Niechzial | 3 years ago
  1. 0

    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:* # Download the attached transformation # Run the SQL statements embedded in the transformation as a note # 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 {noformat} 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) {noformat}

    Pentaho BI Platform Tracking | 3 years ago | Simon Niechzial
    org.pentaho.di.core.exception.KettleDatabaseException: Error looking up row in database Unknown column 'version' in 'field list'
  2. 0

    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:* # Download the attached transformation # Run the SQL statements embedded in the transformation as a note # 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 {noformat} 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) {noformat}

    Pentaho BI Platform Tracking | 3 years ago | Simon Niechzial
    org.pentaho.di.core.exception.KettleDatabaseException: Error looking up row in database Unknown column 'version' in 'field list'
  3. 0

    GitHub comment 12#161541759

    GitHub | 1 year ago | GoogleCodeExporter
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spring 4.3.0.RELEASE + Hibernate 5.2.0.Final - GeneratedValue on mysql

    Stack Overflow | 5 months ago | Guyb
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'searcherdb.hibernate_sequence' doesn't exist
  6. 0

    Reindex problem when admin portlets in Italian language

    GitHub | 2 years ago | linuxatico
    com.dotmarketing.exception.DotRuntimeException: Could not execute query

  1. Kialandei 1 times, last 1 week ago
  2. davidvanlaatum 8 times, last 2 months ago
  3. AndrewProg 2 times, last 3 months ago
  4. kuldeep 2 times, last 3 months ago
  5. tvrmsmith 1 times, last 4 months ago
27 more registered users
64 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Unknown column 'version' in 'field list'

    at sun.reflect.GeneratedConstructorAccessor137.newInstance()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.GeneratedConstructorAccessor137.newInstance(Unknown Source)
    2. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    3. java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    3 frames
  3. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
    2. com.mysql.jdbc.Util.getInstance(Util.java:360)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
    10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
    10 frames
  4. org.pentaho.di
    Database.getLookup
    1. org.pentaho.di.core.database.Database.getLookup(Database.java:2724)
    1 frame