Help get this topic noticed by sharing it on Twitter Twitter, Facebook Facebook, or email.
Al Olson
Al Olson November 04, 2011 19:12

How to Correct runtime warnings?

I have been trying to profile a large flat file and for the most part it seems to work however when creating the profile a large number of my records get a runtime warning for "short record" I can not seem to figure out how to correct this issue. ([EHS:SHORT_LINE][step:finalinputfile])
1 person has
this question +1
Reply

  • Marek Ovčáček
    Marek Ovčáček November 07, 2011 08:07
    Hi

    [EHS:SHORT_LINE] warning indicate that there are some inconsistencies in the input file. Namely, there are some lines, that are not containing all data columns program expected to find. Colums are defined in text file metadata. You can access metadata editor by right clicking on your flat file and selecting "edit metadata" option.

    This is an example of some shortline file with ";" as field separator:

    line;field1;field2
    1;sometext;someothertext
    2;sometext

    line 2 is missing one column at the end and will generate SHORT_LINE warning

    You can chceck short lines in Your data, if you set "rejected file name" in "error handling strategies" in Your text file reader (default is "rejected.txt"). The file "rejected.txt" will contain all your lines with missing data.

    By default, text file reader is configured to read all possible data from the input. That means, if reading encounter short line, it will read all possible data and substitue missing values with null.

    The way to fix these warnings is to correct the input file.
    Comment
    good answer! good answer! (undo)
  • (some HTML allowed)
    How does this make you feel?     Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited

    Cancel