topic Re: Qlik WebConnectors suddenly stopped working - Google Docs in Connectivity & Data Prep

Qlik WebConnectors suddenly stopped working - Google Docs

prees959 — Mon, 13 Dec 2021 21:57:31 GMT

Hi, around 2 days ago we started getting connection errors when using QlikConnectors to query Google Docs. No settings were changed on our side. We have tried upgrading to the latest version and the same problem persists..

Looking at the error log we have the following which shows the IP address failing to respond

WebExcp System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 216.58.204.78:443 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetResponse() at APIConnectorEngine.Qwc.HttpHelper.MakeRequest(eHTTPMethod method, String url, Object postData, Object state, Int32 attempt) at APIConnectorEngine.Qwc.HttpHelper.MakeRequestWithRetries(eHTTPMethod method, String url, Object postData, Object state, HttpCallConfig callConfig)

Does anyone have any advice on rectifying this ?

Many thanks, Phil

Re: Qlik WebConnectors suddenly stopped working - Google Docs

stevedark — Tue, 05 Jan 2021 15:21:21 GMT

Hi @prees959

I don't use GoogleDocs through QWC, but do use other Google connectors. Downloading from Calendar is working here at the moment.

Can you create any other QWC connections, or do you get similar errors for those?

That IP address is definitely Google. Are you sure that there haven't been any firewall or DNS changes elsewhere in the org that could be blocking this?

Steve

Re: Qlik WebConnectors suddenly stopped working - Google Docs

chrisbrain — Tue, 05 Jan 2021 15:39:16 GMT

@prees959 - I agree with comments and questions from @stevedark

If this was working before and you didn't change anything it seems quite unlikely it's to do with the connectors.

Could you confirm if this is happening only for certain tables in the connector and if so which work and which don't?

Do you have a proxy configured in QWC?

Maybe you could look at any OS updates which went on around the time it started failing (I am thinking mainly of .NET Framework updates) although I would not expect this to cause any issues.