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.
What I usually do is add a prompt (I prefer using the report date) before opening the report so that the data is being filtered first before the report is displayed. In effect, the query result that the users will export, if they decide to do so, will also be trimmed down. I think this is a good way for the users to be reminded to always filter the data, otherwise, they will not be able to proceed and view the report
The out of memory error is a result of the webserver's limited memory.
I would recommend that you include a Stored Process in your information map to count the number of records returned in the query and if less than x # run the regular query, otherwise if more than x # are returned then reset the results to 1 row. This row of data could include a message (in all the character fields) "too many results returned to display on website" then the user creating the report will get a message no matter what they have selected to display.
Thank you very much for the idea. Our developer is investigating into this. We have so many maps now to work if we go this direction. But we may pick some maps that involve large volume data to include that stored process. Thanks again.
Thanks Cristian. Yes we do have this directive in place and the MAX_TUPLE_COUNT=10000. I applied the WRS hotfix 17 last Sunday. So I will see if this hotfix may make some difference. Again thanks for mentioning of this.