Office API 1.1 getTaskByIndexAsync gets lost if more than 10(ish) Project Tasks about office-js

[indieonly]

The following Exception appears to be thrown consistently after the first 51 "Agave.HostCall.IssueCall" lines in the VisualStudio output box (which equates to supporting a maximum of 10 Tasks if you first get the GUID by Index, then get 4 fields per GUID as in my tests):

Exception was thrown at line 2953, column 13 in https://localhost:44378/Scripts/Office/1/project-win32-16.00.debug.js
0x80043200 - JavaScript runtime error: unknown exception

[keyur32]

Following up with our Project team on this issue. thanks

[kriede]

We are having the same issue with getTaskByIndexAsync: After 50 Tasks we get 5001 Internal Error on subsequent calls. Any news on this issue?

[indieonly]

Hi Kriede,
am not sure you will be getting a response any time soon.

You can Code around this obvious limitation by ensuring no more than 40-45 Async calls are made in parallel using JQuery $.Deferred (see tested Code example below). Having said that, my testing revealed a SHARP drop in performance as I got towards 40-45 parallel Async calls (tested by MS?), with around 5 parallel Async calls strangely performing much faster (in which case $.Deferred may not even be strictly necessary, but is more robust). So, keep your packets small for readability and strangely, better performance.

Best,
Cameron

function getTaskOtherFieldsThenNext(taskIndex, maxTaskIndex, deferAllTasks) {

// Create a Defer Object for the current Task to be read and stored against a JSON Object
var deferTask1 = $.Deferred();

// Is current Task a Leaf (or the Project Task) ?    
if (tasksArray[taskIndex].taskIsLeaf == true || taskIndex == 0) {      
    getTaskJSONOtherFields(tasksArray[taskIndex], deferTask1);

} else {
    // Only need ******* for Leaves and Parent Task, so Resolve promise immediately for other tasks to continue
    deferTask1.resolve();
}
        
// Processing to be performed once Task Promise has been resolved
$.when( deferTask1 ).done( function () {
    // getTaskJSONKeyFields has finished its work for current Task. Go to next Tasks or finish
    if (taskIndex >= maxTaskIndex) {
        // If we have treated the last task, then 'All Tasks' Promise has been fulfilled
        return deferAllTasks.resolve();

    } else {
        // Kick off read for next Task (n + 1)
        taskIndex++;
        getTaskOtherFieldsThenNext(taskIndex, maxTaskIndex, deferAllTasks);
    }
});

}

[kbrandl]

Apologies for the lack of response on this. I'm transferring this issue to the OfficeDev/office-js repo, which members of the product team monitor for customer-reported issues like this.

[JuaneloJuanelo]

Update: the team owning this issue is currently investigating

[LunchWithaLens]

If anyone on this thread has a complete sample they reproduce the problem with I'd like to get this one resolved. I appear to be able to read task details in 100 tasks with no issues, but I want to be sure I am not missing anything.
Thanks, and sorry for the huge delay in addressing this.
Brian Smith

[dmahugh]

Closing this issue due to inactivity, but if anyone has new information or a sample as @LunchWithaLens requested, let us know and we'll re-open it.

[puentesdiaz]

Hi iam try use
Office.context.document.getTaskByIndexAsync(3, function (resultTask) { if (resultTask.status === Office.AsyncResultStatus.Succeeded) { this.setState({ idDocuMongo: resultTask.value + "_ GUID _" + parseInt(Math.random() * 100) }); } else { matrizTask.push("resultTask.error"); } } );

but i don't get anything