Unstable CR XI reports. Memory issue ? Next schedule runs fine smtimes

[sdiericx]

Crystal Reports XI ( v 11) ( Business Object Enterprise 11.5)
Facing issues with a couple of reports that run multiple times per day. Some instances run fine, within 2 minutes, other instances take much longer sometimes. This can be due to the volume of data I guess,
but then why are reports failing sometimes within the minute they are scheduled and started ?

Error messages that I see are :
* Not enough memory for operation.
* CMS is unstable and will shut down immediately. Reason: Unknown exception in database thread
* Object could not be scheduled within the specified time interval

Have already tried to decrease / increase -maxChildReqs 1 value but that did not resolve the issue.

The reports are querying 2 different Oracle 11G databases.

Thanks in advance folks.

 

[Turkbear]

Hi,
Is your CMS database running on the same Oracle database as the reports?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[sdiericx]

Hi Turkbear,
no the CMS database runs on a seperate Win2003 server. The Oracle databases run on Solaris.

 

[hilfy]

This may not be causing your problem, but it IS something you need to look at. Crystal is not very good about cleaning up after itself - especially when a report fails for some reason. So, you need to do a search of the drive on the server(s) where your reports are running - look for files name ~*.rpt. These are the temp files that Crystal creates when generating reports. The will be in a temp folder somewhere, but where depends on your configuration. Over time, these files will take up a LOT of space on the hard drive and may affect how much virtual memory is available for software to use. Delete all of the files that have a date earlier than the current date.

You'll want to go through and do this clean up on a regular basis.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.