Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: dimension lookup

  1. #1

    Default dimension lookup

    Hi,

    While running my transformation, I'm getting the following error.....


    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : Unexpected error :
    2008/11/13 11:28:35 - Dimension lookup/update.0 - ERROR (version 3.1.0, build 826 from 2008/10/28 13:46:00) : 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) : Error inserting 'unknown' row in dimension [TEST_DM] : 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) : 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)



    Attaching my transformation...

    please any body help me...
    Attached Files Attached Files

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.