数据库教程:MSSQL 数据库 buildindex 出错

错误1: Executing the query "ALTER INDEX [IX_liveConfigState_Service_ServiceId_…" failed with the following error: "The index "IX_liveConfigState_Servi …

错误1:

executing the query “alter index [ix_liveconfigstate_service_serviceid_…” failed with the following error: “the index “ix_liveconfigstate_service_serviceid_grouprightsversion” on table “liveconfigstate_service” 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.

 

解决方案:

query the indexes and tables list with follow query, then enable their(index) page lock setting from property setting dialog.

 

select object_name(i.object_id) as tablename ,

name as indexname ,

allow_page_locks 

from sys.indexes as i

where allow_page_locks = 0

正常应该只有如下三条记录:

MSSQL 数据库 buildindex 出错

 reference page:

https://mr-spapp-01.mr.ericsson.se/sites/mediaroom/productdevelopment/engineering/test/mrscale/_layouts/15/wopiframe2.aspx?sourcedoc=%2fsites%2fmediaroom%2fproductdevelopment%2fengineering%2ftest%2fmrscale%2fshared%20documents%2ftests%2fplans%2finternal%2foob%2fa%2dla%2dcarte%20max%20900%20subgroup%20per%20account%2fa%2dla%2dcartemax900subgroupperaccounttest%2edocx&action=view&wdparaid=2e1e070d

需要了解更多数据库技术:MSSQL 数据库 buildindex 出错,都可以关注数据库技术分享栏目—计算机技术网(www.ctvol.com)!

www.ctvol.com true Article 数据库教程:MSSQL 数据库 buildindex 出错

本文来自网络收集,不代表计算机技术网立场,如涉及侵权请联系管理员删除。

ctvol管理联系方式QQ:251552304

本文章地址:https://www.ctvol.com/dtteaching/624058.html

(0)
上一篇 2021年5月24日 下午11:46
下一篇 2021年5月24日 下午11:48

精彩推荐