Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Regression with Text file input

  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Default Regression with Text file input

    Hi!
    I'm using a text file input with enabled 'Ignore errors' and 'Skip error lines'. With PDI2.5 it works as expected, error lines are thrown away.
    With PDI3.0 the transformations crashes with a NullPointerException. Seams to be a severe bug.
    Im using a fild marked as Integer which contains String data in some rows.

    Bye
    -stephan

    Log for PDI2.5
    14:15:35,851 INFO [txt] /EPOQ/dynomo-2.0/xfer/Daten/Inbound_Tesdaten_50000.txt - WARNING: Couldn't parse field [KDNR] with value [530292912A], format [null] ldaf=[yyy/MM/dd HH:mm:ss.SSS] : For input string: "530292912A"
    14:15:35,852 INFO [txt] /EPOQ/dynomo-2.0/xfer/Daten/Inbound_Tesdaten_50000.txt - WARNING: Couldn't parse field [QAALUMZS] with value [AAAAAAAAAAAAA], format [null] ldaf=[yyy/MM/dd HH:mm:ss.SSS] : For input string: "AAAAAAAAAAAAA"


    Log for PDI3.0.1
    INFO 04-01 14:17:13,838 (LogWriter.java:println:403) -/EPOQ/dynomo-2.0/xfer/Daten/Inbound_Tesdaten_50000.txt - WARNING: Couldn't parse field [Integer(2)] with value [AAAAAAAAAAAAA], format [null] :
    Unexpected conversion error while converting value [QAALUMZS String(2)] to an Integer

    QAALUMZS String(2) : couldn't convert String to Integer
    Unparseable number: "AAAAAAAAAAAAA"


    ERROR 04-01 14:17:13,839 (LogWriter.java:println:400) -Text file input.0 - Unexpected error :
    ERROR 04-01 14:17:13,839 (LogWriter.java:println:400) -Text file input.0 - org.pentaho.di.core.exception.KettleException:
    Error converting line
    at org.pentaho.di.trans.steps.textfileinput.TextFileInput.run (TextFileInput.java:1412)
    at org.pentaho.di.trans.steps.textfileinput.TextFileInput.processRow (TextFileInput.java:1006)
    at org.pentaho.di.trans.steps.textfileinput.TextFileInput.convertLineToRow (TextFileInput.java:702)

    at org.pentaho.di.trans.steps.textfileinput.TextFileInput.convertLineToRow(TextFileInput.java:749)
    at org.pentaho.di.trans.steps.textfileinput.TextFileInput.processRow(TextFileInput.java:1006)
    at org.pentaho.di.trans.steps.textfileinput.TextFileInput.run(TextFileInput.java:1412)
    Caused by: java.lang.NullPointerException
    at org.pentaho.di.trans.steps.textfileinput.TextFileInput.convertLineToRow(TextFileInput.java:702)
    ... 2 more

    INFO 04-01 14:17:13,898 (LogWriter.java:println:403) -Text file input.0 - Finished processing (I=2, O=0, R=0, W=0, U=0, E=1)
    ERROR 04-01 14:17:13,902 (LogWriter.java:println:400) -speedtestload - Errors detected!

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Make a JIRA and attach sample transformation and small input file.

    Regards,
    Sven

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.