TPT: error 2972: No table header exists for table.

Tools & Utilities
Enthusiast

TPT: error 2972: No table header exists for table.

Hi,

My TPT script gets data from some pipes and load using the UPDATE operator, and for a few weeks everything worked well.

But, at 3 days I'm have getting this error in the middle of load process:
**** 19:29:54 Starting to send data to the RDBMS
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 833669, Total Rows Received = 104917279, Total Rows Sent = 0

DATA_LOAD: TPT10508: RDBMS error 2972: No table header exists for table.
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 210777, Total Rows Received = 0, Total Rows Sent = 26540869
**** 06:58:55 TPT10508: RDBMS error 2972: No table header exists for table.
The "pipe loader"  had not finished loading yet.

I already deleted the files from checkpoint, dropped wt,lg,uv,et tables, did release mload and restart the load, but this error happens again.

Target table:


CREATE SET TABLE MY_DB.MY_TABLE ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

// fields with many compress values

)

UNIQUE PRIMARY INDEX UPI_T811_R2_EXCL_DETRAF ( TELEFONE_ORIGEM ,

TELEFONE_DESTINO ,HORA_INICIO ,DURACAO ,DIA_MES_INICIO ,ROTA_ENTRANTE ,

ROTA_SAINTE ,BILHETADOR ,DATA_HORA_COBRANCA ,DATA_CARGA )

PARTITION BY RANGE_N(DATA_CARGA  BETWEEN DATE '2006-01-01' AND DATE '2015-12-31' EACH INTERVAL '1' DAY );

(My partition range is a little big, but until now performed it well)

Thanks in advice.

Tags (3)
2 REPLIES
Teradata Employee

Re: TPT: error 2972: No table header exists for table.

I spoke with the database engineers and they told me that you will need to open an incident with the GSC.

Database engineers will only be able to analyze the cause of this internal error by either looking at a crashdump (if there was one), or look at your live system when the error is detected.

-- SteveF
Enthusiast

Re: TPT: error 2972: No table header exists for table.

I had to rename, re-create (and decrease the partition range), and transfer almost 1 bi of rows to the new table, then (after some "No more spool space") re-run my loader.

The cursed load all my files as if nothing had happened...

Ok, but the strange thing is that the other similar pipe loader had the same problem...

I had to recreate the other table too...

I'm waiting for this problem to happen again, if it happens I'll request help.

Thanks again feinholz.