Running SQL Maintenance on an Accelerator Customer database fails: page level locking is disabled
Article ID: 100032371
Updated On:
Description
Error Message
Here is an example of the error when running an index reorganize:
Executing the query "ALTER INDEX [PK_tblIntDiscoveredItems] ON [dbo].[t..." failed with the following error: "The index "PK_tblIntDiscoveredItems" on table "tblIntDiscoveredItems" 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.
Cause
Page Level Locking has been disabled for this Index. More information will be added here as is found.
Resolution
Currently, the only solution is to rebuild the Index with the Enterprise Vault Accelerator Manager Service (EVAMS) stopped. This can be done as part of Maintenance per article 'How to Automatically Backup and Perform Recommended Maintenance for Enterprise Vault (EV), Compliance Accelerator (CA), and Discovery Accelerator (DA) SQL databases', listed under related articles below. Alternately, the following query can be used to rebuild the index and update the statistics. Please change to the appropriate Customer database name, stop the EVAMS, execute the query with the EVAMS stopped, and then start the EVAMS.
USE [];
GO
ALTER INDEX [PK_tblIntDiscoveredItems]
ON [dbo].[tblIntDiscoveredItems]
REBUILD
PARTITION = ALL
WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF );
GO
UPDATE STATISTICS [dbo].[tblIntDiscoveredItems]
WITH FULLSCAN;
GO Issue/Introduction
When running SQL Maintenance on an Accelerator Customer database, the index reorganize maintenance operation fails with an error pointing to page level locking (PLL) being disabled.
Additional Information
ETrack: 3875244
Was this article helpful?
Yes
No
Powered by
