SharePoint List View Threshold Reached

[Casey Hirschmann]

It seems we have reached the maximum amount of items we are allowed to pull over from SharePoint into Spotfire. I'm wondering if there is a work around through hard coding or something to pull the most recent items up until that threshold or to by-pass it completely. We are currently on Spotfire version 10.3.1. Here is the error message returned by Spotfire:

Error message: Could not read the selected data.

AggregateException at :

One or more errors occurred. (HRESULT: 80131500)

Stack Trace:

Aggregated exception:

ImportException at Spotfire.Dxp.Data:

Failed to execute data source query for data source "". (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.d__7.MoveNext()

at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.d__6.MoveNext()

 

ServerException at Microsoft.SharePoint.Client.Runtime:

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. (HRESULT: 80131500)

Stack Trace:

at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream)

at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse()

at COP.Spotfire.SharePointConnector.SharePointDataSourceConnection.CreateConnection()

at COP.Spotfire.SharePointConnector.SharePointDataSourceConnection.ExecuteQueryCore2()

at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

[Khushboo Rabadia]

Hello,

This issue seems external to Spotfire. Try any of these:

https://www.portalfronthosting.com/blog/whats-up-with-sharepoint-list-message-the-attempted-operation-is-prohibited-because-it-exceeds-the-list-view-threshold-enforced-by-the-administrator