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>>