I have a maintenance plan that includes an index reorganization step. I am getting the following error in the job history:
Executing the query "ALTER INDEX [SpatialIndex-20180705-165942] ON [dbo..." failed with the following error: "The index "SpatialIndex-20180705-165942" on table "extended_index_113435478_384000" cannot be reorganized because page level locking is disabled.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Now, yesterday I found the index with that name on a table that was NOT named "extended_index_113435478_384000." I changed the spatial index to allow both row and page locks. But I let the job run overnight and it still shows an error on the "extended index," which appears to be an internal table that I can't get at.
How to I resolve this error?