Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 08 Nov 2001 @ 21:14:29 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Identifying row failed in CHECKTABLE
From:   Geoffrey Rommel

  Is there a way to select the row from the table that is failing in CHECKTABLE?  

  "CORPDBP2"."PROVGACT4T" starting at 14:27:06 01/11/05.
Table id 0007H EE70H, Fallback.
2764: Data row not indexed by USI.
Data AMP 00010, Primary Data subtable
USI id 4
Data row id 96C4H 793BH 0000H 0001H

Well, I've never actually had to do this, but the following should get you pretty close.

select d.databasenamei, t.tvmnamei, t.tvmid
from dbc.dbase d,
dbc.tvm t
where d.databaseid = t.databaseid
and tvmid = '0007ee700000'xb ;

This will give you the name of the table. You can then find all rows that match your primary index value thus:

select ...whatever...
from your.table
where hashrow(primary,index,values) = '96c4793b'xb ;

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023