错误'文件正被......修改' [英] error 'the file is being modified by ...'
问题描述
大家好，
有时/对于某些文档，会出现此错误：
Sometimes / with some documents, this error occurs:
我编辑文档属性并按保存。
然后发生错误："对不起，出了点问题。 [我]在[当前时间]修改该项目< b $ b见截图。
I edit the document properties and press save.
Then an error occurs: "sorry, something went wrong. The item is being modified by [me] on [current time]"
See screenshot.
在ULS日志中，有一些可能相关的"高级"条目：
In the ULS logs there are some 'High' level entries that might be relevant:
System.Data.SqlClient.SqlException（0x80131904）：违反PRIMARY KEY约束' AllUserDataJunctions_PK"。无法在对象'dbo.AllUserDataJunctions'中插入重复键。重复键值为（d9d28702-d163-4d12-8193-bad5dbf51420,0x，0,7ee15c57-5538-4486-ae44-c891ed990da7，
b328aba8-34dd-482e-8b9b-7301f25b503c，4097,2,71c46023- b174-4158-aa51-6e745d65733d，0）。 EXECUTE之后的事务计数表示BEGIN和COMMIT语句的数量不匹配。以前的计数= 1，当前计数= 0. 该声明已被终止
。
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'AllUserDataJunctions_PK'. Cannot insert duplicate key in object 'dbo.AllUserDataJunctions'. The duplicate key value is (d9d28702-d163-4d12-8193-bad5dbf51420, 0x, 0, 7ee15c57-5538-4486-ae44-c891ed990da7, b328aba8-34dd-482e-8b9b-7301f25b503c, 4097, 2, 71c46023-b174-4158-aa51-6e745d65733d, 0). Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. The statement has been terminated.
在System.Data.SqlClient.SqlConnection.OnError（SqlException异常，Boolean breakConnection，Action`1 wrapCloseInAction） System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning（TdsParserStateObject stateObj，Boolean callerHasConnectionLock，Boolean asyncClose）
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在System.Data.SqlClient.TdsParser.TryRun（RunBehavior runBehavior，SqlCommand的cmdHandler，SqlDataReader的数据流，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj，布尔&安培; dataReady）&NBSP;&NBSP;&NBSP ; System.Data.SqlClient.SqlDataReader.TryConsumeMetaData（）
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在System.Data.SqlClient.SqlDataReader.get_MetaData（）
at System.Data.SqlClient.SqlDataReader.get_MetaData()
在System.Data.SqlClient.SqlCommand.FinishExecuteReader（SqlDataReader ds，RunBehavior runBehavior，String resetOptionsString） System.Data.SqlClient.SqlCommand.RunExecuteReaderTds上的
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
（CommandBehavior cmdBehavior，RunBehavior runBehavior，布尔returnStream，布尔异步，Int32超时，任务和任务，布尔asyncWrite，SqlDataReader ds ）&NBSP;&NBSP;&NBSP; System.Data.SqlClient.SqlCommand.RunExecuteReader（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，String method，TaskCompletionSource`1 completion，Int32 timeout，Task& task，
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
布尔asyncWrite） System.Data.SqlClient.SqlCommand.RunExecuteReader（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，String method）
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
System.Data.SqlClient.SqlCommand.ExecuteReader（CommandBehavior behavior，String method）
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
System.Data.SqlClient.SqlCommand.ExecuteReader（CommandBehavior behavior）
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader（SqlCommand command，CommandBehavior behavior，SqlQueryData monitoringData，Boolean retryForDeadLock） ClientConnectionId：142ad8c8-4077-4bfc-b4a5-a0071cb5fd8b&NBSP;错误号码：2627，州：1，班级：14
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) ClientConnectionId:142ad8c8-4077-4bfc-b4a5-a0071cb5fd8b Error Number:2627,State:1,Class:14
并且：
SqlError：'EXECUTE后的事务计数表示BEGIN和COMMIT的数量不匹配声明。以前的计数= 1，当前计数= 0.' 来源：'。Net SqlClient数据提供者'编号：266状态：2类：16程序：''LineNumber：
0服务器：'SQL001 \RF_SQL001_1,1433'
SqlError: 'Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.' Source: '.Net SqlClient Data Provider' Number: 266 State: 2 Class: 16 Procedure: '' LineNumber: 0 Server: 'SQL001\RF_SQL001_1,1433'
并且：
报告的错误与代码= 0x81070901和消息之间可能不匹配："Het bestand kwaliteitsdocumenten /（Toekennen autorisaties aan）nieuwe medewerker.docx is gewijzigd door i：0＃.w | rf \ 113150 op 28 mei 2019 09:45:18 + 0200。"并且
返回错误，代码为0x81020037。
Possible mismatch between the reported error with code = 0x81070901 and message: "Het bestand kwaliteitsdocumenten/(Toekennen autorisaties aan) nieuwe medewerker.docx is gewijzigd door i:0#.w|rf\113150 op 28 mei 2019 09:45:18 +0200." and the returned error with code 0x81020037.
此外，还有一个'意外'：
Also, there is one 'unexpected':
System.Runtime.InteropServices.COMException：Het bestand kwaliteitsdocumenten /（Toekennen autorisaties aan）nieuwe medewerker.docx是gewijzigd door i：0＃.w | rf \ 113150 op 28 mei 2019
09:45:18 +0200。 &NBSP;
at Microsoft.SharePoint.Library.SPRequestInternalClass.AddOrUpdateItem（String bstrUrl，String bstrListName，Boolean bAdd，Boolean bSystemUpdate，Boolean bPreserveItemVersion，Boolean
bPreserveItemUIVersion，Boolean bUpdateNoVersion，Int32& plID，String& pbstrGuid，Guid pbstrNewDocId，Boolean bHasNewDocId，String bstrVersion，Object& pvarAttachmentNames，Object&
pvarAttachmentContents，Object& pvarProperties，Boolean bCheckOut，Boolean bCheckin，Boolean bUnRestrictedUpdateInProgress，Boolean bMigration，Boolean bPublish，String bstrFileName，
ISP2DSafeArrayWriter pListDataValidationCallback，ISP2DSafeArrayWriter pRestrictInsertCallback，ISP2DSafeArrayWriter pUniqueFieldCallback） &NBSP;
at Microsoft.SharePoint.Library.SPRequest.AddOrUpdateItem（String bstrUrl，String bstrListName，Boolean bAdd，Boolean bSystemUpdate，Boolean bPreserveItemVersion，Boolean
bPreserveItemUIVersion，Boolean bUpdateNoVersion，Int32& plID，String& pbstrGuid，Guid pbstrNewDocId，Boolean bHasNewDocId，String bstrVersion，Object& pvarAttachmentNames，Object&
pvarAttachmentContents，Object& pvarProperties，Boolean bCheckOut， Boolean bCheckin，Boolean bUnRestrictedUpdateInProgress，Boolean bMigration，Boolean bPublish，String bstrFileName，
ISP2DSafeArrayWriter pListDataValidationCallback，ISP2DSafeArrayWriter pRestrictInsertCallback，ISP2DSafeArrayWriter pUniqueFieldCallback）
System.Runtime.InteropServices.COMException: Het bestand kwaliteitsdocumenten/(Toekennen autorisaties aan) nieuwe medewerker.docx is gewijzigd door i:0#.w|rf\113150 op 28 mei 2019
09:45:18 +0200.
at Microsoft.SharePoint.Library.SPRequestInternalClass.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean
bPreserveItemUIVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Object& pvarAttachmentNames, Object&
pvarAttachmentContents, Object& pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bUnRestrictedUpdateInProgress, Boolean bMigration, Boolean bPublish, String bstrFileName,
ISP2DSafeArrayWriter pListDataValidationCallback, ISP2DSafeArrayWriter pRestrictInsertCallback, ISP2DSafeArrayWriter pUniqueFieldCallback)
at Microsoft.SharePoint.Library.SPRequest.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean
bPreserveItemUIVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Object& pvarAttachmentNames, Object&
pvarAttachmentContents, Object& pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bUnRestrictedUpdateInProgress, Boolean bMigration, Boolean bPublish, String bstrFileName,
ISP2DSafeArrayWriter pListDataValidationCallback, ISP2DSafeArrayWriter pRestrictInsertCallback, ISP2DSafeArrayWriter pUniqueFieldCallback)
项目的版本历史显示该项目确实被我修改过。
但是，在这种情况下，我尝试编辑项目的文件名，并在de version history它没有声明te文件名有cha nged。另外，查看文档属性，文件名没有改变。
The version history of the item shows that the item is indeed modified by me.
But, in this case, I tried to edit the filename of the item, and in de version history it does not state that te file name has changed. Also, looking at the document properties, the file name has not changed.
这里可能出现什么问题？
What could be the issue here?
提前致谢
推荐答案
您好SharePointGeeky ，
符号"/"不能用于SharePoint中的文件名。
The symbol "/" cannot be used in the file name in SharePoint.
尝试更改文件名而不使用斜杠，然后再次检查。如果您无法编辑文件名，请尝试下载文件并编辑文件名，然后重新上传文件。
Try to change the file name without slash and check again. If you cannot edit the file name, try to download the file and edit file name, then re-upload the file.
此外，这里有一篇基于日志中的错误的类似帖子供您参考：
Besides, here is a similar post based on the error in the log for your reference:
祝你好运。
Grace Wang
Grace Wang
这篇关于错误'文件正被......修改'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
