Error in connecting to Google Cloud Storage Bucket

[AkashPohare_HB]

Hi All,

I am trying to connect to the Google Cloud Storage bucket from Qlik Sense(OnPrem).  I am using the JSON key file for the service authentication and providing the bucket name. While testing the connection, getting the error  "An error occurred while sending the request." Even the same error logged in the connector logs and not much information.

Anybody has any idea on the error?. Also, with the same JSON service authentication file, connection is successful from other non Qlik applications.

Thanks.

[diegozecchini · Accepted solution]

Hi!
Did you ensure you have provided the correct bucket name, JSON key file, and region? I suggest double-check that no typos exist in the configurations.

Qlik Sense On-Prem requires internet access to connect to Google Cloud Storage. Did you verify the server hosting Qlik Sense can reach Google Cloud's endpoints?
Check if a proxy or firewall is blocking outbound connections to Google Cloud Storage (https://storage.googleapis.com)

Since the error logged is generic, it could be a good idea to enable detailed logging for Qlik's connectors to gather more insights. Then look for log files specific to the Google Cloud Storage connector. These are usually located in the Qlik installation directory under C:\ProgramData\Qlik\Custom Data\....

Let me know if you need further analysis
Kind regards,
Diego

[vlasov]

Hi,

@diegozecchini provided a great answer. 

Please consider as well checking of Bucket IP filtering ( https://cloud.google.com/storage/docs/ip-filtering-overview ) for Qlik Sense runtime hosts/subnet.

Kind regards,

Sergey

[AkashPohare_HB]

Hello @diegozecchini ,

Thanks for the response. I confirm that the bucket name and key files are correct only. I can still connect to the bucket from the Qlik Sense desktop client and no issues. And issue is only when connecting from the Qlik Sense OnPrem HUB.

I can confirm that connection is not blocked on the firewall and open as inbound and outbound ports are open to ANY.

I have checked the connector logs by setting it to most granular level, however no much information is there, I could see message "Message=FileBasedSerialisationService does not contain value for key=keyvalue." along with the message An error occurred while sending the request."

[AkashPohare_HB]

Thanks @vlasov  for the help page. Will review it.

[AkashPohare_HB · Accepted solution]

Hi All,

I was able to fix the issue. Our servers are not connected to the internet and hence request was not reaching to GCP. To fix this, we need to use the proxy to reach to GCP.

Good thing is that proxy can be set for Qlik connectors only instead of allowing access to whole server.

The connector proxy settings can be found in the file deploy.config under the folder  C:\Program Files\Common Files\Qlik\Custom Data\QvWebStorageProviderConnectorPackage

Open the file and locate the below lines

<Proxy>
    <UseProxy>false</UseProxy>
    <ProxyAddress></ProxyAddress>
    <ProxyUsername></ProxyUsername>
    <ProxyDomain></ProxyDomain>
    <ProxyPassword encrypted="false"></ProxyPassword>
  </Proxy>

Update first 2 lines as shown below. Use the google API proxy setup in your environment for GCP and port. Keep other details as it is.

<Proxy>
    <UseProxy>true</UseProxy>
    <ProxyAddress>yourgoogleapiproxyaddress:portused</ProxyAddress>
    <ProxyUsername></ProxyUsername>
    <ProxyDomain></ProxyDomain>
    <ProxyPassword encrypted="false"></ProxyPassword>
  </Proxy>

[diegozecchini]

thanks for sharing 💪