Data consistency Issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Data consistency Issue

Author

Topic

rikleo2001
Posting Yak Master

185 Posts

Posted - 2007-01-15 : 18:08:45

Hello Experts,

Posted initial issue under following ID.
http://sqlteam.com/forums/topic.asp?TOPIC_ID=77603

Here is output produced by DBCC CHECKDB

Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:8) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:9) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:10) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:11) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:12) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:13) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:14) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:15) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:16) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:38) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:39) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:40) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:41) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:42) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:43) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:44) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:0) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:1) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:2) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:7) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:8) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:9) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:10) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:11) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:12) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:0) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:1) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:2) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:3) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:4) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:5) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:464181:0) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:464181:1) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:0) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:1) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:2) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:3) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:4) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:5) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:6) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:7) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-H' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:0) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:1) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:2) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:3) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:4) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:5) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:6) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:7) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-H' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:8) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-I' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:3) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:4) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:5) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:6) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-D' and ? = NULL) points to the data row identified by ().
DBCC results for 'dbS_CoreData'.
DBCC results for 'sysobjects'.
There are 341 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 610 rows in 42 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 2035 rows in 41 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 348 rows in 94 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 116 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 16 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 5 rows in 2 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 2690 rows in 15 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 22 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'tmp_KCE_Eval_Round'.
There are 1 rows in 1 pages for object 'tmp_KCE_Eval_Round'.
DBCC results for 'tmp_KCE_Eval_Property'.
There are 20 rows in 1 pages for object 'tmp_KCE_Eval_Property'.
DBCC results for 'tmp_KCE_Eval_Task'.
There are 33 rows in 2 pages for object 'tmp_KCE_Eval_Task'.
DBCC results for 'tmp_KCE_Eval_Note'.
There are 113 rows in 3 pages for object 'tmp_KCE_Eval_Note'.
DBCC results for 'tmp_KCE_Train_Round'.
There are 1 rows in 1 pages for object 'tmp_KCE_Train_Round'.
DBCC results for 'tmp_KCE_Train_Property'.
There are 30 rows in 1 pages for object 'tmp_KCE_Train_Property'.
DBCC results for 'tmp_KCE_Train_Task'.
There are 38 rows in 2 pages for object 'tmp_KCE_Train_Task'.
DBCC results for 'dlg_TeamCodes'.
There are 34 rows in 1 pages for object 'dlg_TeamCodes'.
DBCC results for 'cur_Round'.
There are 894 rows in 39 pages for object 'cur_Round'.
DBCC results for 'tmp_KCE_Train_Note'.
There are 160 rows in 4 pages for object 'tmp_KCE_Train_Note'.
DBCC results for 'dlg_Users'.
There are 397 rows in 16 pages for object 'dlg_Users'.
DBCC results for 'cur_Property'.
There are 92033 rows in 6880 pages for object 'cur_Property'.
DBCC results for 'cur_Task'.
There are 125253 rows in 9057 pages for object 'cur_Task'.
DBCC results for 'cur_Note'.
There are 339746 rows in 14089 pages for object 'cur_Note'.
CHECKDB found 0 allocation errors and 54 consistency errors in table 'cur_Note' (object ID 246291937).
DBCC results for 'arc_Note'.
There are 15609480 rows in 310776 pages for object 'arc_Note'.
DBCC results for 'arc_FieldNote'.
There are 1633726 rows in 41597 pages for object 'arc_FieldNote'.
DBCC results for 'dlg_UserTasks'.
There are 3116 rows in 39 pages for object 'dlg_UserTasks'.
DBCC results for 'dlg_ImportDetails'.
There are 1958 rows in 36 pages for object 'dlg_ImportDetails'.
DBCC results for 'arc_Property'.
There are 3729453 rows in 128092 pages for object 'arc_Property'.
DBCC results for 'arc_Round'.
There are 99219 rows in 2010 pages for object 'arc_Round'.
DBCC results for 'arc_Task'.
There are 5445171 rows in 185259 pages for object 'arc_Task'.
DBCC results for 'cur_FieldNote'.
There are 5647 rows in 242 pages for object 'cur_FieldNote'.
DBCC results for 'dlg_tmpAddZone'.
There are 0 rows in 15 pages for object 'dlg_tmpAddZone'.
DBCC results for 'dlg_Clients'.
There are 30 rows in 1 pages for object 'dlg_Clients'.
DBCC results for 'GenesisCheckReads'.
There are 13932 rows in 277 pages for object 'GenesisCheckReads'.
DBCC results for 'tmp_Duplicate_Tasks'.
There are 3947 rows in 127 pages for object 'tmp_Duplicate_Tasks'.
DBCC results for 'log_RoundActivity'.
There are 429434 rows in 5074 pages for object 'log_RoundActivity'.
DBCC results for 'copy_cur_Task'.
There are 138705 rows in 4439 pages for object 'copy_cur_Task'.
DBCC results for 'RoundTable'.
There are 5419 rows in 43 pages for object 'RoundTable'.
DBCC results for 'dlg_TaskTypes'.
There are 15 rows in 1 pages for object 'dlg_TaskTypes'.
DBCC results for 'log_Activity'.
There are 458463 rows in 9322 pages for object 'log_Activity'.
DBCC results for 'lib_RoundPerformance'.
There are 99387 rows in 2601 pages for object 'lib_RoundPerformance'.
DBCC results for 'dlg_SysUtilsRoundsRef'.
There are 1 rows in 1 pages for object 'dlg_SysUtilsRoundsRef'.
DBCC results for 'khutemp'.
There are 19747 rows in 470 pages for object 'khutemp'.
DBCC results for 'tmp_TempICPs'.
There are 14 rows in 1 pages for object 'tmp_TempICPs'.
DBCC results for 'dlg_Holidays'.
There are 53 rows in 1 pages for object 'dlg_Holidays'.
DBCC results for 'log_Comms'.
There are 2168949 rows in 73621 pages for object 'log_Comms'.
DBCC results for 'dlg_RefRound'.
There are 196 rows in 1 pages for object 'dlg_RefRound'.
DBCC results for 'Temp_RFICP'.
There are 38 rows in 1 pages for object 'Temp_RFICP'.
DBCC results for 'dlg_AreaCodes'.
There are 62 rows in 1 pages for object 'dlg_AreaCodes'.
DBCC results for 'dlg_GroupDetails'.
There are 350 rows in 5 pages for object 'dlg_GroupDetails'.
DBCC results for 'dlg_Countries'.
There are 3 rows in 1 pages for object 'dlg_Countries'.
DBCC results for 'dlg_Groups'.
There are 18 rows in 1 pages for object 'dlg_Groups'.
DBCC results for 'dlg_DumpResultImport'.
There are 0 rows in 0 pages for object 'dlg_DumpResultImport'.
DBCC results for 'dlg_Companies'.
There are 4 rows in 1 pages for object 'dlg_Companies'.
DBCC results for 'dlg_UserDetails'.
There are 188 rows in 3 pages for object 'dlg_UserDetails'.
DBCC results for 'tmp_EOLUnreadICPs'.
There are 28 rows in 1 pages for object 'tmp_EOLUnreadICPs'.
DBCC results for 'log_Importfiles'.
There are 2022 rows in 145 pages for object 'log_Importfiles'.
DBCC results for 'dlg_UserSecurity'.
There are 188 rows in 2 pages for object 'dlg_UserSecurity'.
DBCC results for 'log_LoginSession'.
There are 2049029 rows in 35632 pages for object 'log_LoginSession'.
DBCC results for 'dlg_DeviceDetails'.
There are 197 rows in 7 pages for object 'dlg_DeviceDetails'.
DBCC results for 'cur_FieldResult'.
There are 23907 rows in 899 pages for object 'cur_FieldResult'.
DBCC results for 'arc_FieldResult'.
There are 5539213 rows in 168533 pages for object 'arc_FieldResult'.
DBCC results for 'dlg_DialogServerLog'.
There are 1442 rows in 33 pages for object 'dlg_DialogServerLog'.
DBCC results for 'dlg_UserZones'.
There are 6484 rows in 56 pages for object 'dlg_UserZones'.
DBCC results for 'log_RPT_Selection_Crieteria'.
There are 64529 rows in 21127 pages for object 'log_RPT_Selection_Crieteria'.
DBCC results for 'log_Communication_Detail'.
There are 8175148 rows in 87720 pages for object 'log_Communication_Detail'.
DBCC results for 'dlg_ZoneCodes'.
There are 2268 rows in 28 pages for object 'dlg_ZoneCodes'.
DBCC results for 'DRQA01MRP'.
There are 83 rows in 2 pages for object 'DRQA01MRP'.
DBCC results for 'tmp_abc'.
There are 3 rows in 1 pages for object 'tmp_abc'.
DBCC results for 'dlg_DumpNoteImport'.
There are 14 rows in 1 pages for object 'dlg_DumpNoteImport'.
DBCC results for 'dlg_FilePaths'.
There are 1 rows in 1 pages for object 'dlg_FilePaths'.
DBCC results for 'dlg_MRPErrors'.
There are 296 rows in 12 pages for object 'dlg_MRPErrors'.
DBCC results for 'rpt_SubHeaderInfo'.
There are 46 rows in 3 pages for object 'rpt_SubHeaderInfo'.
DBCC results for 'dlg_SystemUtilities'.
There are 7 rows in 1 pages for object 'dlg_SystemUtilities'.
DBCC results for 'dlg_ErrorLog'.
There are 1401 rows in 49 pages for object 'dlg_ErrorLog'.
DBCC results for 'dlg_ExportDetails'.
There are 69883 rows in 4581 pages for object 'dlg_ExportDetails'.
DBCC results for 'dtproperties'.
There are 28 rows in 1 pages for object 'dtproperties'.
DBCC results for 'dlg_Tasks'.
There are 72 rows in 1 pages for object 'dlg_Tasks'.
DBCC results for 'log_RoundPerform'.
There are 0 rows in 0 pages for object 'log_RoundPerform'.
DBCC results for 'rpt_HeaderInfo'.
There are 4 rows in 1 pages for object 'rpt_HeaderInfo'.
DBCC results for 'dlg_Supervisors'.
There are 1613 rows in 13 pages for object 'dlg_Supervisors'.
CHECKDB found 0 allocation errors and 54 consistency errors in database 'dbS_CoreData'.
repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (dbS_CoreData ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

*PLease LET ME KNOW WHAT IS RECOMMENED FURTHER STEP IN ORDER TO ELIMINATE THIS ERROR PERMANENTLY.. THANKS IN ADVANCE.
I am using SQL 2000 WITH sp4.

SKR

rikleo2001
Posting Yak Master

185 Posts

Posted - 2007-01-16 : 03:54:16

Any Help Please? It is 10:00 pm and this is only time when I can apply anything on production server, any tips to get rid of this issue? very much appreciated.

Thanks in advance

SKR

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2007-01-16 : 17:43:16

Hi,

First off - you shouldn't rely on internet forums for *guaranteed* timely help with disaster-related problems such as this. If its really that time-critical, open a case with Product Support rather than waiting for one of us to respond.

From the other topic, it seems you've got issues with your IO subsystem. You need to fix that to prevent a recurrence of these problems.

To fix these errors, you can simply rebuild the index specified in the error messages - you don't need to to do it using CHECKDB.

Thanks

Paul Randal
Principal Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
http://blogs.msdn.com/sqlserverstorageengine/default.aspx

rikleo2001
Posting Yak Master

185 Posts

Posted - 2007-01-21 : 19:38:37

Thanks Paul.
Sorry for Late reply..
I Done index rebuilding. Got error.
Then I executed CHECKDB with Repair_Fast option, and It worked this time., I then re-built all Indexes again.
As I told I am running this VMWARE, and I asked from Network department to do a complete scan of VMWARE system and they mentioned that there are no known errors.

I take it as my luck. Many Thanks Paul for your help.

It would be really great that I can have any guideline about how to regularly perform tuning on my production database?
Much appreciated.

SKR

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources