topic Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown in Management & Governance

Connector error: Exception of type 'System.OutOfMemoryException' was thrown

Notwo — Sat, 16 Nov 2024 18:19:18 GMT

Hi,

we have been running Qlik Sense Cloud now for a few weeks with reload of the App every 6 hrs without any issues.

Since yesterday though every other reload fails with the error message "Connector error: Exception of type 'System.OutOfMemoryException' was thrown". There are multiple REST connections in the app to different platforms and the error pops up for different ones. It's not like it is the same connection failing every time.

Want to point out that we are using the SaaS solution on the Qlik managed server, no private server. And the App in question is on a shared space.

Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown

Jamie_Gregory — Tue, 04 Aug 2020 18:42:01 GMT

@Notwo Are you still seeing this error message?

Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown

Notwo — Wed, 05 Aug 2020 06:52:34 GMT

@Jamie_GregoryI have had it back when I wrote this post for 2 days straight but not since then. Very unclear what the root cause for the reload issues was.

Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown

ggijben — Thu, 08 Oct 2020 13:23:52 GMT

I'm experiencing the same issue. The reload has worked fine for 2 months, but since a couple of days it fails 50% of the time with this error.

Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown

Jamie_Gregory — Thu, 08 Oct 2020 18:06:42 GMT

@ggijben can you confirm how much data is being retrieved?

Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown

limacheck — Fri, 04 Dec 2020 13:05:43 GMT

I'm getting same problem. I'm retrieving no more than 3k records but the error occurs with different apis. It doesn't occurs always the same.

Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown

PavelKastner — Tue, 05 Jan 2021 08:40:02 GMT

Same problem here using QSB

Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown

spectrumjpowley — Tue, 12 Jan 2021 20:32:18 GMT

I have the same problem as well with QSB. Appeared to be working okay, now I can't reload the application.

I get the same experience to everyone else, same error but on different APIs/tables when using the REST Connector.

Re: Connector error: Exception of type 'System.OutOfMemoryException' was thrown

spectrumjpowley — Tue, 12 Jan 2021 21:04:40 GMT

I'm not sure if this will work for anyone else, but as a last resort I added some uses of the "sleep" function between my API calls in the Data Load Script. This fortunately appears to have got rid of the OutOfMemory exception.

It's by no means a perfect solution as the total reload time has increased quite a bit, but at least I can reload my app!

Between datasets I added a 20 second delay:

Sleep 20000;

And for looping through pages of data I have added a 2 second delay.

I hope this helps someone out!