Convert to excel 2.0 hangs on conversion (125k rows)
Posted: Mon Apr 15, 2013 4:48 pm
Hello,
The convert to excel function hangs when I try to convert anything with over 125k rows. Each row has 30 columns. During the conversion we get ultra high CPU and memory usage on the server. I have cranked up max heap to 10g on the 64bit JVM and this process seems to want to use every bit of it.
4/15/13 9:43:09 AM INFO Executing task 'writeExcel 2.0'
4/15/13 9:48:17 AM INFO Finished task 'writeExcel 2.0'
4/15/13 9:48:17 AM ERROR GC overhead limit exceeded
4/15/13 9:48:17 AM INFO Finished project 'Objective2'
4/15/13 9:48:17 AM ERROR GC overhead limit exceeded
com.linoma.dpa.runtime.JobFailedException: GC overhead limit exceeded
at com.linoma.dpa.runtime.Job.run(Unknown Source)
at com.linoma.dpa.runtime.Runtime.executeProject(Unknown Source)
at com.linoma.dpa.j2ee.forms.ConfigureProjectComponentForm.executeProject(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
I know, who wants a 125k row excel file anyway. I was just testing the limits of the system and excel should be able to do 1 million rows. The conversion process seems a bit slow even on a smaller file. Maybe I need to tweak something in my JVM?
The convert to excel function hangs when I try to convert anything with over 125k rows. Each row has 30 columns. During the conversion we get ultra high CPU and memory usage on the server. I have cranked up max heap to 10g on the 64bit JVM and this process seems to want to use every bit of it.
4/15/13 9:43:09 AM INFO Executing task 'writeExcel 2.0'
4/15/13 9:48:17 AM INFO Finished task 'writeExcel 2.0'
4/15/13 9:48:17 AM ERROR GC overhead limit exceeded
4/15/13 9:48:17 AM INFO Finished project 'Objective2'
4/15/13 9:48:17 AM ERROR GC overhead limit exceeded
com.linoma.dpa.runtime.JobFailedException: GC overhead limit exceeded
at com.linoma.dpa.runtime.Job.run(Unknown Source)
at com.linoma.dpa.runtime.Runtime.executeProject(Unknown Source)
at com.linoma.dpa.j2ee.forms.ConfigureProjectComponentForm.executeProject(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
I know, who wants a 125k row excel file anyway. I was just testing the limits of the system and excel should be able to do 1 million rows. The conversion process seems a bit slow even on a smaller file. Maybe I need to tweak something in my JVM?