Solved: Allocated memory exceeded across a network but on ... - Qlik Community

tinkerz1 · ‎2016-02-10

Hi,

I am asking another user to open up a QVW across a network and he having an error on a table.

"Allocated memory exceeded."

He is also in the Phillipines where I am in UK.

Are there any settings I should look for that are country related?

His specs are:

========================= Document Info ==========================

Document \\Ukhibmdata07\#ukhibmdata07\limitmon\MRMaC Internal Control-SOX-OR\AUDIT MSII LIVE ISSUES\QlikView\End User Testing\MSII and Action Plan\MSII and No Action Plan Dashboard Test V1.qvw

Connection Local

DecimalSep Doc="."(2E) Sys="."(2E)

ThousandSep Doc=","(2C) Sys=","(2C)

ListSep Doc=","(2C) Sys=","(2C)

MoneyDecimalSep Doc="."(2E) Sys="."(2E)

MoneyThousandSep Doc=","(2C) Sys=","(2C)

MoneyFmt Doc="£#,##0.00;-£#,##0.00" Sys="£#,##0.00;-£#,##0.00"

TimeFmt Doc="hh:mm:ss" Sys="hh:mm:ss TT"

DateFmt Doc="DD/MM/YYYY" Sys="DD/MM/YYYY"

TimestampFmt Doc="DD/MM/YYYY hh:mm:ss[.fff]" Sys="DD/MM/YYYY hh:mm:ss[.fff] TT"

Document File Format 6000 (6000)

Saved in Version 11.20.12018.0409

Client NT Name

Access ADMIN

License -

Document License Status ALLOWED

======================= Object Cache Info ========================

Object Cache Limit (MB) 392.03

========================= QlikView Info ==========================

Client Build Number 11.20.12018.0409

Server Build Number -

QlikTech Product QlikView 64-bit Edition (x64)

License Key [Personal Edition]

PE Recoveries Remaining 1

CPU Target x64

=========================== INI Values ===========================

CanDynamicUpdate 1

InstalledLIBID110 {15B258E8-415E-11D1-934D-0040333C91CC}

InterfaceLanguage English

LastViewedStartPageFeatureId 1004

MarginTop 20

Utf8FileDlgPathOpenDoc Y:\MRMaC Internal Control-SOX-OR\AUDIT MSII LIVE ISSUES\QlikView\MSIIs and No Action Plan\

======================= Local System Info ========================

Operating System Windows 7 Enterprise Service Pack 1 (64 bit edition)

Operating System Version 6.1.7601

Wow64 mode Not using Wow64

IE Version 9.11.9600.18097

MDAC Version 6.1.7601.17514

MDAC Full Install Version 6.1.7601.17514

ComCtl32 version 6.16.7601

Current Theme C:\WINDOWS\resources\themes\Aero\Aero.msstyles

Graphics 1 1680*1050 pixels. 2 Monitors.

Graphics 2 32 Bit Color Depth. 96 XDpi. 96 YDpi.

Local Time 2016-02-10 17:45

GMT Time 2016-02-10 09:45

Country 44 United Kingdom United Kingdom

Language 0809 English (United Kingdom) English

Physical RAM(MB) 3920

VMCommitted(MB) 449

VMAllocated(MB) 899

VMFree(MB) 169

VMLargestFreeBlock(MB) 169

Number of CPUs 4

CPU 0 Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz 3093MHz

CPU 1 Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz 3093MHz

CPU 2 Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz 3093MHz

CPU 3 Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz 3093MHz

My PC:

========================= Document Info ==========================

Document Y:\MRMaC Internal Control-SOX-OR\AUDIT MSII LIVE ISSUES\QlikView\End User Testing\MSII and Action Plan\MSII and No Action Plan Dashboard Test V1.qvw

Connection Local

DecimalSep Doc="."(2E) Sys="."(2E)

ThousandSep Doc=","(2C) Sys=","(2C)

ListSep Doc=","(2C) Sys=","(2C)

MoneyDecimalSep Doc="."(2E) Sys="."(2E)

MoneyThousandSep Doc=","(2C) Sys=","(2C)

MoneyFmt Doc="£#,##0.00;-£#,##0.00" Sys="£#,##0.00;-£#,##0.00"

TimeFmt Doc="hh:mm:ss" Sys="hh:mm:ss"

DateFmt Doc="DD/MM/YYYY" Sys="DD/MM/YYYY"

TimestampFmt Doc="DD/MM/YYYY hh:mm:ss[.fff]" Sys="DD/MM/YYYY hh:mm:ss[.fff]"

Document File Format 6000 (6000)

Saved in Version 11.20.12018.0409

Client NT Name

Access ADMIN

License -

Document License Status ALLOWED

======================= Object Cache Info ========================

Object Cache Limit (MB) 204.79

========================= QlikView Info ==========================

Client Build Number 11.20.12577.0409

Server Build Number -

QlikTech Product QlikView

License Key 4401 3600 5603 4981

PE Recoveries Remaining 2

CPU Target x86

=========================== INI Values ===========================

AlwaysShowAdvancedDesignMenuItems 1

CanDynamicUpdate 1

CurSelFirstColWidth 39

CurrentQVConnect32Loc C:\Program Files\QlikView\QvConnect32.EXE

DebugDlgHeight 992

DebugDlgWidth 1648

DefaultObjectCaptionStyle 1

DefaultRefLineColor 33554687

DefaultRefLineWidth 8

