Open reports crashing in our production environment
Brought to you by:
eswenson
Menu
▾
▴
#106 Open reports crashing in our production environment
Hi All,
Can any on help us in fixing the issue in open reports version 2.2.0 running on websphere appserver 6.0. Our amount of data in few queries is huge. The server is crashing with OutOfMemory Error when query returns large amount of data. After that the threads are getting hung and we are not even able to start the server and even worse is it is generating heap dumps and occupying memory in production BOX.
Could not invoke the service() method on servlet webwork. Exception thrown : java.lang.OutOfMemoryError
at sun.text.CompactIntArray.<init>(CompactIntArray.java(Compiled Code))
at java.text.RBTableBuilder.build(RBTableBuilder.java:79)
at java.text.RBCollationTables.<init>(RBCollationTables.java:83)
at java.text.RuleBasedCollator.<init>(RuleBasedCollator.java:341)
at java.text.Collator.getInstance(Collator.java:248)
at org.displaytag.tags.ColumnTag.addHeaderToTable(ColumnTag.java:736)
at org.displaytag.tags.ColumnTag.doEndTag(ColumnTag.java(Compiled Code))
at com.opensymphony.webwork.views.velocity.AbstractTagDirective.processTag(AbstractTagDirective.java(Compiled Code))
at com.opensymphony.webwork.views.velocity.AbstractTagDirective.render(AbstractTagDirective.java(Compiled Code))
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java(Compiled Code))
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java(Compiled Code))
at com.opensymphony.webwork.views.velocity.AbstractTagDirective.processTag(AbstractTagDirective.java(Compiled Code))
at com.opensymphony.webwork.views.velocity.AbstractTagDirective.render(AbstractTagDirective.java(Compiled Code))
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java(Compiled Code))
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java(Compiled Code))
at org.apache.velocity.Template.merge(Template.java:296)
Please suggest some solution. The above is the log trace.
Our JVM settings are min- 126 and max is 1026MB
One more setting in open reports has max rows QueryReport MaxRows =100000000. I know its huge and I am suspecting this might e the problem. Please help.