Low HEAP memory

Questions and Answers about DataEase for Windows

Low HEAP memory

Postby robb » Thu Feb 17, 2011 12:57 pm

I keep getting the 'Low HEAP memory' error on one particular report. I have split the procedure up into two seperate procedures but i still get it. It then says 'Could Not Read Report From Disk'. Does anyone have any idea how to get round this error?
robb
 
Posts: 45
Joined: Thu Jan 07, 2010 9:20 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Low HEAP memory

Postby Phil Winkler » Thu Feb 17, 2011 1:31 pm

This error has been discussed a few times on Dataease forums and in most cases the advice is to simplify the procedure by splitting it into small, discrete actions in each procedure. That process can also be called optimization. Why not post a text file of the DQL for us to look at and make suggestions? It has to be less then 60000 characters, tho.
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Low HEAP memory

Postby robb » Fri Feb 18, 2011 9:49 am

Code is as follows:

for VehicleDetails ;

list records
Location in order ;
CustomerName in order ;
any locvd DistributorsName in order ;
any locvd County in order ;
any locvd Town in order ;
ChassisID in order ;
TrailerNo in order ;
RegNo in order ;
FleetNo in order ;
NextADRCDG ;
NextVTT ;
ADRCDGApp ;
NextMeter ;
MeterApp ;
NextSLP ;
SLPApp ;
"A" = "A" : count .
end

Its nowt fancy, it searches through a few thousand records, it puts a table to screen which you can scroll down but at some point every time it will give you a Low HEAP memory error.
robb
 
Posts: 45
Joined: Thu Jan 07, 2010 9:20 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Low HEAP memory

Postby benjji » Fri Feb 18, 2011 11:55 am

robb wrote: it puts a table to screen which you can scroll down

onboard graphics using more memory ?
have you thought about adding a graphics card to take the strain away from normal ram
benjji
 
Posts: 167
Joined: Fri Mar 14, 2008 11:26 am
Location: Stoke-on-Trent & Manchester & Middlesborough
Has thanked: 0 time
Been thanked: 0 time
 

Re: Low HEAP memory

Postby Adrian Jones » Fri Feb 18, 2011 12:22 pm

OK, two guesses.

1. Any virtuals in that list? Any virtuals that look up from other virtuals in other forms, etc?
2. Is the toolbar shown? If so (and this is just a WAG), see what result you get if you turn it off.
User avatar
Adrian Jones
 
Posts: 2000
Joined: Tue Sep 11, 2007 2:38 pm
Location: Cornwall, UK
Has thanked: 5 times
Been thanked: 4 times
 

Re: Low HEAP memory

Postby Phil Winkler » Fri Feb 18, 2011 1:32 pm

Get rid of any "in order" after CustomerName and see how it works.

They simply make no sense to have in the query as I think you'll find out.
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Low HEAP memory

Postby robb » Fri Feb 18, 2011 2:08 pm

And the answers are:
Its an idea with the graphics but i don't have a card to hand at the moment.
There are some fields with derivations to them but none of them are virtual.
The toolbar is off.
Removed all 'in order' statements apart from 1 and it still gave the error.
robb
 
Posts: 45
Joined: Thu Jan 07, 2010 9:20 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Low HEAP memory

Postby Phil Winkler » Fri Feb 18, 2011 3:52 pm

Robb, copy and paste the query (without the in orders) into a new procedure and then test.
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Low HEAP memory

Postby Adrian Jones » Fri Feb 18, 2011 4:31 pm

Then try commenting out 50% of the code, and see if you get the same result. if you do; comment out 50% of what's left, and repeat until you don't get the error.

Once it goes away, then comment back in portions of what is commented out, etc, to try to isolate what might be the problem.

Also suspect those 'anys'. And see what happens if you simply have a for myTable with ... ; end . DQL (i.e. one that doesn't do anything).
User avatar
Adrian Jones
 
Posts: 2000
Joined: Tue Sep 11, 2007 2:38 pm
Location: Cornwall, UK
Has thanked: 5 times
Been thanked: 4 times
 

Re: Low HEAP memory

Postby robb » Mon Mar 28, 2011 7:54 am

DataEase have acknowledged it as a bug so maybe one day it will be fixed!!!
robb
 
Posts: 45
Joined: Thu Jan 07, 2010 9:20 am
Has thanked: 0 time
Been thanked: 0 time
 
 

Return to DataEase for Windows

Who is online

Users browsing this forum: No registered users and 3 guests

cron