Rebuilding index failed

Question

Post reply

Rebuilding index failed

SkyBVI

SSCoach

Points: 15115
More actions
October 11, 2010 at 9:33 am

#157249

Hi,

I have an automated job that runs rebuiilding indexes on a production server every weekend..

I got this error :-

Executed as user: Domain\gpsqlagent. ...ex Task Executing query "USE [db name] ".: 1% complete End Progress Progress: 2010-10-10 00:01:27.75 Source: Rebuild Index Task Executing query "ALTER INDEX [addon_packsize_nc] ON [dbo].[addon] R".: 1% complete End Progress Progress: 2010-10-10 00:01:27.75 Source: Rebuild Index Task Executing query "USE [db name] ".: 1% complete End Progress Progress: 2010-10-10 00:01:27.75 Source: Rebuild Index Task Executing query "ALTER INDEX [addon_pk] ON [dbo].[addon] REBUILD WI".: 1% complete End Progress Progress: 2010-10-10 00:01:27.75 Source: Rebuild Index Task Executing query "USE [db name] ".: 1% complete End Progress Progress: 2010-10-10 00:01:27.75 Source: Rebuild Index Task Executing query "ALTER INDEX [addon_productpack_nc] ON [dbo].[addon".: 1% complete End Progress Progress: 2010-10-10 00:01:27.75 Source: Rebuild Index Task Executing query "USE [db name] "... The package execution fa... The step failed.

I see that the table dbo.addon has all the three indexes which failed to rebuild.

So how should I procedd, should i rebuild the particular indexes from SSMS again or

is there any other way to solve the error??

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

GSquared

SSC Guru

Points: 260824

October 11, 2010 at 9:54 am

#1235085

Can you open up the error log and get the rest of the error message?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SkyBVI SSCoach Points: 15115 More actions · Answer 2

SkyBVI

SSCoach

Points: 15115

October 11, 2010 at 10:14 am

#1235106

on error log i got :"-

DBCC CHECKDB (db name) WITH no_infomsgs executed by domain name \gpsqlagent found 1 errors and repaired 0 errors. Elapsed time: 0 hours 1 minutes 52 seconds.

It is because I had selected check database consistency after that step (on completion)

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

Joie Andrew

One Orange Chip

Points: 27360

October 11, 2010 at 3:53 pm

#1235251

What do you get when you run the following:

dbcc checkdb (dbname) with no_infomsgs, all_errormsgs

Joie Andrew
"Since 1982"

SkyBVI SSCoach Points: 15115 More actions · Answer 4

@ joie

Msg 2508, Level 16, State 1, Line 2

The In-row data USED page count for object "rtw_count_variance", index ID 0, partition ID 42277782945792, alloc unit ID 42277782945792 (type In-row data) is incorrect.

Run DBCC UPDATEUSAGE.

CHECKDB found 0 allocation errors and 1 consistency errors in table 'rtw_count_variance' (object ID 645107772).

CHECKDB found 0 allocation errors and 1 consistency errors in database 'xyz'.