Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Univariate Statistics from a Database Repository

  1. #1
    Join Date
    Mar 2014
    Posts
    1

    Default Univariate Statistics from a Database Repository

    Hi there

    I was wonder if someone could provide some help with an issue I have with Univariate Statistics.

    When the attached transformation is run as a stand alone transformation or from with a File Repository it runs as expected.

    When I import this transformation into a Database Repository and run, I get an error:

    Code:
    2014/03/27 14:45:18 - Univariate Statistics.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error
    2014/03/27 14:45:18 - Univariate Statistics.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : java.lang.NullPointerException
    2014/03/27 14:45:18 - Univariate Statistics.0 -     at org.pentaho.di.trans.steps.univariatestats.UnivariateStatsMeta.getFields(UnivariateStatsMeta.java:244)
    2014/03/27 14:45:18 - Univariate Statistics.0 -     at org.pentaho.di.trans.steps.univariatestats.UnivariateStats.processRow(UnivariateStats.java:122)
    2014/03/27 14:45:18 - Univariate Statistics.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2014/03/27 14:45:18 - Univariate Statistics.0 -     at java.lang.Thread.run(Unknown Source)
    If I save the transformation after this failure, the Input Fields are blank when I reopen the transformation, so not sure if that is a clue.

    This is run from PDI Spoon 5.0.1.A Stable on a Windows XP PC. The Database used for the Repository is MySQL.

    Included in the zip is a transformation and a simple CSV with test data. Output is an Excel spreadsheet. The Parameter {processDir} will need to be set for the environment this is run is (processDir is used instead of a built-in variable for the use within a Database Repository)

    I'm not sure what I am missing in order to get this to run correctly, so appreciate any help/comments.
    Attached Files Attached Files

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.