Qlik Web Connectors and Google Analytics "Failed on attempt 1 to GET. (The remote server returned an error: (500) Internal Server Error.)"

Francisco_Fernandez — Wed, 20 Jan 2021 11:43:15 GMT

When reloading an app using the Google Analytics either in Qlik Sense or Qlik view it's possible that it fails with one of the following errors in the Web Connectors logs:

<ExceptionMessage>Failed on attempt 1 to GET. (The remote server returned an error: (503) Server Unavailable.)</ExceptionMessage>

<ExceptionMessage>Failed on attempt 1 to GET. (The remote server returned an error: (500) Internal Server Error.)</ExceptionMessage>

Environment

Qlik web connectors any version

Resolution

R&D is currently investigating how to reduce these errors, but since the error might be triggered due to heavy load in Google's endpoint re-scheduling the tasks might help to solve the issue.

Other potential workarounds would be to place a sleep between API requests or optimize/reduce the amount of data requested

Cause

Quoting google's documentation:

A 500 or 503 error might result during heavy load or for larger more complex requests. For larger requests consider requesting data for a shorter time period.

article Qlik Web Connectors and Google Analytics "Failed on attempt 1 to GET. (The remote server returned an error: (500) Internal Server Error.)" in Official Support Articles

Qlik Web Connectors and Google Analytics "Failed on attempt 1 to GET. (The remote server returned an error: (500) Internal Server Error.)"

Environment

Resolution

Cause

Related Content