Google-related connectors of Qlik Web Connectors (such as Google Analytics Connector, Google BigQuery Connector) authenticates users as follows:
- User clicks "Authenticate", and is redirected to Google Log in page
- User logs in with Google ID and authorize Qlik Web Connectors to access the necessary resources
- Google generates an authorization code
- User copies this authorization code to Qlik Web Connectors, clicks "Save" and run the query
Issue happens in the last step (4): when user clicks "Save"
, the connector hangs for a while then fails with error "An error occurred while trying to authenticate. (status code = 500, The operation has timed out)
Any version of Qlik Web Connectors
Once button "Save"
is clicked, Qlik Web Connectors sends a POST request to https://www.googleapis.com/oauth2/v4/token
to validate the generated authorization code. If this URL is not reachable, the validation attempt times out after a while.
Note that https://www.googleapis.com/
is only for API calls and does not provide a web interface. Therefore, opening the URL in a web browser would return a page not found error. Doing a telnet command to this address would be a more appropriate test.