63626 GraphQL hostUsers query times out at 30 seconds (HC0045)
When logging into Managely Host and navigating to the users page, we were getting a timeout error in production. The GraphQL query getHostUsers (resolver path: host.user.hostUsers) consistently failed with a 30-second timeout. The GraphQL server returned error code HC0045 indicating the request exceeded the configured timeout of 00:00:30. This prevented the Host Users list from loading (or any workflow depending on this query). The issue appeared related to backend resolver execution time and/or underlying DB query performance.
We addressed an issue where useSSO was not a mapped property used and used as part of the query. This caused a much larger call to be done by EF. We updated this property to check against the serviceID having a value so as not to use the not-mapped property. This speeds up the call back under 200 MS rather then 5 seconds on dev.