#106 Open reports crashing in our production environment

open
nobody
9
2012-01-25
2012-01-25
Naveena Mandava
No

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.

Discussion

  • Our JVM settings are min- 126 and max is 1026MB

     
    • priority: 5 --> 9
     
  • 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.