Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Null pointer exception in strange place in intialize Combination Lookup/update

  1. #1
    Join Date
    Jan 2011
    Posts
    7

    Question Null pointer exception in strange place in intialize Combination Lookup/update

    Hi all,

    I'm experiencing a strange behavior in Kettle which seems similar to (http://forums.pentaho.com/showthread...in-tableOutput)

    I'm using Build version : 4.2.0-stable (Build date: 2011-09-08 13.11.42) and my Kettle Jobs are running on a daily basis every night. Once every two or three weeks a random transformation fails with an Error while initializing. If I re-run the Jobs later everything works as intended and without any errors.

    The Log-Entries look similar to this one:

    INFO 04-06 08:56:35,864 - My Kettle Job - Starting entry [Init Variables]
    INFO 04-06 08:56:35,876 - My Kettle Job - Starting entry [Calculate Date String]
    INFO 04-06 08:56:35,892 - My Kettle Job - Starting entry [Write Log]
    INFO 04-06 08:56:35,893 - Processing My Kettle Job - Loading My Kettle Job for date 2012-06-03

    INFO 04-06 08:56:35,895 - My Kettle Job - Starting entry [Fill Daily Facts]
    INFO 04-06 08:56:35,896 - Fill Daily Facts - Loading transformation from XML file [file:///home/xxx/my_kettle_transformation.ktr]
    INFO 04-06 08:56:35,934 - My Kettle Job - Dispatching started for transformation [My Kettle Transformation]
    ERROR 04-06 08:56:36,409 - credit_typ dim - Error initializing step [credit_typ dim]
    ERROR 04-06 08:56:36,409 - time dim - Error initializing step [time dim]
    ERROR 04-06 08:56:36,410 - activity_typ dim - Error initializing step [activity_typ dim ]
    ERROR 04-06 08:56:36,441 - activity_typ dim - java.lang.NullPointerException
    at java.util.Date.getMillisOf(Date.java:939)
    at java.util.Date.compareTo(Date.java:959)
    at org.pentaho.di.core.logging.LoggingRegistry$1.compare(LoggingRegistry.java:108)
    at org.pentaho.di.core.logging.LoggingRegistry$1.compare(LoggingRegistry.java:102)
    at java.util.Arrays.mergeSort(Arrays.java:1270)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.sort(Arrays.java:1210)
    at java.util.Collections.sort(Collections.java:159)
    at org.pentaho.di.core.logging.LoggingRegistry.registerLoggingSource(LoggingRegistry.java:102)
    at org.pentaho.di.core.logging.LogChannel.<init>(LogChannel.java:42)
    at org.pentaho.di.core.database.Database.<init>(Database.java:198)
    at org.pentaho.di.trans.steps.combinationlookup.CombinationLookup.init(CombinationLookup.java:726)
    at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52)
    at java.lang.Thread.run(Thread.java:619)

    ERROR 04-06 08:56:36,441 - time dim - java.lang.NullPointerException
    at java.util.Date.getMillisOf(Date.java:939)
    at java.util.Date.compareTo(Date.java:959)
    at org.pentaho.di.core.logging.LoggingRegistry$1.compare(LoggingRegistry.java:108)
    at org.pentaho.di.core.logging.LoggingRegistry$1.compare(LoggingRegistry.java:102)
    at java.util.Arrays.mergeSort(Arrays.java:1270)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.sort(Arrays.java:1210)
    at java.util.Collections.sort(Collections.java:159)
    at org.pentaho.di.core.logging.LoggingRegistry.registerLoggingSource(LoggingRegistry.java:102)
    at org.pentaho.di.core.logging.LogChannel.<init>(LogChannel.java:42)
    at org.pentaho.di.core.database.Database.<init>(Database.java:198)
    at org.pentaho.di.trans.steps.combinationlookup.CombinationLookup.init(CombinationLookup.java:726)
    at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52)
    at java.lang.Thread.run(Thread.java:619)

    ERROR 04-06 08:56:36,441 - credit_typ dim - java.lang.NullPointerException
    at java.util.Date.getMillisOf(Date.java:939)
    at java.util.Date.compareTo(Date.java:959)
    at org.pentaho.di.core.logging.LoggingRegistry$1.compare(LoggingRegistry.java:108)
    at org.pentaho.di.core.logging.LoggingRegistry$1.compare(LoggingRegistry.java:102)
    at java.util.Arrays.mergeSort(Arrays.java:1270)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1282)
    at java.util.Arrays.mergeSort(Arrays.java:1281)
    at java.util.Arrays.sort(Arrays.java:1210)
    at java.util.Collections.sort(Collections.java:159)
    at org.pentaho.di.core.logging.LoggingRegistry.registerLoggingSource(LoggingRegistry.java:102)
    at org.pentaho.di.core.logging.LogChannel.<init>(LogChannel.java:42)
    at org.pentaho.di.core.database.Database.<init>(Database.java:198)
    at org.pentaho.di.trans.steps.combinationlookup.CombinationLookup.init(CombinationLookup.java:726)
    at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52)
    at java.lang.Thread.run(Thread.java:619)

    INFO 04-06 08:56:36,518 - Output facts - Connected to database [My DB] (commit=100000)
    ERROR 04-06 08:56:36,601 - My Kettle Transformation - Step [activity_typ dim .0] failed to initialize!
    ERROR 04-06 08:56:36,604 - My Kettle Transformation - Step [credit_typ dim.0] failed to initialize!
    ERROR 04-06 08:56:36,604 - My Kettle Transformation - Step [time dim.0] failed to initialize!
    INFO 04-06 08:56:36,604 - Get Data - Finished reading query, closing connection.
    ERROR 04-06 08:56:36,857 - Fill Daily Facts - Unable to prepare for execution of the transformation
    ERROR 04-06 08:56:36,871 - Fill Daily Facts - org.pentaho.di.core.exception.KettleException:
    We failed to initialize at least one step. Execution can not begin!


    at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:792)
    at org.pentaho.di.trans.Trans.execute(Trans.java:364)
    at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1024)
    at org.pentaho.di.job.Job.execute(Job.java:503)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:642)
    at org.pentaho.di.job.Job.execute(Job.java:420)
    at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:63)
    at java.lang.Thread.run(Thread.java:619)

    INFO 04-06 08:56:36,888 - My Kettle Job - Starting entry [Send Error E-Mail]
    INFO 04-06 08:56:37,208 - My Kettle Job - Starting entry [Failure]
    ERROR 04-06 08:56:37,208 - Failure - Job Failed
    INFO 04-06 08:56:37,211 - My Kettle Job - Finished job entry [Failure] (result=[false])
    INFO 04-06 08:56:37,211 - My Kettle Job - Finished job entry [Send Error E-Mail] (result=[false])
    INFO 04-06 08:56:37,211 - My Kettle Job - Finished job entry [Fill Daily Facts] (result=[false])
    INFO 04-06 08:56:37,211 - My Kettle Job - Finished job entry [Write Log] (result=[false])
    INFO 04-06 08:56:37,211 - My Kettle Job - Finished job entry [Calculate Date String] (result=[false])
    INFO 04-06 08:56:37,211 - My Kettle Job - Finished job entry [Init Variables] (result=[false])
    Any thoughts on this one?

    Thanks & Regards
    Nicow

  2. #2
    Join Date
    Nov 2011
    Posts
    11

    Default

    Hi

    I am getting same behaviour. Did anyone got this exception? Or any solution for this issue?

    I am using PDI 4.2.0 stable release on linux server.

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

    Default

    I haven't seen it myself but please don't make the same mistake as the parent poster: log a JIRA case with some sample job so we can test this out.

  4. #4
    Join Date
    Nov 1999
    Posts
    459

    Default

    FYI: This is the JIRA case: http://jira.pentaho.com/browse/PDI-8998

Tags for this Thread

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.