Forum Discussion
ashamrai
Jun 27, 2021Copper Contributor
Project CSOM can not add a new task request if the enterprise resource pool contains more than 1000
I use the following code to add a new task request through CSOM on Project Server 2019:
var resources = projectContext.LoadQuery(projectContext.EnterpriseResources.Where(n => n.Name == username));
projectContext.ExecuteQuery();
var resource = resources.ElementAtOrDefault(0);
StatusAssignmentCreationInformation creationInformation = new StatusAssignmentCreationInformation();
creationInformation.ProjectId = projectGuid;
creationInformation.Comment = "new task";
creationInformation.Task = new StatusTaskCreationInformation() { Name = "New Task" };
creationInformation.Task.Start = DateTime.Now;
creationInformation.Task.Finish = DateTime.Now.AddDays(7);
resource.Assignments.Add(creationInformation);
resource.Assignments.Update();
resource.Assignments.SubmitAllStatusUpdates("new task");
projectContext.ExecuteQuery();
It works if a project server contains < 1000 enterprise resources. In another case, it generates the following error on the last projectContext.ExecuteQuery() step:
Too many resources: 1132. You cannot load dependent objects for more than 1000 resources. Use a filter to restrict your query.
However, the code does not contain any query of 1132 resources (only 1 resource on the first line).
How can I resolve this issue?
No RepliesBe the first to reply