[SharePoint] "The index cannot be reorganized because page level locking is disabled" Spanish/english

  • Article

English Version Below!

 

Si tenéis un paso de reordenación de índices en algún plan de mantenimiento para Bases de datos de SharePoint puede que os devuelva el siguiente error:

 

Failed:(-1073548784)
Executing the query "ALTER INDEX
[IX_WABestBetUsageAggregationByDate_Ag..." failed with the following error: "The index"IX_WABestBetUsageAggregationByDate_AggregationId_IncludeSubSites_DateId" (partition 1) on table "WABestBetUsageAggregationByDate" 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.

 Es un error esperado. Lo primero que se nos ocurre es permitir el Page Level Locking, que no está soportado para SharePoint. La solución es deshabilitar el plan de mantenimiento de los índices que los reorgaiza y crear uno de reconstrucción de indices en su lugar.

 

Resumen:

- No esta soportado habilitar Allow Page Blocks en SharePoint

- No se recomienda hacer reordenación de índices

- Sí se permite Reconstrucción de indices.

 

ENGLISH VERSION __________________________________________________________________________________________________________________________________________

 

If you have an Index Reorder Management plan for any SharePoint Database, it may return the following error:

 

Failed:(-1073548784)
Executing the query "ALTER INDEX
[IX_WABestBetUsageAggregationByDate_Ag..." failed with the following error: "The index"IX_WABestBetUsageAggregationByDate_AggregationId_IncludeSubSites_DateId" (partition 1) on table "WABestBetUsageAggregationByDate" 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.

 This is an expected error. First thing would come to your mind is to Allow Page Block, this is not supported in SharePoint Databases. The solution would be, disable the reorder step of the management plan and add a REBUILD INDEX step instead.

 

Summary:

- Allow Page Blocks is not supported for SharePoint Database level indexes

- It is not recommended to reorder SharePoint database level indexes.

- You are allowed to rebuild indexes.