Sharepoint 业务数据列表行为
这是一个多方面的问题，但感谢任何帮助
背景：
- 我有一个使用 SSO 的应用程序定义，其中包含 6 个实体
- 数据库后端是通过 ODBC 的 Firebird
- 所有数据都来自存储过程
问题：
1 在尝试实现一个或任意一个时在业务数据列表 Web 部件中从 BDC 获取实体时，我收到以下错误：“从 检索数据时发生错误。管理员，请参阅服务器日志以获取更多信息。”仅当我的字段为空时才会发生这种情况，在本例中是声明为字符串的字段。
2.当我检查日志时，这是一个System.OverFlowException。
3.如果我更改它，使过程的输出为空字符串，我突然得到“实体的标题属性设置为无效值”
4.更改为空字符串后日志中的错误为“异常传递” HandleXslException.HandleException System.ArgumentException：'.'，十六进制值 0x00，是无效字符” 什么给？它昨晚工作没有问题，直到出现一个字符串字段之一具有空值的记录。现在，即使用通用值替换空值仍然会给我标题属性无效错误。
最令人费解的是：如果我更改查询，以便查询中不包含空字符串或空白字符串的行，则错误就会消失。但是，如果我将它们添加回来并用任何内容替换空字符串，错误就会再次出现。什么！@#$？在记录返回到 XmlReader 之前，它如何知道我已将空值替换为其他值？
This is a multi faceted question, but any help is appreciated
Background:
- I have a Application Definition with 6 entities using SSO
- The database back end is Firebird through ODBC
- All the data is coming from stored procedures
Questions:
1 While trying to implement one or any of the entities from the BDC in a Business Data List web part I get the following error: "An error occurred while retrieving data from . Administrators, see the server log for more information." It only happens when I have fields that are null, in this instance a field that was declared as a string.
2.When I check the logs, it's a System.OverFlowException.
3.If I change it so the output from the procedure is a blank string, I suddenly get "The title property of entity is set to an invalid value"
4.The error from the logs after changing to a blank string is "Exception handed to HandleXslException.HandleException System.ArgumentException: '.', hexadecimal value 0x00, is an invalid character"
What gives? It worked last night without issue until a record appeared that had a null value in one of the string field. Now, even replacing the null value with something generic is still giving me the title property invalid error.
Most puzzling: If I change the query so that the rows with what would be a null or blank string aren't in the query, the error goes away. But, if I add them back and replace the null string with anything, the error comes back. What the !@#$? How does it know I've replaced a null value with something else before the records are returned to the XmlReader?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我遇到过这种情况，它带回了一些愤怒/困惑的时刻。正如您在评论中所说：
我花了几天时间对着电脑咒骂，然后才把它拆下来并发现了 unicode 问题。我什至不知道什么时候发生了变化，但我们意识到了同样的事情，世界又恢复了正常。
I've run into this exact scenario and it brought back some angry/confused moments. As you said in your comment:
It took me a couple days of swearing at the computer before we took it down to the metal and discovered the unicode issue. I don't even know when it changed but we realized the same thing and all was right with the world again.