Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Dimension Lookup/Update Nullpointer Exception

  1. #1
    Join Date
    Sep 2011
    Posts
    190

    Question Dimension Lookup/Update Nullpointer Exception

    As of today one of my many Dimension Lookup/Update steps fails with a Nullpointer Exception.

    This is in PDI 4.2.1 CE.

    It looks slightly like issues http://jira.pentaho.com/browse/PDI-4816 and http://jira.pentaho.com/browse/PDI-7235 although not exactly as I have cache switched off.

    As it's been running fine up to now, one can assume it's a data issue?
    Any work-arounds while waiting for Fix Versions 4.4.0, 4.4.1 or 4.8.0 are realeased?

    TIA!

    Code:
    INFO  14-09 10:45:41,685 - Dimension lookup/update Hist SOURCEdb productline - Starting to run...
    INFO  14-09 10:45:41,685 - companydwh_vul_hist_productline - Transformation has allocated 2 threads and 1 rowsets.
    INFO  14-09 10:45:41,687 - Table input Bron SOURCEdb productline - SQL query : select /*! SQL_NO_CACHE */ *
    FROM productline
    where dwhlastmodified >= DATE_ADD( CURRENT_DATE, interval -5 DAY)
    
    
    INFO  14-09 10:45:41,835 - Dimension lookup/update Hist SOURCEdb productline - Dimension Lookup setting preparedStatement to [SELECT `productlineKey`, `hist_version`, `version`, `deleted`, `productLineTemplate_id`, `legalCompany_id`, `startDate`, `endDate`, `riskTakeOver`, `neutralInterestPeriod`, `type`, `factoringType`, `name`, `description` FROM `productline` WHERE `id` = ?  AND ? >= `date_from`
     AND ? < `date_to`
    ]
    INFO  14-09 10:45:41,836 - Dimension lookup/update Hist SOURCEdb productline - Finished preparing dimension lookup statement.
    DEBUG 14-09 10:45:41,842 - Dimension lookup/update Hist SOURCEdb productline - lookup row : [97], [2012/09/14 10:45:40.481], [2012/09/14 10:45:40.481]
    DEBUG 14-09 10:45:41,862 - Dimension lookup/update Hist SOURCEdb productline - Dimension entry found : [1], [null], [2], [null], [null], [1], [2000/01/01 00:00:00.000], [null], [N], [56], [TEMPLATE], [FACTORING], [Full Factoring], [Full Factoring]
    DEBUG 14-09 10:45:41,862 - Dimension lookup/update Hist SOURCEdb productline - Comparing version Integer(15) and version Integer(15) (cmp=0) --> identical=true, insert=false, punch=false
    DEBUG 14-09 10:45:41,863 - Dimension lookup/update Hist SOURCEdb productline - Comparing deleted Boolean and deleted Boolean (cmp=0) --> identical=true, insert=false, punch=false
    DEBUG 14-09 10:45:41,863 - Dimension lookup/update Hist SOURCEdb productline - Comparing productLineTemplate_id Integer(15) and productLineTemplate_id Integer(15) (cmp=0) --> identical=true, insert=false, punch=false
    DEBUG 14-09 10:45:41,863 - Dimension lookup/update Hist SOURCEdb productline - Comparing legalCompany_id Integer(15) and legalCompany_id Integer(15) (cmp=0) --> identical=true, insert=false, punch=false
    DEBUG 14-09 10:45:41,863 - Dimension lookup/update Hist SOURCEdb productline - Comparing startDate Date and startDate Date (cmp=0) --> identical=true, insert=false, punch=false
    DEBUG 14-09 10:45:41,863 - Dimension lookup/update Hist SOURCEdb productline - Comparing endDate Date and endDate Date (cmp=0) --> identical=true, insert=false, punch=false
    DEBUG 14-09 10:45:41,863 - Dimension lookup/update Hist SOURCEdb productline - Comparing riskTakeOver Boolean and riskTakeOver Boolean (cmp=1) --> identical=false, insert=true, punch=false
    DEBUG 14-09 10:45:41,863 - Dimension lookup/update Hist SOURCEdb productline - Comparing neutralInterestPeriod Integer(9) and neutralInterestPeriod Integer(9) (cmp=0) --> identical=false, insert=true, punch=false
    DEBUG 14-09 10:45:41,863 - Dimension lookup/update Hist SOURCEdb productline - Comparing type String and type String(255) (cmp=0) --> identical=false, insert=true, punch=false
    DEBUG 14-09 10:45:41,864 - Dimension lookup/update Hist SOURCEdb productline - Comparing factoringType String and factoringType String(255) (cmp=0) --> identical=false, insert=true, punch=false
    DEBUG 14-09 10:45:41,864 - Dimension lookup/update Hist SOURCEdb productline - Comparing name String and name String(255) (cmp=3) --> identical=false, insert=true, punch=false
    DEBUG 14-09 10:45:41,864 - Dimension lookup/update Hist SOURCEdb productline - Comparing description String and description String(255) (cmp=38) --> identical=false, insert=true, punch=false
    DEBUG 14-09 10:45:41,864 - Dimension lookup/update Hist SOURCEdb productline - INSERT new version: val_key=1
    ERROR 14-09 10:45:41,864 - Dimension lookup/update Hist SOURCEdb productline - Unexpected error
    ERROR 14-09 10:45:41,864 - Dimension lookup/update Hist SOURCEdb productline - java.lang.NullPointerException
        at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:623)
        at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:221)
        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
        at java.lang.Thread.run(Thread.java:679)
    
    
    DEBUG 14-09 10:45:41,865 - Bron SOURCEdb - Statement canceled!
    DEBUG 14-09 10:45:41,865 - Table input Bron SOURCEdb productline - Stopped while putting a row on the buffer
    DEBUG 14-09 10:45:41,891 - Bron SOURCEdb - Statement canceled!
    DEBUG 14-09 10:45:41,891 - Bron SOURCEdb - Statement canceled!
    DEBUG 14-09 10:45:41,891 - Hist SOURCEdb - Rollback on database connection [Hist SOURCEdb]
    DEBUG 14-09 10:45:41,908 - Bron SOURCEdb - Statement canceled!
    INFO  14-09 10:45:41,908 - Table input Bron SOURCEdb productline - Finished reading query, closing connection.
    DEBUG 14-09 10:45:41,908 - Bron SOURCEdb - Commit on database connection [Bron SOURCEdb]
    INFO  14-09 10:45:41,908 - Bron SOURCEdb - Connection to database closed!
    INFO  14-09 10:45:41,908 - Table input Bron SOURCEdb productline - Finished processing (I=800, O=0, R=0, W=798, U=0, E=0)
    Last edited by mbvt; 09-14-2012 at 06:15 AM.

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.