Reorg error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Reorg error

Reorg error

Rate Topic

Display Mode

Topic Options

Author

Message

RK2012

Posted Thursday, October 25, 2012 10:40 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 10, 2013 11:44 AM
Points: 42, Visits: 240

Hello,

My job got failed due to below error

Cannot find partition number 1 for index ID 30, object ID 437576597. [SQLSTATE 42000] (Error 2588) DBCC execution completed

Kindly help me on this.

Post #1377390

opc.three

Posted Friday, November 09, 2012 10:23 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737, Visits: 11,791

I have not seen that error before, but it does not sound good. Have you run DBCC CHECKDB(your_dbname) WITH NO_INFOMSGS on your database lately? If you run it and it returns errors post the complete output here.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1383327

fullname-214799

Posted Saturday, February 16, 2013 2:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 16, 2013 1:10 PM
Points: 2, Visits: 5

opc.three (11/9/2012)

Hi,

I have the same problem like RK2012. Ran dbcc as you said and it returned no errors. What shpuld I do next. Also RK2012 did you find a solution that you can post here. Thanks in advance,

Post #1420874

GilaMonster

Posted Saturday, February 16, 2013 3:32 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744, Visits: 30,025

Run the following, post the full, complete and unedited output

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1420878

fullname-214799

Posted Saturday, February 16, 2013 1:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 16, 2013 1:10 PM
Points: 2, Visits: 5

origininal error message after running exec [sp_ShowContigAll] 0,1,95 was
"Msg 2588, Sev 16, State 3, Line 1 : Cannot find partition number 1 for index ID 19, object ID 803586001. [SQLSTATE 42000]"

I ran dbcc checkdb and check alloc and both returned no errors, the db is perfectly normal. But I also found my own answer too.

Some other admin had started "Database Engine Tuning Advisor" and the process died unexpectedly and all the Hypothetical Indexes and Statistics
were not cleared. The index pointed in the error message is one of those, so I cleared all of those with this script and reindexed the db with no problem. I hope it helps some others.

select 'drop index ' + b.name + '.' + a.name
from sys.indexes a, sys.all_objects b
where a.object_id = b.object_id and is_hypothetical = 1

[url=http://msdn.microsoft.com/en-us/library/ms190172(v=sql.105).aspx][/url]

Post #1420922

« Prev Topic | Next Topic »

Permissions