topic Re: Internal server error with Google Analytics in Connectivity & Data Prep

Internal server error with Google Analytics

mstoler — Thu, 28 Jan 2021 15:32:01 GMT

Hello,

I am using the Qlik Web Connectors to access Google Analytics.

On a schedule reload every few days I get the error:

Error: Internal Server Error

If I run it again it usually works.

Does anyone else have this problem>

Thanks,

Michael

Re: Internal server error with Google Analytics

nishika — Fri, 29 Oct 2021 09:53:02 GMT

Hi micheal,

Have you found the solution ?

Re: Internal server error with Google Analytics

Sooraj_Suresh — Mon, 01 Nov 2021 07:42:02 GMT

@mstoler

What version of QlikSense and Qlik Web connector are you using?

Do you use Standard/Legacy mode script?

Do you have any SSL cert inmplemeted for webconnectors?

Did you check if the hostname where the webconnector is installed is given correctly in the script like try with hostname/FQDN.

Best Regards

Sooraj Suresh

Re: Internal server error with Google Analytics

mstoler — Mon, 01 Nov 2021 09:18:38 GMT

What version of QlikSense and Qlik Web connector are you using?

Nov 2020

Do you use Standard/Legacy mode script?

Standard

Do you have any SSL cert inmplemeted for webconnectors?

Did you check if the hostname where the webconnector is installed is given correctly in the script like try with hostname/FQDN.

We can try that

Also this error occurs very randomly. We run the connectors every day and it may occur a few times a month.

I think we can maybe add error correcting in the scripts.

Michael

Re: Internal server error with Google Analytics

chrisbrain — Tue, 02 Nov 2021 09:07:37 GMT

Hi - Could you check to see if there is any more detail in the log files for Qlik Web Connectors?

Re: Internal server error with Google Analytics

markus_myllymaki — Mon, 25 Apr 2022 08:29:48 GMT

Did you manage to find any solution for this "Internal Server Error" issue which occurs every once and a while?

I've lately struggled with same issue. It didn't happen before.

It may have something to do with parallel or semi-parallel active web connects. We are reading Google Sheets and same Sheet may be used both in Test environment and Prod environment. They are totally separate servers but Google Drive Account is the same.

Re: Internal server error with Google Analytics

mstoler — Mon, 25 Apr 2022 10:37:39 GMT

Hello,

No, I have not found a solution other than just running it again and most times it works.

Michael

Re: Internal server error with Google Analytics

Anil_Babu_Samineni — Thu, 28 Apr 2022 04:31:57 GMT

Important: Have you raised qlik support case?

Re: Internal server error with Google Analytics

mstoler — Thu, 28 Apr 2022 10:29:39 GMT

Hello,

No.

I will after I upgrade to the current version.

Michael

Re: Internal server error with Google Analytics

markus_myllymaki — Sat, 30 Apr 2022 06:59:49 GMT

I raised a support ticket this week and root cause was found: Too many API calls per minute. 60 is a limit. Error message in Web connector log was something like this:

{ "error": { "code": 429, "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number: <Number>'.", "status": "RESOURCE_EXHAUSTED", "details": [ { "@type": "type.googleapis.com/google.rpc.ErrorInfo", "reason": "RATE_LIMIT_EXCEEDED", "domain": "googleapis.com", "metadata": { "consumer": "projects/ <Number>", "quota_metric": "sheets.googleapis.com/read_requests", "service": "sheets.googleapis.com", "quota_limit": "ReadRequestsPerMinutePerProject" } } ] } }

Support adviced me to try the workaround below (Enabling multiple users for Qlik Web Connectors):

https://community.qlik.com/t5/Knowledge/How-to-enable-multiple-users-for-Qlik-Web-Connectors/ta-p/1907070

We were however in quite a hurry and tried different approach first. We collected all Web Connector read clauses into one qvd generator app (.qvf) and added some sleep() commands there. Let's see if that works. So far so good.

Re: Internal server error with Google Analytics

mstoler — Sun, 01 May 2022 17:13:08 GMT

Hello,

That makes sense. Please let me know how sleep() works.

Michael