SQL Server Index error after SP1

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

SQL Server Index error after SP1

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Operations Manager >> SQL Server Index error after SP1

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Server Index error after SP1 - 6/11/2008 6:14:20 PM

mdermer

Posts: 15
Score: 0
Joined: 11/17/2006
Status: offline

We are getting a "rebuild Index Task Execute SQL Task" error daily on our OM operations Database. The exact error is as follows:

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Error: 2008-06-08 04:06:49.70 Code: 0xC002F210 Source: Rebuild Index Task Execute SQL Task Description: Executing the query "ALTER INDEX [PK__EventStage__09798A13] ON [Event].[EventStage] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) " failed with the following error: "Cannot find index 'PK__EventStage__09798A13'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:05:00 AM Finished: 4:06:50 AM Elapsed: 7310.3 seconds. The package execution failed. The step failed.

Wondering if SP1 did not update the DB correctly? Has anyone seen this issue?

Thanks

Mike