October 25, 2012 at 10:40 pm
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.
November 9, 2012 at 10:23 pm
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
February 16, 2013 at 2:35 am
opc.three (11/9/2012)
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.
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,
February 16, 2013 at 3:32 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2013 at 1:21 pm
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply