Solved: Re: Allocated memory exceeded across a network but... - Page 2 - 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

tinkerz1 · ‎2016-02-10

I did'nt ask the user to close all other apps, I will be asking shortly, is 200mb a large QVW? I cant see how it is.

avinashelite · ‎2016-02-10

yes ...200mb is a large file with less RAM but for the sever it will small because the server RAM size is more

petter · ‎2016-02-10

Based on what you are saying I would think that the way dimensions are made and or how expressions are made could cause the issue.

Which charts show this error? Is there more than one. Could you share how the dimensions are specified and the expressions?

tinkerz1 · ‎2016-02-10

Is just one pivot table and I have changed the expression, and will be trying again shortly, I am sure its a RAM issue.

petter · ‎2016-02-10

Yes it is a RAM issue - and it is the cause of it we are trying to find....

Dimensions and expressions can contribute to a lot of memory consumption - even run out of memory if they are complex.

I think the free Document Analyzer QlikView-application might be helpful for you to analyze possible memory problems in your data model.

tinkerz1 · ‎2016-02-10

I have check the RAM on the users PC and its about the same as mine with physical memory at 72-76%

So I dont see any issues there, when the QVW is opened across the network and after I saved it.

There still is an allocation memory issue, all we are doing is opening it.

Why would Qlik recalc a pivot table at this point?

tinkerz1 · ‎2016-02-10

Ok so the same licence and similar PC spec in the UK across a network works fine.

But the 2 users overseas are not able to run it, we all have similar PC's, any one have this issue?

We are not on a server version, I really dont thik its RAM although I will optimize it and load 1/3 data and see what happens,

rwunderlich · ‎2016-02-10

I note that the user is using a Personal Edition license. Is he doing a PE recovery on this that is causing the data to be flushed? If so, does the error go away one he reloads?

-Rob

tinkerz1 · ‎2016-02-11

I updated the licence to a profesional licence and after that the data was in the QVW when opened, but still the same data allocation issue on one simple pitvot table. Other users within the UK are opening and running the QVW without error, its the offshore laptop that is the problem.

rwunderlich · ‎2016-02-11

I see that you are running SR8, he is running SR3. Perhaps that's the difference.

-Rob

Allocated memory exceeded across a network but on Similar Laptops