ExpOvwColWidths 178,173,192,291,120,100,180,1021

ExpOvwColumnMask 94

InstalledLIBID110 {15B258E8-415E-11D1-934D-0040333C91CC}

InterfaceLanguage English

LeasedLicenseCheck 618319f79ba6a2c326c44d8bae2b4b1828a5e4debf0cb3feb227707dd83d1f48

LeasedLicenseExpiry 2015-10-08 07:29:37, 2016-02-10 08:09:05

LeasedLicenseServer qvp://bigr-uat-qvs-2.systems.uk.hsbc

LoadFollowing 1

MarginTop 20

PrintSelectionHistory 0

PrintTimestamp 0

PrintWindowTitle 0

ReportDialogSnapGrid 1

SavedCustomColors CE,FF8000,7D,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF,494949,3535FF,84,FFFFFF,FFFFFF,FFFFFF,FFFFFF,FFFFFF

ShowSystemFields 1

ShowSystemVariables 1

UserRGBMap 141,170,203,252,115,98,187,216,84,255,217,47,102,194,150,229,182,148,231,138,210,179,179,179,166,216,227,171,233,188,27,125,156,255,191,201,77,167,65,196,178,214,178,36,36,0,172,172,190,108,44,105,84,150,80,160,240,240,160,80

Utf8FileDlgPathSaveDoc Y:\MRMaC Internal Control-SOX-OR\AUDIT MSII LIVE ISSUES\QlikView\End User Testing\MSII and Action Plan

======================= Local System Info ========================

Operating System Windows 7 Enterprise Service Pack 1 (32 bit edition)

Operating System Version 6.1.7601

Wow64 mode Not using Wow64

IE Version 9.11.9600.17691

MDAC Version 6.1.7601.17514

MDAC Full Install Version 6.1.7601.17514

ComCtl32 version 6.16.7601

Current Theme C:\WINDOWS\resources\themes\Aero\Aero.msstyles

Graphics 1 1366*768 pixels. 2 Monitors.

Graphics 2 32 Bit Color Depth. 96 XDpi. 96 YDpi.

Local Time 2016-02-10 10:08

GMT Time 2016-02-10 10:08

Country 44 United Kingdom United Kingdom

Language 0809 English (United Kingdom) English

Physical RAM(MB) 3056

VMCommitted(MB) 241

VMAllocated(MB) 536

VMFree(MB) 955

VMLargestFreeBlock(MB) 955

Number of CPUs 4

CPU 0 Intel(R) Core(TM) i5-5300U CPU @ 2.30GHz 2294MHz

CPU 1 Intel(R) Core(TM) i5-5300U CPU @ 2.30GHz 2294MHz

CPU 2 Intel(R) Core(TM) i5-5300U CPU @ 2.30GHz 2294MHz

CPU 3 Intel(R) Core(TM) i5-5300U CPU @ 2.30GHz 2294MHz

Message was edited by: Neil Woodham Added the data table

petter · ‎2016-02-10

Usually this error message has boiled down to nasty bugs when you have complicated expressions in certain charts. The container object as such has had some problems too. So this might not at all be a matter of too little RAM in the PC's you are using.

Is this an application you made yourself - if so can you describe whether you have complicated expressions in any of the charts.

What kind of charts experience these problems - is it one or multiple? Does the error message occur immediately when he is opening the application or after a while when using it?

It might even be a symptom of a complex or too complex data model that might need to be tuned. Could you share a screenshot of the Table Viewer?

Are there any synthetic keys in the data model?

View solution in original post

avinashelite · ‎2016-02-10

As per my knowledge its not the issue with the PC..It might be the issue with the availability of the RAM. Qlikview is an in-memory application you need enough RAM in order to open a file ..

try like this ask problem facing person to close all the apps which are consuming the RAM and try to open this document it should open....then also check the RAM size on his machine

flipside · ‎2016-02-10

Looking at the specs, the Phillipines laptop has more RAM and faster processors. There's also a 32-bit/64-bit difference.

I agree with you that the user needs to try opening with everything else closed down to see if the issue persists.

petter · ‎2016-02-10

Usually this error message has boiled down to nasty bugs when you have complicated expressions in certain charts. The container object as such has had some problems too. So this might not at all be a matter of too little RAM in the PC's you are using.

Is this an application you made yourself - if so can you describe whether you have complicated expressions in any of the charts.

What kind of charts experience these problems - is it one or multiple? Does the error message occur immediately when he is opening the application or after a while when using it?

It might even be a symptom of a complex or too complex data model that might need to be tuned. Could you share a screenshot of the Table Viewer?

Are there any synthetic keys in the data model?

tinkerz1 · ‎2016-02-10

Hi,

I dont have any Syn Keys, but I have made alot of cross tables in the load script based on one key into the min table.

Would these extra tables be enough to cause RAM issues?

avinashelite · ‎2016-02-10

if you have any unused tables or columns in the script ....then delete those tables or columns at the end of your script so that will reduce the size of the file to certian extent ...

tinkerz1 · ‎2016-02-10

we are only talking 200mb QVW, this is not large. I can delete more columns in the load script.

avinashelite · ‎2016-02-10

whats the RAM size of the PC where its not working ?

tinkerz1 · ‎2016-02-10

Hi,

its 4gb, but I need to check how much RAM is being used when Qlik is run.

avinashelite · ‎2016-02-10

did you tried to close all other documents and then try to open the QVW ?

Allocated memory exceeded across a network but on Similar Laptops