FASTLOAD ERROR

Tools
Teradata Employee

FASTLOAD ERROR

Dear All,

I am trying to fload a flat file, the file contains 44 columns (44 'Û' delimiters). 

Following is the sample header and data rows (header is removed from the actual file being loaded):

HEADER:

IDÛIC.STMCR.PERIOD.FIRST.DATEÛIC.STMCR.PERIOD.LAST.DATEÛIC.STMCR.CR.INT.DATEÛIC.STMCR.CR.NO.OF.DAYSÛIC.STMCR.CR.VAL.BALANCEÛIC.STMCR.CR.INT.RATEÛIC.STMCR.CR.INT.AMTÛIC.STMCR.CR.INT.CATEGÛIC.STMCR.CR.INT.TR.ACÛIC.STMCR.CR.INT.TR.PLÛIC.STMCR.CR.INT.TAX.CODEÛIC.STMCR.CR.INT.TAX.RATEÛIC.STMCR.CR.INT.TAX.AMTÛIC.STMCR.CR.INT.TAXCATEGÛIC.STMCR.CR.INT.TAXTRSDRÛIC.STMCR.CR.INT.TAXTRSCRÛIC.STMCR.LIQUIDITY.ACCOUNTÛIC.STMCR.COMPENS.ACCOUNTÛIC.STMCR.INT.NO.BOOKINGÛIC.STMCR.TOTAL.INTERESTÛIC.STMCR.TAX.FOR.CUSTOMERÛIC.STMCR.TAX.FOR.BANKÛIC.STMCR.GRAND.TOTALÛIC.STMCR.CORRECTION.NUMBERÛIC.STMCR.LIQUIDITY.CCYÛIC.STMCR.ICA.POST.INTERESTÛIC.STMCR.ICA.MAIN.ACCTÛIC.STMCR.ICA.DIST.TYPEÛIC.STMCR.ICA.DIST.RATIOÛIC.STMCR.ICA.INT.CATEGÛIC.STMCR.ICA.TR.ACÛIC.STMCR.ICA.TR.PLÛIC.STMCR.ICA.MAIN.INTÛIC.STMCR.ICA.SUB.INTÛIC.STMCR.GR.INT.TAX.LCYÛIC.STMCR.NET.INT.TAX.LCYÛIC.STMCR.GR.INT.TAX.FCYÛIC.STMCR.NET.INT.TAX.FCYÛIC.STMCR.CR.MIN.VALUEÛIC.STMCR.CR.MIN.WAIVEÛIC.STMCR.UNADJ.TOTAL.INTÛIC.STMCR.INT.POST.DATEÛIC.STMCR.TAX.EXCH.RATEÛ

DATA ROW:

0002894473-20131231Û20130701Û20131231Û20130701ý20131001ý20131201Û92ý61ý31Û616.94ý13.94ý13.94Û6.00ý6.50ý7.00Û9.33ý0.15ý0.08Û50000Û381Û380Û3Û10.00Û0.96Û17215Û875Û876ÛÛÛÛ9.56Û0.96ÛÛ8.6ÛÛPKRÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ20140101ÛÛ

I am getting the following error:

Error on piom GET ROW: 61, Text: Warning, too few columns !ERROR! Delimited Data Parsing error: Too few columns in row 1

kindly help.

-Zeeshan

Tags (1)
5 REPLIES
Junior Contributor

Re: FASTLOAD ERROR

Hi Zeeshan,

it's hard to tell without more info.

Did you use VARTEXT and the correct DELIMITER?

Did you DEFINE all fields as VARCHAR?

Teradata Employee

Re: FASTLOAD ERROR

hi Dieter,

yes I used VARTEXT and the correct DELIMITER, also, I defined each field as VARCHAR.

Ive been stuck with this problem for 2 hrs, and I cant find any documentation of the error anywhere. Any help will be highly appreciated. 

Junior Contributor

Re: FASTLOAD ERROR

Hi Zeeshan,

this error indicates there are less fields in your input record than DEFINEd.

Btw, 44 delimiters define 45 columns, but this should not the source of your problem.

Enthusiast

Re: FASTLOAD ERROR

20131201Û 92ý61ý31Û6

from the value after the 4th delimiter is it entered as a new row in the data?

Teradata Employee

Re: FASTLOAD ERROR

@dieter,

Yes there are actually 45 columns, not 44, so I added one more column to the fastload script, but still the same error. I even removed an extra column to make the total number of columns to be 43, still the same error...

@krishaneesh

No it is not a new row, the row is actually wrapped in this forum's post.