org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution

Pentaho BI Platform Tracking | Kurtis Cruzada | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    There were no changes made to these files in 5.3.0. I also tried running these same transformations that shipped in 5.2.0.1 and they fail in 5.3.0 as well. h3. ProAuditInstanceTransform.ktr - error in the PDI console: {code} 2015/01/19 20:32:56 - Java Script Preprocessing.0 - Optimization level set to 9. java.lang.NullPointerException org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) java.lang.Thread.run(Thread.java:695) at org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:695) 2015/01/19 20:32:56 - Session lookup.0 - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Unexpected error 2015/01/19 20:32:56 - Session lookup.0 - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : java.lang.NullPointerException 2015/01/19 20:32:56 - Session lookup.0 - at org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) 2015/01/19 20:32:56 - Session lookup.0 - at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) 2015/01/19 20:32:56 - Session lookup.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/01/19 20:32:56 - Session lookup.0 - at java.lang.Thread.run(Thread.java:695) child index = 9, logging object : org.pentaho.di.core.logging.LoggingObject@40fc8791 parent=960b5de7-cd0a-4f86-85f7-67df0a475b26 2015/01/19 20:32:56 - Session lookup.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2015/01/19 20:32:56 - ProAuditInstanceTransform - Transformation detected one or more steps with errors. 2015/01/19 20:32:56 - Instance lookup/update.0 - Finished processing (I=5, O=0, R=8, W=7, U=0, E=0) 2015/01/19 20:32:56 - ProAuditInstanceTransform - Transformation is killing the other steps! 2015/01/19 20:32:56 - Execution Lookup/Update.0 - Finished processing (I=2, O=0, R=3, W=3, U=0, E=0) 2015/01/19 20:32:56 - Java Script Preprocessing.0 - Finished processing (I=0, O=0, R=29, W=28, U=0, E=0) 2015/01/19 20:32:56 - ProAuditInstanceTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! 2015/01/19 20:32:56 - Spoon - The transformation has finished!! 2015/01/19 20:32:56 - ProAuditInstanceTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! 2015/01/19 20:32:56 - ProAuditInstanceTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! {code} h3. ProAuditComponentTransform.ktr - error in the PDI console: {code} 2015/01/19 20:35:50 - Combination lookup/update.0 - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0) java.lang.NullPointerException org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) java.lang.Thread.run(Thread.java:695) at org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:695) 2015/01/19 20:35:50 - Instance Lookup.0 - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Unexpected error 2015/01/19 20:35:50 - Instance Lookup.0 - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : java.lang.NullPointerException 2015/01/19 20:35:50 - Instance Lookup.0 - at org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) 2015/01/19 20:35:50 - Instance Lookup.0 - at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) 2015/01/19 20:35:50 - Instance Lookup.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/01/19 20:35:50 - Instance Lookup.0 - at java.lang.Thread.run(Thread.java:695) child index = 5, logging object : org.pentaho.di.core.logging.LoggingObject@277cd3d6 parent=71eb9ee7-a903-4b1c-83e3-79d13e9b901e 2015/01/19 20:35:50 - Execution Lookup/Update 3.0 - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0) 2015/01/19 20:35:50 - Instance Lookup.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2015/01/19 20:35:50 - ProAuditComponentTransform - Transformation detected one or more steps with errors. 2015/01/19 20:35:50 - ProAuditComponentTransform - Transformation is killing the other steps! 2015/01/19 20:35:50 - ProAuditComponentTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! 2015/01/19 20:35:50 - Spoon - The transformation has finished!! 2015/01/19 20:35:50 - ProAuditComponentTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! 2015/01/19 20:35:50 - ProAuditComponentTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! {code} When I run the kettle job that executes these transformation on the BA Server, the error in the log is this: {code} org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1027) at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeAction(KettleComponent.java:603) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:465) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1186) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1151) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1063) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1013) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:895) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:797) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:352) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:282) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:179) at org.pentaho.platform.plugin.action.builtin.ActionSequenceAction.execute(ActionSequenceAction.java:81) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:241) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:181) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:173) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:162) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:267) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:140) at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:39) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546) Caused by: org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1023) ... 21 more 2015-01-19 19:57:24,126 ERROR [org.pentaho.platform.plugin.action.kettle.KettleComponent] Error end: {code}

    Pentaho BI Platform Tracking | 2 years ago | Kurtis Cruzada
    org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution
  2. 0

    There were no changes made to these files in 5.3.0. I also tried running these same transformations that shipped in 5.2.0.1 and they fail in 5.3.0 as well. h3. ProAuditInstanceTransform.ktr - error in the PDI console: {code} 2015/01/19 20:32:56 - Java Script Preprocessing.0 - Optimization level set to 9. java.lang.NullPointerException org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) java.lang.Thread.run(Thread.java:695) at org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:695) 2015/01/19 20:32:56 - Session lookup.0 - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Unexpected error 2015/01/19 20:32:56 - Session lookup.0 - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : java.lang.NullPointerException 2015/01/19 20:32:56 - Session lookup.0 - at org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) 2015/01/19 20:32:56 - Session lookup.0 - at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) 2015/01/19 20:32:56 - Session lookup.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/01/19 20:32:56 - Session lookup.0 - at java.lang.Thread.run(Thread.java:695) child index = 9, logging object : org.pentaho.di.core.logging.LoggingObject@40fc8791 parent=960b5de7-cd0a-4f86-85f7-67df0a475b26 2015/01/19 20:32:56 - Session lookup.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2015/01/19 20:32:56 - ProAuditInstanceTransform - Transformation detected one or more steps with errors. 2015/01/19 20:32:56 - Instance lookup/update.0 - Finished processing (I=5, O=0, R=8, W=7, U=0, E=0) 2015/01/19 20:32:56 - ProAuditInstanceTransform - Transformation is killing the other steps! 2015/01/19 20:32:56 - Execution Lookup/Update.0 - Finished processing (I=2, O=0, R=3, W=3, U=0, E=0) 2015/01/19 20:32:56 - Java Script Preprocessing.0 - Finished processing (I=0, O=0, R=29, W=28, U=0, E=0) 2015/01/19 20:32:56 - ProAuditInstanceTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! 2015/01/19 20:32:56 - Spoon - The transformation has finished!! 2015/01/19 20:32:56 - ProAuditInstanceTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! 2015/01/19 20:32:56 - ProAuditInstanceTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! {code} h3. ProAuditComponentTransform.ktr - error in the PDI console: {code} 2015/01/19 20:35:50 - Combination lookup/update.0 - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0) java.lang.NullPointerException org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) java.lang.Thread.run(Thread.java:695) at org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:695) 2015/01/19 20:35:50 - Instance Lookup.0 - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Unexpected error 2015/01/19 20:35:50 - Instance Lookup.0 - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : java.lang.NullPointerException 2015/01/19 20:35:50 - Instance Lookup.0 - at org.pentaho.di.core.row.RowMeta.indexOfValue(RowMeta.java:472) 2015/01/19 20:35:50 - Instance Lookup.0 - at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.processRow(DatabaseLookup.java:399) 2015/01/19 20:35:50 - Instance Lookup.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/01/19 20:35:50 - Instance Lookup.0 - at java.lang.Thread.run(Thread.java:695) child index = 5, logging object : org.pentaho.di.core.logging.LoggingObject@277cd3d6 parent=71eb9ee7-a903-4b1c-83e3-79d13e9b901e 2015/01/19 20:35:50 - Execution Lookup/Update 3.0 - Finished processing (I=1, O=0, R=1, W=1, U=0, E=0) 2015/01/19 20:35:50 - Instance Lookup.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2015/01/19 20:35:50 - ProAuditComponentTransform - Transformation detected one or more steps with errors. 2015/01/19 20:35:50 - ProAuditComponentTransform - Transformation is killing the other steps! 2015/01/19 20:35:50 - ProAuditComponentTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! 2015/01/19 20:35:50 - Spoon - The transformation has finished!! 2015/01/19 20:35:50 - ProAuditComponentTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! 2015/01/19 20:35:50 - ProAuditComponentTransform - ERROR (version 5.3.0.0-198, build 1 from 2015-01-19_07-59-21 by buildguy) : Errors detected! {code} When I run the kettle job that executes these transformation on the BA Server, the error in the log is this: {code} org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1027) at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeAction(KettleComponent.java:603) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:465) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1186) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1151) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1063) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1013) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:895) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:797) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:352) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:282) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:179) at org.pentaho.platform.plugin.action.builtin.ActionSequenceAction.execute(ActionSequenceAction.java:81) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:241) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:181) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:173) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:162) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:267) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:140) at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:39) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546) Caused by: org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1023) ... 21 more 2015-01-19 19:57:24,126 ERROR [org.pentaho.platform.plugin.action.kettle.KettleComponent] Error end: {code}

    Pentaho BI Platform Tracking | 2 years ago | Kurtis Cruzada
    org.pentaho.platform.plugin.action.kettle.KettleComponentException: Kettle.ERROR_0014 - Error occurred during transformation execution

    Root Cause Analysis

    1. org.pentaho.platform.plugin.action.kettle.KettleComponentException

      Kettle.ERROR_0014 - Error occurred during transformation execution

      at org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob()
    2. org.pentaho.platform
      BlockingQuartzJob.execute
      1. org.pentaho.platform.plugin.action.kettle.KettleComponent.executeJob(KettleComponent.java:1023)
      2. org.pentaho.platform.plugin.action.kettle.KettleComponent.executeAction(KettleComponent.java:603)
      3. org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:465)
      4. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1186)
      5. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1151)
      6. org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1063)
      7. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1013)
      8. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:895)
      9. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:797)
      10. org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:352)
      11. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:282)
      12. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:179)
      13. org.pentaho.platform.plugin.action.builtin.ActionSequenceAction.execute(ActionSequenceAction.java:81)
      14. org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:241)
      15. org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:181)
      16. org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:173)
      17. org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:162)
      18. org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:267)
      19. org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:140)
      20. org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:39)
      20 frames
    3. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:199)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
      2 frames