Tpump failed with UTY8001 RDBMS failure in Macro Build: 2673

Tools & Utilities
Teradata Employee

Tpump failed with UTY8001 RDBMS failure in Macro Build: 2673

The complete error message from Tpump log was:-

 UTY8001 RDBMS failure in Macro Build: 2673, The source parcel length does not match data that was defined.

My data source is (first several records)

731727336!1!2100034078!1!2.4!1.3!1!2005-07-01 09:12:13.000000!1!2005-07-01 09:12:24.000000!2005-07-01!20!11:46:54.170000

731727336!2!4125543078!1!4.75!4.42!1!2005-07-01 09:12:24.000000!1!2005-07-01 09:12:26.000000!2005-07-01!20!11:46:54.170000

731727336!3!3320018053!1!3.62!3.12!1!2005-07-01 09:12:26.000000!1!2005-07-01 09:12:33.000000!2005-07-01!20!11:46:54.170000

The tpump script:

.logtable adw.stl_log;

.begin load SESSIONS 1 PACK 600 ARRAYSUPPORT ON CHECKPOINT 60 ERRLIMIT 1000

   ERRORTABLE adw.sales_transaction_line_ERR NOMONITOR;

.layout sales_transaction_line_layout;

.field Sales_Tran_Id * varchar(17);

.field Sales_Tran_Line_Num * varchar(10);

.field Item_Id * varchar(16);

.field Item_Qty * varchar(15);

.field Unit_Selling_Price_Amt * varchar(15);

.field Unit_Cost_Amt * varchar(15);

.field Tran_Line_Status_Cd * varchar(10);

.field Sales_Tran_Line_Start_Dttm * varchar(31);

.field Tran_Line_Sales_Type_Cd * varchar(9);

.field Sales_Tran_Line_End_Dttm * varchar(31);

.field Tran_Line_Date * varchar(15);

.field location * varchar(15);

.field TX_TIME * varchar(20);

.DML LABEL ins_01 IGNORE MISSING ROWS IGNORE EXTRA ROWS;

INSERT INTO adw.sales_transaction_line(

Sales_Tran_Id,

Sales_Tran_Line_Num,

Item_Id,

Item_Qty,

Unit_Selling_Price_Amt,

Unit_Cost_Amt,

Tran_Line_Status_Cd,

Sales_Tran_Line_Start_Dttm,

Tran_Line_Sales_Type_Cd,

Sales_Tran_Line_End_Dttm,

Tran_Line_Date,

location,

TX_TIME) VALUES (

:Sales_Tran_Id,

:Sales_Tran_Line_Num,

:Item_Id,

:Item_Qty,

:Unit_Selling_Price_Amt,

:Unit_Cost_Amt,

:Tran_Line_Status_Cd,

:Sales_Tran_Line_Start_Dttm,

:Tran_Line_Sales_Type_Cd,

:Sales_Tran_Line_End_Dttm,

:Tran_Line_Date,

:location,

:TX_TIME);

.IMPORT INFILE onerow FORMAT vartext '!'

   LAYOUT sales_transaction_line_layout APPLY ins_01;

.END LOAD;

.LOGOFF;

The table DDL:

show table adw.sales_transaction_line;

 *** Text of DDL statement returned.

 *** Total elapsed time was 1 second.

---------------------------------------------------------------------------

CREATE SET TABLE adw.sales_transaction_line ,FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      Sales_Tran_Id INTEGER TITLE 'Sales Tran Id' NOT NULL,

      Sales_Tran_Line_Num SMALLINT TITLE 'Sales Tran Line Num' NOT NULL,

      Item_Id CHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Item Id

' COMPRESS ('1020006307  ','1280046421  ','1401418257  ','1600041420  ','90102030105 ','90102030106','90102030110 ','90102030111 ','90102030112 ','90102030113 ','90102030114

','90102030115 ','90102030116 ','90102030117 ','90102030118 ','90102030119

 ','90102030120 ','90102030121 ','90102030122 ','90102030123 '),

      Item_Qty DECIMAL(5,0) TITLE 'Item Qty' NOT NULL,

      Unit_Selling_Price_Amt DECIMAL(8,4) TITLE 'Unit Selling Price Amt' N

OT NULL,

      Unit_Cost_Amt DECIMAL(8,4) TITLE 'Unit Cost Amt',

      Tran_Line_Status_Cd CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC TIT

LE 'Tran Line Status Cd' COMPRESS ('0','1'),

      Sales_Tran_Line_Start_Dttm TIMESTAMP(6) TITLE 'Sales Tran Line Start

 Dttm',

      Tran_Line_Sales_Type_Cd CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC

 TITLE 'Tran Line Sales Type Cd' COMPRESS ('0 ','1 '),

      Sales_Tran_Line_End_Dttm TIMESTAMP(6) TITLE 'Sales Tran Line End Dtt

m',

      Tran_Line_Date DATE FORMAT 'yyyy-mm-dd',

      location INTEGER 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 ,29 ,30 ,31 ,

179 ,180 ,181 ,182 ,183 ,184 ,185 ,186 ,187 ,188 ,189 ,190 ,191 ,192 ,193

 ,194 ,195 ,196 ,197 ,198 ,199 ,200 ,201 ,202 ,203 ,204 ,205 ,206 ),

      TX_TIME TIME(6) NOT NULL DEFAULT CURRENT_TIME(0))

PRIMARY INDEX ( Sales_Tran_Id )

PARTITION BY RANGE_N(Tran_Line_Date  BETWEEN DATE '2004-01-01' AND '2005-0

7-02' EACH INTERVAL '1' DAY )

INDEX ( Sales_Tran_Id )

INDEX ( Item_Id )

INDEX ( Tran_Line_Date )

INDEX ( location );


					
				
			
			
				
			
			
				
Tags (2)
2 REPLIES
Teradata Employee

Re: Tpump failed with UTY8001 RDBMS failure in Macro Build: 2673

DBS running version is 14.10.00.03.

Teradata Employee

Re: Tpump failed with UTY8001 RDBMS failure in Macro Build: 2673

This issue had been resolved.

From: Gerritson, Peter

Sent: Wednesday, September 18, 2013 7:59 AM

To: Yuan, Ivy

Subject: RE: RDBMS failure in Macro Build: 2673

Ivy:

He switched versions and was able to run OK.  There must have been some incompatibility between the tpump version he was running and the dbs version.

So we are done with this issue. Thanks a lot for helping with ths.

Peter