Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: error in dimension lookup/update

  1. #1
    Join Date
    Mar 2007
    Posts
    158

    Default error in dimension lookup/update

    I am getting this error in the dimension lookup/update step when tried to load fact table from a dimension. I unchek the update.
    Is this a bug???







    2007/04/23 13:32:00 - new_two - Dimension Lookup setting preparedStatement to [SELECT CUSTOMER_KEY, version, FIRST_NAME, LAST_NAME, PHONE_NUMBER, EMAIL, CITY, STATE_PROVINCE, ADDRESS, COUNTRY_NAME, ZIP_CODE, CREATED_DATE, MODIFIED_DATE, date_from, date_to FROM STAR_SCHEME.CUSTOMER_DIM WHERE CUSTOMER_ID = ? AND ? >= date_from AND ? < date_to]
    2007/04/23 13:32:00 - new_two - Finished preparing dimension lookup statement.
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : Because of an error this step cant continue: {0}
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : be.ibridge.kettle.core.exception.KettleDatabaseException:
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : Error looking up row in database (pstmt.executeQuery())
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : ORA-00904: "DATE_TO": invalid identifier
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) :
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at be.ibridge.kettle.core.database.Database.getLookup(Database.java:3671)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at be.ibridge.kettle.core.database.Database.getLookup(Database.java:3639)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at be.ibridge.kettle.core.database.Database.getLookup(Database.java:3629)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at be.ibridge.kettle.trans.step.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:212)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at be.ibridge.kettle.trans.step.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:652)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at be.ibridge.kettle.trans.step.dimensionlookup.DimensionLookup.run(DimensionLookup.java:741)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : Caused by: java.sql.SQLException: ORA-00904: "DATE_TO": invalid identifier
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : at be.ibridge.kettle.core.database.Database.getLookup(Database.java:3650)
    2007/04/23 13:32:00 - Dimension lookup/update.0 - ERROR (version 2.5.0-M2, build 37 from 2007/04/04 17:30:05) : ... 5 more
    2007/04/23 13:32:00 - new_two - Connection to database closed!
    2007/04/23 13:32:00 - Dimension lookup/update.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    2007/04/23 13:32:01 - Spoon - The transformation has finished!!

  2. #2
    Join Date
    Mar 2007
    Posts
    16

    Default the date_to column is missing in the CUSTOMER_DIM table

    Hi,
    the STAR_SCHEME.CUSTOMER_DIM table does not have the date_to column, so it odesn't look like a bug to me. Click on the SQL button within the Dimension L/U dialog, and Spoon will show the necessary DDL queries.
    HTH,

  3. #3
    Join Date
    Mar 2007
    Posts
    158

    Default

    The column CREATED_DATE and MODIFIED_DATE are created for filling the purpose of date from and date to attributes.

    pls guide me wat should I do?

  4. #4
    Join Date
    Mar 2007
    Posts
    16

    Default

    Then you need to put the name of these columns in the corresponding fields (see the attached picture).
    Attached Images Attached Images  

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.