Поломался индекс #583921

Почему то поломалось :( DBCC CHECKTABLE ('_AccumReg5227', REPAIR_REBUILD) выдал такое: Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._AccumReg5227' and the index name '_AccumR5227_ByPeriod_TRN'. The duplicate key value is (Apr 16 2007  4:04PM, 0x00000089, 0xa5100004234739b411dbec1336244252, 2). Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._AccumReg5227' and the index name '_AccumR5227_ByRecorder_RN'. The duplicate key value is (0x0000006c, 0xa5100004234739b411dbec0f0c1decf1, 1). Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._AccumReg5227' and the index name '_AccumR5227_ByDims6441_RTRN'. The duplicate key value is (0xbded0030482898d011db311790fdc447, Apr 16 2007  4:04PM, 0x00000089, 0xa5100004234739b411dbec1a09050824, 6). Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._AccumReg5227' and the index name '_AccumR5227_ByDims6442_RTRN'. The duplicate key value is (0x89130030482898d011da92bb2ba30108, Apr 16 2007  4:10PM, 0x00000089, 0xa5100004234739b411dbec1b635d61dd, 1). Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._AccumReg5227' and the index name '_AccumR5227_ByDims6443_RTRN'. The duplicate key value is (0x89130030482898d011da92b1dedbd77d, Apr 16 2007  4:04PM, 0x00000089, 0xa5100004234739b411dbec1336244252, 2). Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._AccumReg5227' and the index name '_AccumR5227_ByDims6444_RTRN'. The duplicate key value is (0xa79841ebe5e5b977449b6bced05404a0, Apr 16 2007  4:04PM, 0x00000089, 0xa5100004234739b411dbec1336244252, 2). DBCC results for '_AccumReg5227'. Msg 8945, Level 16, State 1, Line 1 Table error: Object ID 2033650538, index ID 1 will be rebuilt.        Could not repair this error. Msg 8933, Level 16, State 1, Line 1 Table error: Object ID 2033650538, index ID 1, partition ID 72057674994876416, alloc unit ID 72057675083481088 (type In-row data). The low key value on page (1:2688816) (level 0) is not >= the key value in the parent (1:2659483) slot 102.        The error has been repaired. Msg 8934, Level 16, State 2, Line 1 Table error: Object ID 2033650538, index ID 1, partition ID 72057674994876416, alloc unit ID 72057675083481088 (type In-row data). The high key value on page (1:2688822) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:2688823).        The error has been repaired. Msg 8934, Level 16, State 3, Line 1 Table error: Object ID 2033650538, index ID 1, partition ID 72057674994876416, alloc unit ID 72057675083481088 (type In-row data). The high key value on page (1:2688822) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:2688823).        The error has been repaired. Msg 8933, Level 16, State 1, Line 1 Table error: Object ID 2033650538, index ID 1, partition ID 72057674994876416, alloc unit ID 72057675083481088 (type In-row data). The low key value on page (1:2688823) (level 0) is not >= the key value in the parent (1:2659483) slot 109.        The error has been repaired. Msg 8934, Level 16, State 2, Line 1 Table error: Object ID 2033650538, index ID 1, partition ID 72057674994876416, alloc unit ID 72057675083481088 (type In-row data). The high key value on page (1:2856666) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:2688816).        The error has been repaired. Msg 8934, Level 16, State 3, Line 1 Table error: Object ID 2033650538, index ID 1, partition ID 72057674994876416, alloc unit ID 72057675083481088 (type In-row data). The high key value on page (1:2856666) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:2688816).        The error has been repaired. Msg 8945, Level 16, State 1, Line 1 Table error: Object ID 2033650538, index ID 2 will be rebuilt.        Could not repair this error. Msg 8945, Level 16, State 1, Line 1 Table error: Object ID 2033650538, index ID 3 will be rebuilt.        Could not repair this error. Msg 8945, Level 16, State 1, Line 1 Table error: Object ID 2033650538, index ID 4 will be rebuilt.        Could not repair this error. Msg 8945, Level 16, State 1, Line 1 Table error: Object ID 2033650538, index ID 5 will be rebuilt.        Could not repair this error. Msg 8945, Level 16, State 1, Line 1 Table error: Object ID 2033650538, index ID 6 will be rebuilt.        Could not repair this error. There are 19429776 rows in 373949 pages for object "_AccumReg5227". CHECKTABLE found 0 allocation errors and 6 consistency errors in table '_AccumReg5227' (object ID 2033650538). CHECKTABLE fixed 0 allocation errors and 6 consistency errors in table '_AccumReg5227' (object ID 2033650538). DBCC execution completed. If DBCC printed error messages, contact your system administrator. The statement has been terminated. После Dropa создаю ручками: CREATE UNIQUE CLUSTERED INDEX [_AccumR5227_ByPeriod_TRN] ON [dbo].[_AccumReg5227] ( The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._AccumReg5227' and the index name '_AccumR5227_ByPeriod_TRN'. The duplicate key value is (Apr 16 2007  4:04PM, 0x00000089, 0xa5100004234739b411dbec1336244252, 2). The statement has been terminated. Как вылечить?

Очевидно грохнуть дублирующиеся записи ? А с какой целью запускал dbcc checktable ?

в табличке _AccumReg5227 в колонке _AccumR5227_ByPeriod_TRN есть дублирующие строки нужно оставить только одну

Обслуживание вешается Индексы все удалил. Создать новые не дает.

те одну лишнюю строку из регистра надо удалить, можно попробовать запустить ТИИ, мож само удалит. Можно док который сделал кривые движения найти и перепровести.

ТИИ не устроит.

Вот такую картину нашел: И как ЭТО запросом найти...

да вроде нормальная картинка. что в ней не так?

сделай в запросе count по регистратору с упорядочиванием по убыванию. покажет 2 штуки?

номер строки в ней не так. сразу не разглядел

отмени проведение документа. и проведи заново.

если не дает отменить проведение или перепровести, грохни через скуль записи по регистратору. потом проведи нормально.

через скуль грохни записи, создай индексы, отмени и проведи документ. Удачи.

На копии получилось. Удалил индексы, перепровел документы в проблемных минутах, создал индексы.