Crystal APS Instance Max Load 1

[Guest_imported]

I've noticed that in CE 8.0 that the APS can only handle around 70,000 instances. After this it becomes a bit unstable. Anyone got any ideas how to get around this issue, say you might want 200,000 + ??

 

[SteveRemington]

The key thing about APS performance is the available memory on the server on which the APS service runs. Each user, folder, report and instance that exists on the system has some information about it loaded into the server memory when the APS is running.

I suggest that you increase the amount of memory on the APS server and see if that improves stability.

Also are this many instances really required to be kept on the system? 70,000 - 200,000 instances seems to be a very large number? Maybe archiving some of the instances might help.

 

[jksho]

Hi All,
My report is currently running in Crystal Enterprise 8.0. Since my report has quite a number of images (one particular .rpt file size is quite big, around 4.0Mb, due to all the images). Is there any settings in Crystal Enterprise where it allows the server to cache the images so that it can be loaded quickly.

Thanks...
jksho

 

[nbk13nw]

Crystal 8.5 ad probably 8.0 as well, have memory usage limitations that are application specific.

Memory usage for the APS.exe is a combination of logged in users, number of report instances, number of recurring instances and number of existing user accounts.

Above 1.6GB of memory usage, Windows NT / 2000 the OS gets flakey. CE 8.5 will not use more than 2GB of RAM and without a bootloader entry, Windows 2000 will not use more than 3GB of total memory.

We put the switch in, but when taking in just over 100,000 instances, the APS.exe service eventually shuts down on its own. It gets to just above 1.8GB of memory usage. We backed it down to 60,000 instances and it settled in at around 1.2GB to 1.4GB of memory, and runs fine.

Our reasoning for this is that we have over 100,000 report instances, 15,000+ users and over 10,000 recurring reports. Pulling the metrics on the system at the default value of 10,000 instance limit usually fails due to the 9 minute default timeout in CE. So when trying to manage objects, users or pull metrics, it would take from 6 to 9 minutes to get the data, if it returned at all.

Our thinking was to pull all of the instances into memory and therefore speed up the use of these tools, and make them functional again. At the 60,000 level. It definitely speed up the tools to 1 minute or less.

Our hardware is as follows:

2 x Web servers (Dual 2.8GHZ Xeon, 4GB RAM)
2 x WCS servers - (Quad Xeon 2.0GHZ, 4GB RAM)
2 x APS servers (Clustered) - (Quad Xeon 2.0GHZ, 4GB RAM)
2 x JSPS servers - (Quad Xeon 2.0GHZ, 4GB RAM)

 

[nbk13nw]

It seems that I forgot to give you the information needed. If you go into the registry and look under "HK_Local_Machine/Software/Crystal Decisions/8.5/APS/Instances/"Your APS server Name Here"/MaximumObjectsToKeepInMemory" The default of 10,000 instances sho9uld be there unless previously changed. Take care with this setting snice the PAS on version earlier than CE 9.0 will not use more than 2GB of memory. Anything close to 2GB can cause stability issues with the application. Again, ours is set for 60,000 instances and hovers around 1.2GB for each APS.

 

[LohneB]

Hi -

I am experiencing a problem with CD 8.5 and the APS component. It was running fine, along with the other CE server components, but stopped while a report was being viewed on a client machine. Reports had been viewed before with no problem, including the one that was being viewed at the time APS stopped. I get a 'Communication Error' when running any of the '.csp' files. I have tried unsuccessfully to restart the APS, including rebooting the machine where CE resides.

Any suggestions would be appreciated.

Bill

Bill Lohne
blohne@lohne.us

 

[synapsevampire]

An annoying ewrror that isn't simple to track down sometimes:

http://support.businessobjects.com/communityCS/TechnicalPapers/ce85_communicationerror.pdf.asp

Consider creating a new thread since the original topic has been covered. You'll find that many people won't even read this since it was already a closed issue.

Plus your problem is different, and the intent of these trheads is to allow people to find a resolution to a specific problem.

-k

 

[Turkbear]

Hi,
If on Windows ( Yoru did not specify the platform),
check to be sure the service is actually starting, and starting before any other CE services.

If it does not start, look in the event log to see what, if any errors, are generated.