Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: dimension lookup

  1. #1

    Default dimension lookup

    Hi,

    In my source table I have three fields brand_name,code,abbreviation

    and my dimension table contains
    brand_dm_key(pk),brand_name,code,abbreviation_lbl.

    All fields are not null.

    version column are there in source and dimension table.

    While running I get the following error.

    Error inserting 'unknown' row in dimension [TEST_DM] : insert into TEST_DM(BRAND_DM_KEY, version) values (0, 1)
    Couldn't execute SQL: insert into TEST_DM(BRAND_DM_KEY, version) values (0, 1)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) :
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : ORA-01400: cannot insert NULL into ("MART"."TEST_DM"."BRAND_NAME")
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) :
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) :
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.checkDimZero(DimensionLookup.java:1189)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:176)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1267)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : Couldn't execute SQL: insert into TEST_DM(BRAND_DM_KEY, version) values (0, 1)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) :
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : ORA-01400: cannot insert NULL into ("MART"."TEST_DM"."BRAND_NAME")
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) :
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1547)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1493)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.checkDimZero(DimensionLookup.java:1185)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : ... 3 more
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("MART"."TEST_DM"."BRAND_NAME")
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1516)
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : ... 5 more
    2008/11/13 11:28:35 - Dimension lookup/update.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)

    I'm attaching my transformation,please send me solution ASAP

    preetha
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2007
    Posts
    17

    Default

    Did you include a version field in your dimension?


    Error inserting 'unknown' row in dimension [TEST_DM] : insert into TEST_DM(BRAND_DM_KEY, version) values (0, 1)

    the line above suggests something like that.

    Cheers Kees

  3. #3

    Default

    yes..version field is there in the dimension.By changing all the not null columns to null ,it is working but only inserting,not updating.

    can anyone help me?

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.