topic Re: Big Query Connection Error in Connectivity & Data Prep

Big Query Connection Error

binsurancemarketgr — Mon, 11 Jul 2022 08:12:37 GMT

I have encountered some problems when trying to reload data for some apps. The following error is presented:

(Connector error: ERROR [HY000] [Qlik][BigQuery] (310) Storage API Error: request failed: internal error)

When setting a row limit (50,000) the query and connection seems to run just fine. However, for 60,000 or more rows we get the aforementioned error message.

This error seems to have appeared out of nowhere since all the apps loaded until recently with a count of rows above 1,000,000.

Thank you.

Re: Big Query Connection Error

hudam — Thu, 16 Mar 2023 18:12:06 GMT

I am getting a similar error

(Connector error: ERROR [HY000] [Qlik][BigQuery] (310) Storage API Error: Error: { code: INTERNAL, message: RECEIVED RST_STREAM with error code 2 })

did you find any answers?

Re: Big Query Connection Error

Chip_Matejowsky — Mon, 05 Jun 2023 18:59:59 GMT

Have a look at Qlik KB article Data load from Google BigQuery fails with "Google Storage API authentication error"

With applying LIMIT to the load statement the load is successful to certain extent.
For example, reload may be successful with LIMIT 10,000, while it fails with LIMIT 100,000 or higher.

The error message refers to authentication error:

Processing error: ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions.

Best Regards

Re: Big Query Connection Error

Frank_S — Tue, 27 Jun 2023 16:12:48 GMT

Also check this

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Google-BigQuery-Connector-How-to-setup-load-from-Large/ta-p/1937223