Since we have upgraded to SQL 2017 and Epicor 10.2.200.x, we can’t run the maintenance plan to reorganize indexes. Its failing on different tables with the error: cannot be reorganized because page level locking is disabled.
Anyone seen that before?
example: Executing the query “ALTER INDEX [PK_ABTPostCode] ON [Erp].[ABTPostCode…” failed with the following error: “The index “PK_ABTPostCode” on table “ABTPostCode” 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.
Executing the query “ALTER INDEX [IX_APInvDtl_AssetNum] ON [Erp].[APInv…” failed with the following error: “The index “IX_APInvDtl_AssetNum” on table “APInvDtl” 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.