Set-spsiteUrl给出错误:EXECUTE之后的事务计数指示BEGIN和COMMIT语句的数量不匹配. [英] Set-spsiteUrl gives error : Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements.

问题描述

嗨

使用SharePoint Server 2013.

我有一个名为网站集的主机http://management.contoso.com
当我尝试使用Set-spsiteUrl cmdlet添加另一个URL时，出现以下错误:

 PS C:\ Users \ svc_spinstall> Set-SPSiteURL http://management.contoso.com -Zone Intranet -Url http://management
Set-SPSiteURL:EXECUTE之后的事务计数指示BEGIN和COMMIT语句的数量不匹配.上一个计数= 0，当前计数= 1.
表"AllSites".扫描计数为0，逻辑读取为3，物理读取为0，预读为0，lob逻辑读取为0，lob物理读取为0，lob提前读取为0.
表'#B65D0B8A'.扫描计数0，逻辑读2，物理读0，预读0，lob逻辑读0，lob物理读0，lob预读0.
表'#B7512FC3'.扫描计数1，逻辑读1，物理读0，预读0，lob逻辑读0，lob物理读0，lob预读0.
表'#B65D0B8A'.扫描计数1，逻辑读1，物理读0，预读0，lob逻辑读0，lob物理读0，lob预读0.
在第1行:char:1
+ Set-SPSiteURL http://management.contoso.com -Zo ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo:InvalidData:(Microsoft.Share ... letSetSPSiteUrl:SPCmdletSetSPSiteUrl)[Set-SPSiteURL]，SqlException
    + FullyQualifiedErrorId:Microsoft.SharePoint.PowerShell.SPCmdletSetSPSiteUrl 

有人看过吗?

兄弟

比约恩

解决方案

这是SQL方面的一般错误消息，很难找出根本原因.

请尝试运行Get-SPSiteURL以获取此网站集的所有URL并在此处提供结果.

要解决此问题，请尝试重现此问题并检查ULS日志，这将为您提供有关此问题的更多信息.

ULS查看器是检查ULS日志的好工具:

https://www.microsoft.com/zh-cn/download/confirmation.aspx?id=44020

谢谢

王恩(Dean Wang)

Hi

Using SharePoint server 2013.

I have a host named site collection http://management.contoso.com
When I try to add a another URL using the Set-spsiteUrl cmdlet, i get the following error:

PS C:\Users\svc_spinstall> Set-SPSiteURL http://management.contoso.com -Zone Intranet -Url http://management
Set-SPSiteURL : Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Table 'AllSites'. Scan count 0, logical reads 3, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table '#B65D0B8A'. Scan count 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table '#B7512FC3'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table '#B65D0B8A'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
At line:1 char:1
+ Set-SPSiteURL http://management.contoso.com -Zo ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidData: (Microsoft.Share...letSetSPSiteUrl:SPCmdletSetSPSiteUrl) [Set-SPSiteURL], SqlException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletSetSPSiteUrl

Any one seen this before?

brgs

Bjørn

解决方案

Hi,

It’s a general error message from SQL side, which is hard to figure out the root cause.

Please try to run Get-SPSiteURL to get all URLs of this site collection and provide the results here.

To fix this issue, please try to reproduce this issue and check ULS logs, which would give you more information about this issue.

ULS viewer is a good tool to check for ULS logs:

https://www.microsoft.com/en-us/download/confirmation.aspx?id=44020

Thanks,

Dean Wang

这篇关于Set-spsiteUrl给出错误:EXECUTE之后的事务计数指示BEGIN和COMMIT语句的数量不匹配.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！