99% of our users use WRS to create or consume reports. We are currently at SAS EBI 9.1.3 and WRS at 3.1. The WRS is hosted using WebSphere on an AIX box. Our problem is that if a user forgets applying a filter for its query(or purposely doing a very big query or export a huge dataset), the query/export can be as big as hundreds of millions. This will unfailingly bring our web application server down for exceeding the heap size we set(3.6G). OutOfMemoryError will be complained for this crash then. This happened to us fairly frequently (once a month or more). I am just wondering if you there have this issue and this frequency, any thing you may do to prevent this happening. Thanks in advance. -Haiyan ... View more

Hi Forks, We tried to run a stored process from WRS and get the following error message: ============================================================ Error messages:There is a problem with the current page. Error Rendering the Report Storedprocess did not run successfully: cxo.200.ex.msg: LogicalServer A52IEFCM.AV000002 must be associated with at least one ServerComponent through the UsingComponents association.! Root Cause: com.sas.report.render.models.ReportModelException: Storedprocess did not run successfully: cxo.200.ex.msg: LogicalServer A52IEFCM.AV000002 must be associated with at least one ServerComponent through the UsingComponents association.! at com.sas.report.render.util.SASProcessUtil.runSASProcess(SASProcessUtil.java:124) ........(rest ommited) ============================================================= Our problem is that our stored process server seems never working since it was installed(for Development). And only recently our developer wanted to use it and we started testing the stored process server and got here. Can any one out there give me some hints to trouble should this? Thanks. ... View more