Out of memeory error

rbuser

Hi,

I have an application to generate a report (using ReportBuilder), but it
kept running into the 'out of memory' error. It uses 3 TIBQueries to fetch
data from 3 different stored procedures and feed into the report's 3
DataPipelines, one for each of the 3 subreports within the report. The
error happens on all 4 PCs that I tested on, which have different memory and
processor config, ranging from 512MB to 1GB of RAM and 1.x mhz Celeron to
2.x mhz P4. The only difference is at what point of the report it errors
out. The report should generate about 900 pages, and the error happened
around page 300 to page 600 of the report on different systems. After the
error, if you cancel out the report and run it again, it gets the same error
immediately and it happens on one of the TIBQuery.Open. Any ideas? Thanks
in advance.

BC

nardmoseley

Modify the Delphi library path from RBuilder\Lib to RBuilder\Source and then
try running the application under a tool that can check for memory and
resource leaks.

If you have any event-handler code, then as a test try commenting it out.

If the report contains images, then as a test try setting image.Visible to
False.

--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Thanks for the advice.

Does anyone has a recommendation for such a memory tool? I tried looking for
one on the web and they are either too expensive or don't work. Also the
module we need to test is a COM module so it's not a standalone app by
itself.

Bill

nardmoseley

You can check out automated qa, I think they may have a free tool that you
can download, but I have never used. In my opion, a good memory tool and a
good profiling tooler are worth the money. www.automatedqa.com

For testing purposes you might consider running the reports as a stand alone
application. We designed our report server so that it can run as stand alone
application ( good for development and debugging) and it can run within the
context of a windows service (preferred for deployment).



--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

> In my opion, a good memory tool and a

agreed--I don't know of anything that really compares.

Ed Dressel
Team DM