Receiving error with Office Graph querying a site collection with large number of document libraries

%3CLINGO-SUB%20id%3D%22lingo-sub-266151%22%20slang%3D%22en-US%22%3EReceiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266151%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20test%20site%20collection%20with%202500%20document%20libraries%20(I%20created%20them%20using%20PnP).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%26nbsp%3Btried%20returning%20a%20list%20of%20them%20via%20Office%20Graph%20Explorer%20but%20I%20get%20an%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGET%3A%26nbsp%3B%3CA%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fsites%2F%3CTENANT%3E.sharepoint.com%2C%3CSITE_ID%3E%2FLists%3F%24top%3D10%3C%2FSITE_ID%3E%3C%2FTENANT%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EFailure%20-%20Status%20Code%20504%2C%26nbsp%3B%3CSPAN%20class%3D%22%22%3E20312ms%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CBR%20%2F%3E%7B%3CBR%20%2F%3E%22error%22%3A%20%7B%3CBR%20%2F%3E%22code%22%3A%20%22UnknownError%22%2C%3CBR%20%2F%3E%22message%22%3A%20%22%22%2C%3CBR%20%2F%3E%22innerError%22%3A%20%7B%3CBR%20%2F%3E%22request-id%22%3A%20%22c1752b49-6dc1-4a18-a3db-d29e4107aca4%22%2C%3CBR%20%2F%3E%22date%22%3A%20%222018-10-02T21%3A16%3A09%22%3CBR%20%2F%3E%7D%3CBR%20%2F%3E%7D%3CBR%20%2F%3E%7D%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20above%20GET%20works%20on%20site%20collection%20with%20a%20smaller%20number%20of%20document%20libraries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-266151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268490%22%20slang%3D%22en-US%22%3ERe%3A%20Receiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268490%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F152388%22%20target%3D%22_blank%22%3E%40Jeremy%20Thake%3C%2FA%3E%26nbsp%3Bfor%20getting%20back%20to%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268286%22%20slang%3D%22en-US%22%3ERe%3A%20Receiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268286%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20has%20been%20investigated%20and%20the%20team%20have%20confirmed%20its%20an%20issue.%20They%20are%20currently%20looking%20at%20how%20the%20fix%20this.%20I'll%20update%20this%20thread%20once%20its%20resolved.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266730%22%20slang%3D%22en-US%22%3ERe%3A%20Receiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266730%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F152388%22%20target%3D%22_blank%22%3E%40Jeremy%20Thake%3C%2FA%3E%26nbsp%3B-%20this%20is%20one%20I've%20just%20received%20via%20the%20Graph%20Explorer%20-%26nbsp%3BI%20can%20give%20you%20external%20access%20to%20the%20site%20collection%20as%20it's%20just%20a%20test%20site%20collection%20with%20just%202500%20document%20libraries.%20No%20data.%3CBR%20%2F%3E%3CBR%20%2F%3E%7B%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%22error%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%22code%22%3A%20%22UnknownError%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%22message%22%3A%20%22%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%22innerError%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%22request-id%22%3A%20%2237e90bc0-e12c-488d-be2e-88471fa41559%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%22date%22%3A%20%222018-10-04T07%3A59%3A18%22%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%7D%3CBR%20%2F%3E%26nbsp%3B%7D%3CBR%20%2F%3E%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266617%22%20slang%3D%22en-US%22%3ERe%3A%20Receiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266617%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20you%20provide%20the%20request%20id%20that%20you%20got%20in%20the%20response%20there.%20I%20can%20run%20a%20background%20trace%20from%20my%20side%20to%20see%20execution%20paths.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266216%22%20slang%3D%22en-US%22%3ERe%3A%20Receiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266216%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20to%20add%20I%20the%20query%20works%20fine%20on%20an%20out-of-box%20just%20created%20site%20and%20returns%20all%20the%20lists%20ok.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266205%22%20slang%3D%22en-US%22%3ERe%3A%20Receiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F152388%22%20target%3D%22_blank%22%3E%40Jeremy%20Thake%3C%2FA%3E%20do%20you%20know%20what%20is%20happening%20here%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266161%22%20slang%3D%22en-US%22%3ERe%3A%20Receiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266161%22%20slang%3D%22en-US%22%3E%3CP%3Eyes%2C%20it%20was%20in%20Office%20Explorer%20I%20received%20this%20message.%20I%20normally%20use%20the%20explorer%20first%20before%20diving%20into%20code.%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F55356i7C409F835596A764%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22office-graph.png%22%20title%3D%22office-graph.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266152%22%20slang%3D%22en-US%22%3ERe%3A%20Receiving%20error%20with%20Office%20Graph%20querying%20a%20site%20collection%20with%20large%20number%20of%20document%20libra%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266152%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20test%20this%20query%20using%20the%20graph%20explorer%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%2Fgraph-explorer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%2Fgraph-explorer%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a test site collection with 2500 document libraries (I created them using PnP). 

 

I just tried returning a list of them via Office Graph Explorer but I get an error.

 

GET: https://graph.microsoft.com/v1.0/sites/<tenant>.sharepoint.com,<site_id>/Lists?$top=10

 

Failure - Status Code 504, 20312ms


{
"error": {
"code": "UnknownError",
"message": "",
"innerError": {
"request-id": "c1752b49-6dc1-4a18-a3db-d29e4107aca4",
"date": "2018-10-02T21:16:09"
}
}
}

 

The above GET works on site collection with a smaller number of document libraries.

 

Thanks for your help in advance.

 

 

8 Replies
Highlighted
Highlighted

yes, it was in Office Explorer I received this message. I normally use the explorer first before diving into code. thanks

 

office-graph.png

Highlighted
Highlighted

Just to add I the query works fine on an out-of-box just created site and returns all the lists ok.

Highlighted

Could you provide the request id that you got in the response there. I can run a background trace from my side to see execution paths.

Highlighted

 

Thanks @Jeremy Thake - this is one I've just received via the Graph Explorer - I can give you external access to the site collection as it's just a test site collection with just 2500 document libraries. No data.

{
   "error": {
    "code": "UnknownError",
     "message": "",
    "innerError": {
     "request-id": "37e90bc0-e12c-488d-be2e-88471fa41559",
     "date": "2018-10-04T07:59:18"
   }
 }
}

 

Highlighted

This has been investigated and the team have confirmed its an issue. They are currently looking at how the fix this. I'll update this thread once its resolved.

Highlighted