Index Issue w/ Datawarehouse table !!!!

[JamesJKusch]

Anyone have an idea as to this issue given below. pulled it off the detail from job history on a job we have scheduled!

DWF_BN_SALE_DETAIL: START: Warehousing for Oct 31 2000 12:00AM - Datawarehouse [SQLSTATE 01000] (Message 0) The index entry for row ID was not found in index ID 9, of table 1508200423, in database 'DataWarehouse'. [SQLSTATE HY000] (Error 8646). The step failed.


any help would be great!

Thanks
J. Kusch

 

[Tim1]

Hi James,

It sounds like your index may have become corrupted. Depending on the size of the table, the options you have are:

1. Drop and re-build the index
2. Run DBCC and see if this identifies and solves the problem.

Good luck,

Tim

 

[JamesJKusch]

i was ahead of you by just a step. i ran DBCC with the following params ... DBCC DBREINDEX (TableName, '', 70). this command rebuilds all indexes on the tablename listed w/ a fill factor of 70. this way it pretty automatic and there are few steps in dropping and then recreating the indexes. i do thank you for your quick response!!

J. Kusch

 

[Cagliostro]

I think you try to insert in a table with a foreign key, a value what in missed in the table source for this key. John Fill