Memory Allocation error

[redshadow]

Hi All,

Does anyone encountered a Memory Allocation error while running a crystal report from any other product like Visual Basic or other programming languages?

I tried calling a crystal report from one of my application. The report file's size is about 120KB with a lot of formula (about 20-30 formulas) and with 138 persons that is to be extracted by this report.

I takes almost an hour retrieving data and running crystal then it reaches the point that I will generate the error "Memory Allocation error" The exact message is:

Execution error: file 'behavior' error code: 105, pc=0, call=1, seg =0
105 Memory allocation error

I couldn't understand if this is a lack of memory problem as I have enough memory for this even I monitored the activity from the Task Manager. I have about 1GB physical memory and 4GB swap file size. It only reaches to 1GB, sometimes less before it gives the error.

This report is called from one of our application and not from a Visual Basic or other languages so I don't have direct control of the program, it's on the crystal reports where I have control. Another thing is that this report works when person count that is to be retrieved is about 100

Hope anyone can enlight me on this to keep me going on developing my reports. Thanks in advance.

 

[synapsevampire]

Try including technical information when requesting it:

Crystal version
Database/connectivity used

A report that runs for an hour is generally suspicious. I would guess that the data isn't being properly filtered by the database, hence the difficulty.

Does the report run properly from within Crystal alone?

An important thing to check is that any filtering being performed in the record selection formula is reflected in the Database->Show SQL Query.

-k

 

[redshadow]

Hi,

Sorry I forgot to include.

I am using Crystal Reports v.8.0 and SQL Server 2K and I connect using ODBC.

I cannot run this report from Crystal as it is using active data (field definitions only). The application we are using is the one supplying data onto it and neither Database->Show SQL Query can help as this menu is disabled for this report. I don't know why.

I tried to modify the report to use a SQL View instead of its active data so I can run it from crystal and it seemed to work. I will try using active data and call it from Visual Basic and if it works then definitely the application I am using is the problem.

Thanks for the tip synapsevampire.