How Do I Resolve Network Errors?

There are a variety of network problems that can occur when the Excel add-in attempts to communicate with the target REST service. Some examples include:

• 502 Bad Gateway (possibly an issue with the local proxy settings)
• The operation failed due to a problem connecting to the server. Contact the system administrator. (VBAFE-00100)
• 504 Gateway Timeout

For most network errors, save a network monitor report and share it with your network administrator.

504 Gateway Timeout

Gateway timeouts may occur when the REST server takes too long to start sending the response. Gateway servers may include load balancers like Akamai and may be configured to terminate connections that are idle for too long. A timeout may indicate a performance issue with the REST service.

On the desktop, you'll see a gateway timeout error. On the REST server, there might be something similar to a broken connection error. You may not find the timeout errors in the app server logs.

To resolve a Gateway timeout issue:

1. Use the Network Monitor to determine the specific URL and operation.
2. Save the network monitor report.
3. Share the reports with the team that provides the service to determine why the service took too long to respond.

   Note:

   A frequent root cause is a missing index resulting in a very long search time.