无法更新此外部实体的列表项 [英] Failed to update list item for this external Entity
问题描述
只需在SharePoint 2013上使用SharePoint Designer为BCS创建一个外部列表.阅读列表和阅读项目正常工作.
Just created a External List to BCS using SharePoint Designer on SharePoint 2013. The read list and read item working fine.
更新项目时，对不起失败，出了点问题
When updating an item, it fails with Sorry, Something is wrong
无法为实体(外部内容类型)存储"上的该外部列表更新列表项.在EntirtyNamespace中.针对数据库的查询基于错误.
Failed to update a list item for this external list on the Entity (External Content Type) "Store" in the EntirtyNamespace. The query against the database base an error.
事件日志显示失败的SQL语句. 正在更新的表是[dbo].[tblUser]
The event log is showing the SQL statement that is failing. The table that is getting update is [dbo].[tblUser]
我发现奇怪的是最后的声明.
What I see that is strange is this statement at the end.
"完整的异常文本为:无效的对象名称DBNAME_TRANS.dbo.tblUser"
"The full exception text is : Invalid object name DBNAME_TRANS.dbo.tblUser"
该数据库称为"DBNAME".但该异常指向"DBNAME_TRANS". 更新实际数据库时，BCS是否具有中间数据库.
The database is called "DBNAME" yet the exception points to "DBNAME_TRANS". Does BCS have an intermediate database when updating the actual datbase.
Michael Wharton，MVP，MBA，PMP，MCT，MCTS，MCSD，MCSE + I，MCDBA
网站http://www.WhartonComputer.com
博客http://MyProjectExpert.com包含我的领域注释和SQL查询
Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
Website http://www.WhartonComputer.com
Blog http://MyProjectExpert.com contains my field notes and SQL queries
推荐答案
Michael，
Hi Michael,
从错误消息无法更新列表项……基于错误"中，可能数据库表具有外键引用的唯一键约束，并且用户输入包含不满足这些约束的值.确保用户输入 列中正确的文本类型.
From the error message "Failed to update a list item ……base an error", It might that database table has unique key constraints of foreign key references and the user input contains a value that does not fulfill these constraints. Make sure the user input the correct type of text in the columns.
此外，请查看ULS日志以找到有关此问题的更详细的错误消息，ULS位于:
Besides, check the ULS log to find more detailed error message about this issue, ULS is at:
C:\ Program Files \ Common Files \ Microsoft共享\ Web服务器扩展\ 15 \ LOGS
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\LOGS
以下是一些类似的帖子供您参考:
Here are some similar post for your reference:
https://sharepoint .stackexchange.com/questions/24728/external-list-error-the-query-against-the-database-caused-an-error
最诚挚的问候，
Grace Wang
Grace Wang
这篇关于无法更新此外部实体的列表项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
