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

In the end our solution was simple, we opened a webex session and the user deleted the table, then we started a new table.

We built simple dimensions and expressions in the first instance on a limited data set under my instructions until we hit the allocated memory exceeded error.

Then I looked at other charts/tables that where working and changed the problem expression until the error was resolved.

So we are now all working again with a bit more knowledge, maybe it is the different version that caused the error but for now I am happy and we can continue

petter · ‎2016-02-11

So the problem was really in the expression(s) then?

tinkerz1 · ‎2016-02-11

I think so.

petter · ‎2016-02-11

Please mark the thread as answered as your problem got solved

Allocated memory exceeded across a network but on Similar Laptops