Forum Discussion

MadMaxidrom's avatar
MadMaxidrom
Copper Contributor
May 13, 2021

You cannot load dependent objects for more than 1000 resources. Use a filter to restrict your query.

Hi, I have on-premise SharePoint 2019 and MS Sql Server 2019. 
I use CSOM to set actual work for resources.

 

public TimePhase getResourceTimePhaseAssignments(EnterpriseResource resource, DateTime startDate, DateTime finishDate)
{
TimePhase currentTimePhase = resource.Assignments.GetTimePhase(startDate, finishDate);
projContext.Load(currentTimePhase.Assignments);
projContext.ExecuteQuery();
return currentTimePhase;
}

 

Running this code I get exception: Too many resources: 1073. You cannot load dependent objects for more than 1000 resources. Use a filter to restrict your query.

I found several unanswered threads related to this issue:

1)

https://social.microsoft.com/Forums/en-US/b0375b33-808d-439d-bb49-20ca0a02c695/you-cannot-load-dependent-objects-for-more-than-1000-resources-use-a-filter-to-restrict-your-query?forum=projectonline

2)

https://social.technet.microsoft.com/Forums/azure/en-US/4fab5f62-5955-4257-af0f-a5e1fa58dca7/error-reading-project-custom-fields-via-csom-too-many-projects?forum=projectonline

 

I didn't find any decision for my case. 

Is there an ability to change limit of 1000 resources somewhere on the server side?

Am I able to filter my request somehow?

Any help would be appreciated.

No RepliesBe the first to reply

Resources