Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AnitaDBA2010
Starting Member
18 Posts |
 Posted - 2011-01-18 : 16:14:15
|
| Hi SQL gurus-While running weekly maintenance plan the reorganizing the index task fails with below error. Executing the query "ALTER INDEX [IX_HealthAvgData_Branch] ON [dbo].[He..." failed with the following error: "Cannot find index 'IX_HealthAvgData_Branch'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.I generated the T-sql script for this task and found the below query within the script referencing the above missing index from the error msgUSE [WarehouseReporting]GOALTER INDEX [IX_HealthAvgData_Branch] ON [dbo].[HealthAvgData] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )I verified manually that the index 'IX_HealthAvgData_Branch' does exist in the database and table referenced in the above query Than i ran the above alter index query in SSMS and it worked fine and than I ran a execute t-sql task using above query and it was successfull too. Any ideas what am i missing here, i am running out of ideas and hence need your suggestions :)(This plan consists of other tasks as well such as backup, update statistics, clean up etc)ThanksAnitaAnita |
|
|
AnitaDBA2010
Starting Member
18 Posts |
Posted - 2011-01-18 : 19:17:10
|
| I believe the issue was temporary, i ran the task reorganize index package by itself and it executed successfully. so the whole package should run successfully shcheduled to run once in a weekAnita |
 |
|
|
|
|
|
|
|
Cannot find index issue, rebuild index task