Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: could understand this error

  1. #1

    Default could understand this error

    hello to all, could someone say to me what this error means :

    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Because of an error this step can't continue:
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Error inserting 'unknown' row in dimension [DIMENSION_CUSTOMER] : SELECT count(*) FROM DIMENSION_CUSTOMER WHERE CUSTOMER_SK = 0
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Field 'CUSTOMER_ID' doesn't have a default value
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : be.ibridge.kettle.core.exception.KettleDatabaseException:
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Error inserting 'unknown' row in dimension [DIMENSION_CUSTOMER] : SELECT count(*) FROM DIMENSION_CUSTOMER WHERE CUSTOMER_SK = 0
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Field 'CUSTOMER_ID' doesn't have a default value
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) :
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.core.database.Database.checkDimZero(Database.java:3930)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:108)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:658)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.trans.step.dimensionlookup.DimensionLookup.run(DimensionLookup.java:747)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : Caused by: java.sql.SQLException: Field 'CUSTOMER_ID' doesn't have a default value
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1074)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1008)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : at be.ibridge.kettle.core.database.Database.checkDimZero(Database.java:3926)
    2007/12/05 10:30:23 - LKP_DIMENSION_CUSTOMER.0 - ERROR (version 2.5.0, build 25002 from 2007/05/04 00:20:04) : ... 3 more



    thanks
    mata123

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

    Default

    It means that CUSTOMER_ID should also be included somewhere in the insert query/dimension lookup... You're probably running on MySQL.

    Regards,
    Sven

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

    Default

    It's not included if you define auto-increment key generation. If you don't have an auto-increment integer for customer_id, this is the error you would get.

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.