BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Out of Memory - Error


 
Search this topic... | Search Legacy Crystal Products... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Legacy Crystal Products  Previous TopicPrint TopicNext Topic
Author Message
a1b2c3
Forum Member
Forum Member



Joined: 15 Jun 2008

Posts: 16


flag
PostPosted: Tue Oct 14, 2008 1:05 pm 
Post subject: Out of Memory - Error

In CE 9 - we have been running this report for almost five years and the data was varying from 2 Million to 12 Million rows and we never had a problem. Recently we started getting Out of Memory error. so we made couple of changes to report Like Suppressing sub-reports, deleting page numbers, increasing the virtual memory, disk space etc. Even then we were still facing the same problem. This reports runs for about 1 to 2 hrs.
Can anyone assist me on fixing this problem.

Thanks,
Bvcreddy
Back to top
Chamsin
Principal Member
Principal Member



Joined: 05 Jun 2008

Posts: 341
Location: Colorado, USA


flag
PostPosted: Tue Nov 04, 2008 11:17 am 
Post subject: Re: Out of Memory - Error

Crystal has always been RAM intensive. If the computer on which you are running the machine is low on RAM and does not have enough available hard drive space, you will run out of memory.

You might also compare the Select Expert settings to the SQL Query that Crystal generates from it to see if all of your selections are being translated by Crystal into a WHERE clause. If any of them are missing, this means that the local machine is doing all the hard work instead of the server.
Back to top
sdiericx
Forum Member
Forum Member



Joined: 29 Sep 2009

Posts: 2



PostPosted: Wed Feb 09, 2011 11:44 am 
Post subject: Re: Out of Memory - Error

did you have this all of a sudden with 1 report, or with all your reports ? We bumped into a similar situation on CR XI
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1894
Location: Atlanta, GA


flag
PostPosted: Thu Feb 10, 2011 1:39 pm 
Post subject: Re: Out of Memory - Error

One easy thing to do is do a search for ~*.rpt on the machine where this report is running. This is the file name format for the temp files that Crystal creates. Delete all of them that have a date earlier than the current date. Crystal is not very good at cleaning up after itself when a report fails - it leaves a temp file that might be quite large. This will eat up the disk space on the drive until you don't have enough space left to run a large report. (Crystal does a LOT of swapping to disk, especially on large reports.)

-Dell
Back to top
sdiericx
Forum Member
Forum Member



Joined: 29 Sep 2009

Posts: 2



PostPosted: Fri Feb 11, 2011 4:49 am 
Post subject: Re: Out of Memory - Error

hilfy wrote:
One easy thing to do is do a search for ~*.rpt on the machine where this report is running. This is the file name format for the temp files that Crystal creates. Delete all of them that have a date earlier than the current date. Crystal is not very good at cleaning up after itself when a report fails - it leaves a temp file that might be quite large. This will eat up the disk space on the drive until you don't have enough space left to run a large report. (Crystal does a LOT of swapping to disk, especially on large reports.)

-Dell


Hey Dell, I had already cleaned up some temp .rpt files. There were not tht many though, just a handful under \BusinessObjects Enterprise 11.5\Data\procSched\.

I have the impression it's not so much about running out of space, but rather running out of memory. Do not see how I could you a .close or .dispose method to free up resources after each run. Where can this be specified , any hint ? icon_question.gif icon_idea.gif
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1894
Location: Atlanta, GA


flag
PostPosted: Fri Feb 11, 2011 9:46 am 
Post subject: Re: Out of Memory - Error

I'm not as familiar with CE 9 as I am with the BOE and Crystal Server products. Are you either rebooting your server or stopping the CE services and restarting them on a regular basis? If there's a memory leak somewhere, this should help clear the memory that's being used.

Also, my experience has been that frequently an Out of Memory error in Crystal is actually due to disk space issues. Crystal does a lot of its own disk swapping instead of/in addition to using Virtual Memory. So you do need to look at how much free space is available on the C: drive of the server to see if that might be affecting your reports.

-Dell
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Legacy Crystal Products  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0303 seconds using 17 queries. (SQL 0.0025 Parse 0.0009 Other 0.0269)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo