We have been using it with 3000 row limit without any crashes on user facing servers. On non-user facing server we set it upto 30,000 for reports etc... Also there is a table chunk size -- we set it to 200 rows.
On Aug 10, 11:41 am, "Shetler, Cindy S" <[email protected]> wrote: > I think we ended setting ours to 10000 rows as well and don't think we've had > any issues since. > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Ortega, Jesus A > Sent: Wednesday, August 10, 2011 12:28 PM > To: [email protected] > Subject: Re: java.lang.OutOfMemoryError: Java heap space. > > ** > I have been having this problem for two months and have a critical ticket > opened with BMC. We were on MT 7.5.3. It took almost two months to talk to a > US based engineer and get the proper support. They had me do a number of > things: > - Patch the mid-tier to 7.5.7, > - Decrease perm size to 128 and max to 256 (I had it 256m -512m) > - Turned on persistent caching, this caused some instability so I turned it > off > - set the following in Tomcat's configuration page under the Java options > tab: -XX:+HeapDumpOnOutOfMemoryError > - there was a setting in the mid-tier config.properties files that is set > incorrectly out of the box and has to do with ecache: > arsystem.ehcache.referenceMaxElementsInMemoryWeight.formFields=28.577. It > should be set to 8.577 > > After all of this, we still had crashes every Monday and Wednesday mornings. > In the end, drum roll please, it was the AR Server Administration setting for > "Max Entries Returned by Getlist" in the Server Information\configuration > tab. It was set for 0, which would allow a user to do a search on the > mid-tier that would allow thousands of rows to be returned. It turned out > that some users would do a search on Asset Management and would request 20000 > - 60000 rows and consume 450mb of heap space in Java. Since we are setting > our heap space to 1024 and our server runs at an average of 700mb, the 450mb > query would cause the java heap errors. I set maximum on Getlist to 1000 > rows, but this caused AR System to start crashing. So, I bumped it up to > 10000 rows and it seems to be working okay and Tomcat has not crashed in a > week. Check on the Max Entries Returned by Getlist and see if that helps. I > ask this to the other admins, what is the happy medium for Getlist that will > not cause AR System to crash? I am still going through trial and error, but > 10000 rows seem to be a okay for now. > > ________________________________ > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Michele Mizell > Sent: Monday, July 25, 2011 10:22 AM > To: [email protected] > Subject: java.lang.OutOfMemoryError: Java heap space. > > All, > We are intermittently receiving "java.lang.OutOfMemoryError: Java heap space" > in our midtier logs. > We have 2 Load Balanced servers which are running Apache Tomcat 5.5.28 and > IIS 6. > Our min and max memory pool for Java is set to 1024 per BMC's recommendation. > These are dedicated servers : > Windows 2003 Standard x64 Edition SP2 > > Our heap memory is constantly maxed out. Has anyone experienced this error > in your environment? BMC support has not been helpful in determining the > cause and solution. > > Sincerely, > > Michele Mizell > > Application Maintenance > > Software Engineer 1 > > JCPenney Co., Inc. > > Ext.11088 > > [email protected] > > The information transmitted is intended only for the person or entity to > which it is addressed and > may contain confidential and/or privileged material. If the reader of this > message is not the intended > recipient, you are hereby notified that your access is unauthorized, and any > review, dissemination, > distribution or copying of this message including any attachments is strictly > prohibited. If you are not > the intended recipient, please contact the sender and delete the material > from any computer. > > Information contained in this email is subject to the disclaimer found by > clicking on the following > link:http://www.lyondellbasell.com/Footer/Disclaimer/ > _attend WWRUG11www.wwrug.comARSlist: "Where the Answers Are"_ _attend > WWRUG11www.wwrug.comARSlist: "Where the Answers Are"_ > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

