Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: problem with file input step

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

    Default problem with file input step

    Attachment: transform.JPG (posted by amine, http://www.javaforge.com/userdata.do?user_id=3106, set the "PLAIN" message type)

    hello, I m a biginner in kettle, I m using 2 steps in my transformation: file input and table output, when I preview transforamtion it works correctly and kettle can write in the database, but when I want to run the transformation the exception "java.lang.NullPointerException" is thrown, this is the log :

    2006/04/14 13:26:39 - Spoon - Transformation opened.
    2006/04/14 13:26:39 - Spoon - Excecuting transformation [null]...
    2006/04/14 13:26:39 - be.ibridge.kettle.trans.Trans - Dispatching started for filename [C:\Documents and Settings\Administrateur\Bureau\kettle transform\alarms1.ktr]
    2006/04/14 13:26:39 - be.ibridge.kettle.trans.Trans - Nr of arguments detected: 10
    2006/04/14 13:26:39 - toStagingArea.0 - Connected to database [staging] (commit=100)
    2006/04/14 13:26:39 - Spoon - Started.
    2006/04/14 13:26:39 - alarms.0 - Starting to run...
    2006/04/14 13:26:39 - alarms.0 - Opening file: D:\1002_all_0060304.txt
    2006/04/14 13:26:39 - alarms.0 - ERROR : Couldn't open file #0 : D:\1002_all_0060304.txt (openNextFile : open file) --> java.lang.NullPointerException
    2006/04/14 13:26:39 - alarms.0 - ERROR : Couldn't close file : D:\1002_all_0060304.txt --> java.lang.NullPointerException
    2006/04/14 13:26:39 - alarms.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1
    2006/04/14 13:26:39 - toStagingArea.0 - Starting to run...
    2006/04/14 13:26:39 - toStagingArea.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0
    2006/04/14 13:26:39 - Spoon - The transformation has finished!!

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

    Default RE: problem with file input step

    Bonjour Amine,


    Please file a bug report for this.
    If you would be so kind, could you also tell us something about the environment you're running (OS, JRE, Kettle version) and the XML of the Text File Input step.



    While you're at it, try the dev version by downloading kettle.jar here: kettje.jar (follow instructions)

    Chances are very good that your problem has already been fixed.



    Thank you in advance for the feedback.



    Kind regards,

    Matt

  3. #3

    Default RE: problem with file input step

    Thank you for your answer, I m so pleased to use an open source ETL.


    These are informations about my environnment :
    Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
    Microsoft Windows XP version 5.1.2600[img]/wiki/images/newpage.gif[/url]
    Kettle-2.2.2



    I must find solutions to all problems that I have with kettle, be cause I must fill my database before the end of the next week (I have presentation). or else I gonna use some java programs jsut to do so, and after that I can take my time (tow months) to solve problems.anyway, I appreciate all features that kettle offers.



    BR

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

    Default RE: problem with file input step

    I'm sure you'll do fine with the latest dev snapshot. I'm very pleased about it as it's pretty stable.


    Text File Input is probably the most used and altered step in Kettle.





    TextFileInput.java



    The problem you encountered was solved by audinchan, one of the Chinese developers.



    Cheers,

    Matt

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.