由于数据限制，加载操作失败查询 [英] Load operation failed for query due to data limit

问题描述

我们有一个silverlight应用程序与RIA服务接口以获取在网格中显示的联系人列表，但通常情况下，我们会收到以下错误：

We have a silverlight application which interfaces with an RIA service to get a list of contacts to display in a grid, this normally works however we are getting the following error:

load operation failed for query x. the remote server returned an error: notfound

跟踪这一点，我们确定是由于如果我们通过大约3,800个记录或更少的数据，那么正在传递的数据将会工作。我们需要从数据库中加载至少15,000条记录。

Tracing this through we have determined it is due to the amount of data that is being passed as it will work if the we pass roughly 3,800 records or less. We need to load at least 15,000 records from the database.

我已经通过互联网搜索找到解决方案，并更改了以下设置，但似乎没有任何工作

I have searched all over the internet to find a solution and have changed the following settings but nothing seems to have worked.

更改的设置是：

• 在IIS7中更改了ASP设置响应缓冲限制到67108864


• 在IIS7中，将ASP设置最大请求实体限制更改为2000000


• 在IIS7中，将ASP设置'Client连接测试间隔'至00:00:10


• 在我们的应用程序中，web.config将maxItemsInObjectGraph更改为2147483647


• 在我们的应用程序中web.config绑定属性'maxReceivedMessageSize'，'maxBufferSize'和'maxBufferPoolSize'都设置为200000000


• 在我们的应用程序中web.config readerQuotas属性'maxArrayLength'，'maxStringContentLength'，'maxBytesPerRead' maxNameTableCharCount'都设置为200000 000

• In IIS7 changed the ASP setting 'Response Buffering Limit' to 67108864
• In IIS7 changed the ASP setting 'Maximum Requesting Entity Body Limit' to 2000000
• In IIS7 changed the ASP setting 'Client Connection Test Interval' to 00:00:10
• In our application web.config changed 'maxItemsInObjectGraph' to 2147483647
• In our application web.config binding attributes 'maxReceivedMessageSize', 'maxBufferSize' and 'maxBufferPoolSize' are all set to 200000000
• In our application web.config readerQuotas attributes 'maxArrayLength', 'maxStringContentLength', 'maxBytesPerRead', 'maxNameTableCharCount' are all set to 200000000

这是在Server 2008 R2上安装IIS7并使用.Net 4。

This is setup on Server 2008 R2 with IIS7 and using .Net 4.

使用ASP.NET开发服务器在调试器中运行时也会出现此错误。

This error also occurs when running in the debugger using the ASP.NET Development Server.

任何帮助将不胜感激。

推荐答案

也许您的项目数量太少，您的Web.config中，您还可以启用此类故障中的详细信息，以获取更多详细信息，如果这不是修正。

Maybe your number of items is too limited in your Web.config, you can also enable detail in your faults like this to get more detail if this isn't the fix.

<services>
  <service name="Service.Class.Full.Name"
           behaviorConfiguration="Service_Behaviour_Name" />
</services>
<behaviors>
  <serviceBehaviors>
    <behavior name="Service_Behaviour_Name">
      <serviceMetadata httpGetEnabled="true" />
      <serviceDebug includeExceptionDetailInFaults="true" />
      <dataContractSerializer maxItemsInObjectGraph="65536" />
    </behavior>
 </behaviors>

Service.Class.Full.Name 需求成为您完全合格的服务类名称。
Service_Behaviour_Name 可以是任何东西，但默认看起来像服务类名称为 - 而不是。

Service.Class.Full.Name needs to be you fully qualified service class name. Service_Behaviour_Name can be anything, but the default looks like the full service class name with - rather than .

这篇关于由于数据限制，加载操作失败查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！