FAST LOAD ERROR

Tools & Utilities
Enthusiast

FAST LOAD ERROR


Hi all,

I have a fload job which runs fine in PROD ,but fails in DEV.i m using OLEDB for this fload activity.pls comment how to rectify this error.if not pls tell me an alternate way to do this.pls make a note that my target tbl has USI defined

**** 14:27:29 Number of recs/msg: 22
**** 14:27:29 Starting to send to RDBMS with record 1
**** 14:27:29 Bad file or data definition.
**** 14:27:29 The length of: ACCOUNTNUMBERNEW in row: 1 was greater
than defined.
Defined: 15, Received: 1280 ===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

**** 14:27:29 Logging off all sessions
**** 14:27:33 Total processor time used = '1.15625 Seconds'
. Start : Wed Sep 24 14:00:04 2008
. End : Wed Sep 24 14:27:33 2008
. Highest return code encountered = '12'.
**** 14:27:33 FastLoad Paused

cheers,
Young chap
5 REPLIES
Teradata Employee

Re: FAST LOAD ERROR

Hello,

First try loading after dropping USI. If it still does not work, you need to check following points:

- Is the table DDL exactly same in both systems/environments
- Is the data file being used same for both systems/environments

HTH.

Regards,

Adeel
Enthusiast

Re: FAST LOAD ERROR

Hi Adeel,
Thanx for ur reply.ofcourse before loading i had dropping the USI also the DEV and PROD Environment has same table structure.FYI accountnumbernew is defined as an Varchar(15).......can u suggest me another solution like any transformation i should make in the columns before loading ...stuff like that etc...
Teradata Employee

Re: FAST LOAD ERROR

Well, if the data file is also same, then ideally there shouldn't be any problem.

Can you please check if you are using same FastLoad script as well (with different LOGON string ... offcourse)?

Lastly, can you provide the table DDL in Database, FastLoad script and sample data row causing problem?

Regards,

Adeel
Enthusiast

Re: FAST LOAD ERROR

The error message indicates that the first data row has data in a column which exceeds the defined length.
You are probably using a delimeter character between the data rows, if so, make sure that for a char(10) field, you define the column as a varchar(11) in order to allow an extra byte for teh chosen delimeter byte.

Good luck.
Enthusiast

Re: FAST LOAD ERROR

hi guys ,

following is the target table ddl in dev and prod.it has same structure.
also i m using OLEload DB as it will load like table to table load and no concept of flatfile here.as the source file is same for prod and dev and target table ddl is same for prod and dev m not able to rectify the error.....is there any other way to rectify............

CREATE SET TABLE databasename.tablename ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
LoadDate TIMESTAMP(0) NOT NULL,
ExtractDate TIMESTAMP(0) NOT NULL,
SnapDate DATE FORMAT 'YYYY-MM-DD' NOT NULL,
BillingCode BYTEINT NOT NULL,
AccountNumber VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC,
AccountID DECIMAL(18,0) NOT NULL,
StatusCode VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
Quantity BYTEINT NOT NULL COMPRESS 1 ,
ActivationReasonCode INTEGER COMPRESS ,
ActivatingReasonTypeId BYTEINT NOT NULL COMPRESS 1 ,
DeactivatingReasonCode INTEGER COMPRESS 17 ,
DeactivatingReasonTypeId BYTEINT NOT NULL COMPRESS 1 ,
IsRevenueFlag BYTEINT NOT NULL COMPRESS 1 ,
ActivationDate DATE FORMAT 'YYYY-MM-DD' NOT NULL,
DeactivationDate DATE FORMAT 'YYYY-MM-DD' COMPRESS ,
SuspendDate DATE FORMAT 'YYYY-MM-DD' COMPRESS ,
ChannelCode DECIMAL(18,0) COMPRESS ,
CsrCode DECIMAL(18,0) COMPRESS ,
RegionCode INTEGER COMPRESS ,
CampaignCode VARCHAR(512) CHARACTER SET LATIN NOT CASESPECIFIC,
SegmentCode DECIMAL(1,0) COMPRESS 1. ,
CreditClass VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
SSN INTEGER COMPRESS ,
ContactNumber VARCHAR(75) CHARACTER SET LATIN NOT CASESPECIFIC,
BillCycleCode DECIMAL(2,0) COMPRESS (1. ,2. ,3. ,4. ,5. ,6. ,7. ,8. ,9. ,10. ,11. ,12. ,13. ,14. ,15. ,16. ,17. ,18. ,19. ,20. ,21. ,22. ,23. ,24. ,25. ,26. ,27. ,28. ),
AccountNumberNew VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC,
AccountNumberOld VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC,
FirstName VARCHAR(90) CHARACTER SET LATIN NOT CASESPECIFIC,
MiddleInitial VARCHAR(90) CHARACTER SET LATIN NOT CASESPECIFIC,
LastName VARCHAR(90) CHARACTER SET LATIN NOT CASESPECIFIC,
Address VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,
City VARCHAR(90) CHARACTER SET LATIN NOT CASESPECIFIC,
State VARCHAR(90) CHARACTER SET LATIN NOT CASESPECIFIC,
ZipCode VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
ZipCode4 VARCHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC,
Dob INTEGER COMPRESS ,
Dln INTEGER COMPRESS ,
ContractStartDate DATE FORMAT 'YYYY-MM-DD' COMPRESS ,
ContractTerm INTEGER COMPRESS ,
ContractEndDate DATE FORMAT 'YYYY-MM-DD' COMPRESS ,
ContactNumberAlt INTEGER COMPRESS ,
WholesaleRetailFlag INTEGER COMPRESS ,
CableHomeType INTEGER COMPRESS ,
VipCode VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
MDUCode INTEGER COMPRESS ,
User01 DECIMAL(5,0) COMPRESS (10001. ,10003. ,10021. ),
User02 VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC,
User03 DECIMAL(12,2) COMPRESS 0.00 ,
User04 VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
User05 DECIMAL(18,0) COMPRESS ,
User06 CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS 'N',
User07 INTEGER COMPRESS ,
User08 INTEGER COMPRESS ,
User09 INTEGER COMPRESS ,
User10 INTEGER COMPRESS ,
User11 INTEGER COMPRESS ,
User12 INTEGER COMPRESS ,
User13 INTEGER COMPRESS ,
User14 DATE FORMAT 'YYYY-MM-DD' NOT NULL,
User15 DECIMAL(18,0) COMPRESS ,
User16 DECIMAL(18,0) COMPRESS ,
User17 VARCHAR(1023) CHARACTER SET LATIN NOT CASESPECIFIC,
User18 INTEGER COMPRESS ,
User19 DATE FORMAT 'YYYY-MM-DD' COMPRESS ,
User20 DECIMAL(18,0) COMPRESS )
PRIMARY INDEX ( Billingcode ,AccountNumber )
PARTITION BY RANGE_N(Snapdate BETWEEN DATE '2007-01-01' AND DATE '2008-12-31' EACH INTERVAL '1' DAY ,
NO RANGE);

regards,
Youngchap