Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team
Qlik Web Connectors and Google Analytics "Failed on attempt 1 to GET. (The remote server returned an error: (500) Internal Server Error.)"
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>
Or
<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.