SQLTeam.com | Weblogs | Forums

Reorganize index task failed


#1

Good Morning Everyone,

Reorgainize index task(maintenance plan) failed today with below error:
Reorganize index task The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute method must succeed, and indicate the result using an "out" parameter.

It ran successfully previously. I dont see anything changed. I checked the maintenance plan history but it does not have any information. I checked error logs but did not find any message related to this.

Please help


#2

Long shot:

Clustered index dropped and Table has become a Heap?


#3

Dear kristen sir,
Thanks a lot for replying and helping beginners like me. The maintenance task ran midnight and to the best of my knowledge, no clustered index has been dropped. Please advise