kFetchMemoryExceeded

[Joe Maus]

Hi,

Same thing here - just ran into it.  It should be noted the max size that can be set is 2GB minus 1 byte (2,147,483,647).  Setting the setting to 0 is supposed to allow "unlimited" list size, but this does not work with current version of Studio 10.2 - it is fixed for the next release says support.  And yes, the setting applies to all DAMs apparently.  I wonder what happens when the machine you have set to "unlimited" runs out of memory... 

Kind regards,

Joe Maus
The Convergent Consulting Group, LLC
jmaus at theccgllc.com


> On Aug 31, 2021, at 9:16 PM, Doug Easterbrook <doug at artsman.com> wrote:
> 
> hi Das:
> 
> I got hit with that as well a while back on postgres.  I imagine its common to all dams.     here is note from our code
> 
> # V1007270 Studio 8.1.7 instituted a maximum fetch memory limit at 100gb . This limits the data being returned - shold see error kFetchMemoryExceeded
> # the property is on the statement and is called $maxresultsetsize. Default is 100000000. upped it by 5 times
> Calculate Statement.$maxresultsetsize as 500000000
> 
> so, after making your statement for your dam, you may need to set the $maxresultSetsize
> 
> It is in bytes, not records.  We gave omnis half a gig.  it lets us get a lot more, but we occasionally run into it when somebody tries to read everything :)
> 
> 
> hope that helps.
> 
> 
> 
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
> 
>> On August 31, 2021, at 5:19 PM, Das Goravani <goravanis at gmail.com> wrote:
>> 
>> 
>> I build really huge lists with many thousands of records.
>> 
>> But this one table I am trying to build a list from with just 4000 records I am getting kFetchMemoryExceeded in the lStatus Return field on my fetch statement. 
>> 
>> This table is really fat. Is that why?
>> 
>> It can only fetch 1200 records and it gives that error or status return.
>> 
>> I am going to load it an alternate way, 500 records in a fetch at a time.. 
>> 
>> Is that what I have to do? Is fetch responsive to how fat a table is?
>> 
>> Das
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com