topic Re: QlikView client run out of memory in QlikView

QlikView client run out of memory

Wed, 13 Oct 2010 10:10:37 GMT

Hi friends,

I have QlikView project and if start "Reload" function for restore data from data source (local MySQL database) it reached following error:

SQL Error:[MySQL][ODBC 5.1 Driver][mysqld-5.0.67-community-nt]MySQL client ran out of memory
SQL Scriptline:
SQL State:S1000
VydajTovaruNaPredajniPodlaPartnera:
SQL SELECT CisloPredajne,
CisloKarty,
NC,PC,KS
CisloPartneraMO,
DatumDokladu
FROM milkagro.vydaj

This table has 467MB of data. I have similar MySQL table TAB2 with the same structure but only 40MB of data and that QV reloaded in order.

What tip for running reload for that huge amount of data?

QlikView client run out of memory

Thu, 03 Feb 2011 17:30:19 GMT

hello,

I have the same error, can you please tell me how you have resolve this probleme?

QlikView client run out of memory

Anonymous — Thu, 03 Feb 2011 18:58:35 GMT

I am assuming that your server has bigger capacity than your developer PC and that it has memory large enough to handle your data. If that is the case, go to debugger, run a limited load of say 10 rows, save the local file & then copy this qvw to your server & then reload in server.

Dinesh.

Re: QlikView client run out of memory

Emmanuelle__Bustos — Wed, 03 Apr 2013 16:55:29 GMT

Same Problem here with a Mysql server we have a 32GB machine but not even 20GB are consumed when the error appears:

SQL Error:[MySQL][ODBC 5.1 Driver][mysqld-5.0.67-community-nt]MySQL client ran out of memory

and it always is reproduced with the same table od the DB.

Anyone has a solution for this?

Re: QlikView client run out of memory

Mon, 13 May 2013 11:57:28 GMT

Hi,

I had the same issue on my dev machine. I am no QV expert nor poweruser but to me it seems it is actually an ODBC error, not related to QV.

What worked for me was to go to the ODBC details screen,

1. open ODBC data source admin

2. click configure on the datasource you use

3. click details

4. go to tab 'connection' and check "allow big result sets"

5. go to tab 'cursor/results' and check 'don't cache results'

This allowed me to get past the out-of-memory error...

Re: QlikView client run out of memory

johnnyirl — Thu, 22 Sep 2022 19:29:25 GMT

This worked for me. Thanks.