Check DB Error in BW system

[Former Member]

Hello All,

Check DB job ends with following error

-

---

Microsoft SQL Server 2000 - 8.00.2282 (Intel X86)

Dec 30 2008 02:22:41

Copyright (c) 1988-2003 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Msg 8981, Sev 16: Table error: Object ID 800174792, index ID 1. The next pointer of (3:1429711) refers to page (1:1713800). Neither (1:1713800) nor its parent were encountered. Possible bad chain linkage. [SQLSTATE 42000]

Msg 8978, Sev 16: Table error: Object ID 800174792, index ID 1. Page (1:1713801) is missing a reference from previous page (3:1429711). Possible chain linkage problem. [SQLSTATE 42000]

Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in table '/BIC/B0000170000' (object ID 800174792). [SQLSTATE 01000]

Msg 8989, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in database 'B01'. [SQLSTATE 01000]

Msg 8958, Sev 16: repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (B01 ). [SQLSTATE 01000]

-

---

I have checked the table / index in SE14 and there are no inconsistencies. Should i delete and recreate? What could be the cause of the error? Please suggest

Regards,

Anand

[Former Member]

Fixed the issue by adjusting and activating the table