Google Analytics İzleme

12 Ocak 2012

Sharepoint - The maximum number of rows that can be read through Database Connector is '2000' uyarısı


Şu şekilde bir uyarı ile karşılaştım:


Error while executing web part: Microsoft.BusinessData.Runtime.ExceededLimitException: Database Connector has throttled the response. The response from database contains more than '2000' rows. The maximum number of rows that can be read through Database Connector is '2000'. The limit can be changed via the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet.  
 at Microsoft.SharePoint.BusinessData.SystemSpecific.Db.ThrottledIDataReader.Read()  
 at Microsoft.SharePoint.BusinessData.SystemSpecific.Db.DbEntityInstanceEnumerator.MoveNext()  
 at Microsoft.SharePoint.BusinessData.Runtime.EntityInstanceEnumeratorBase.MoveNext()  
 at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstancesInternal(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)  
 at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstances(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)  
 at Microsoft.SharePoint.SPListItemCollection.EnsureEntityDataViewAndOrdering(String& bdcidFirstRow, String& bdcidNextPageFirstRow)  
 at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData()  
 at Microsoft.SharePoint.SPListItemCollection.get_Count()  
 at Microsoft.SharePoint.WebControls.SPDataSourceView.ExecuteSelect(DataSourceSelectArguments selectArguments, String aggregateString, Boolean wantReturn, BaseXsltListWebPart webpart, SPListItem& listItem, SPListItemCollection& listItems, String[]& fieldList)  
 at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal()  
 at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator()  
 at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)

Çözümler:
Ben bu limit kontrolünü hepten kaldırdım.
http://sharepointroot.com/2011/02/15/bcs-external-data-unable-to-display-the-web-part/
http://blogs.msdn.com/b/sridhara/archive/2010/03/10/bcs-and-external-list-learning-part1.aspx
http://technet.microsoft.com/en-us/library/ff607630.aspx
http://sharepointyankee.com/2011/01/26/microsoft-businessdata-runtime-exceededlimitexception-database-connector-has-throttled-the-response/


Hiç yorum yok: