Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Please help! Javascript step: Unexpected error & java.lang.NullPointerException

  1. #1

    Default Please help! Javascript step: Unexpected error & java.lang.NullPointerException

    Hello,

    I have created a transformation that parses MS Excel 2003 files and loads them into our staging database. This morning, our production load failed with this error in a Javascript step:
    Code:
    2012/08/02 20:47:34 - Js 1.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error : 
    2012/08/02 20:47:34 - Js 1.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.NullPointerException
    2012/08/02 20:47:34 - Js 1.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMetaMod.getFields(ScriptValuesMetaMod.java:332)
    2012/08/02 20:47:34 - Js 1.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:145)
    2012/08/02 20:47:34 - Js 1.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:667)
    2012/08/02 20:47:34 - Js 1.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
    2012/08/02 20:47:34 - Js 1.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :     at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:730)
    The Javascript step simply assigns `short_filename` to a field to be loaded into our db. Another field concatenates the filename to another variable for email generation. Very simple stuff. I did a google search and found nothing relevant to this problem. The layout of the MS Excel files has not changed and the data types are unchanged as well.

    What causes this error? Is there a way to workaround it?

    Our production environment runs 3.2.0-GA (upgrade to newer version is not possible) and the database on the back end is IBM DB2 v9.7. OS is Linux Red Hat. I have attached to this post the transformation as well as a sample MS Excel 2003 file.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by acbonnemaison; 08-02-2012 at 05:10 PM.
    Pentaho Data Integration CE 5.3.0.x
    JDK 1.7
    OS X Yosemite version 10.10.x
    MySQL 5.5.37
    Amazon Redshift
    Pacific Standard Time

  2. #2
    Join Date
    Nov 2008
    Posts
    271

    Default

    Check the excel input step (All Rows), and fill in the sheet tab.
    HTH
    Andrea Torre
    twitter: @andtorg

    join the community on ##pentaho - a freenode irc channel

  3. #3

    Default

    Quote Originally Posted by Ato View Post
    Check the excel input step (All Rows), and fill in the sheet tab.
    HTH
    I cannot fill in the sheet tab for the name since it is tied to a container number, which changes every time.
    Pentaho Data Integration CE 5.3.0.x
    JDK 1.7
    OS X Yosemite version 10.10.x
    MySQL 5.5.37
    Amazon Redshift
    Pacific Standard Time

  4. #4

    Default

    On a whim, I restored this transformation from a week old backup. It worked without error.

    Go figure.
    Pentaho Data Integration CE 5.3.0.x
    JDK 1.7
    OS X Yosemite version 10.10.x
    MySQL 5.5.37
    Amazon Redshift
    Pacific Standard Time

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.