[IDV #HCX-956016]: Out of memory error

> Full Name: Adam Smith
> Email Address: address@hidden
> Organization: Missouri Botanical Garden
> Package Version: 3.0u2 build date:2012-02-10 17:21 UTC
> Operating System: Windows 7
> Hardware: Java: home: C:\Program Files (x86)\Java\jre6 version: 1.6.0_32 
> j3d:1.5.2 fcs (build4)
> Description of problem: The error below is no longer true for newer versions 
> of Excel, and it wouldn't matter anyway if I save to a CSV.
> 
> Writing grid to xls file: C:\Work\pointDataList1948
> You cannot have more than 255 columns in a given row (IV).  Because Excel 
> can't handle it
> 
Adam,
Yes, the new excel can handle more than 256 columns.

But, the IDV calls org.apache.poi.hssf.usermodel to create columns and the 
limitation for this usermodel is still the same. The solution is to switch to 
use org.apache.poi.xssf.usermodel, and this will involve other consideration. 
We will discuss this in our developer meeting and I can not promise anything at 
this moment.

If you still have Java heap space issue, please try the nightly release.
Yuan

> ******************
> Stack trace:
> java.lang.RuntimeException: You cannot have more than 255 columns in a given 
> row (IV).  Because Excel can't handle it
> at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:908)
> at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:168)
> at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:149)
> at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:133)
> at ucar.unidata.data.grid.GridUtil.writeGridToXls(GridUtil.java:5590)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:186)
> at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:204)
> at org.python.core.PyObject.__call__(PyObject.java:404)
> at org.python.core.PyObject.__call__(PyObject.java:408)
> at org.python.pycode._pyx64.writeGridToXls$36(<string>:332)
> at org.python.pycode._pyx64.call_function(<string>)
> at org.python.core.PyTableCode.call(PyTableCode.java:165)
> at org.python.core.PyBaseCode.call(PyBaseCode.java:149)
> at org.python.core.PyFunction.__call__(PyFunction.java:327)
> at org.python.pycode._pyx66.f$0(<string>:1)
> at org.python.pycode._pyx66.call_function(<string>)
> at org.python.core.PyTableCode.call(PyTableCode.java:165)
> at org.python.core.PyCode.call(PyCode.java:18)
> at org.python.core.Py.runCode(Py.java:1261)
> at org.python.core.__builtin__.eval(__builtin__.java:484)
> at org.python.core.__builtin__.eval(__builtin__.java:488)
> at org.python.util.PythonInterpreter.eval(PythonInterpreter.java:190)
> at ucar.unidata.data.DerivedDataChoice.getData(DerivedDataChoice.java:773)
> at ucar.unidata.data.DataChoice.getData(DataChoice.java:637)
> at ucar.unidata.data.DataInstance.getData(DataInstance.java:243)
> at ucar.unidata.data.DataInstance.getData(DataInstance.java:207)
> at ucar.unidata.data.DataInstance.dataOk(DataInstance.java:295)
> at ucar.unidata.data.point.PointDataInstance.init(PointDataInstance.java:83)
> at ucar.unidata.data.point.PointDataInstance.<init>(PointDataInstance.java:69)
> at 
> ucar.unidata.idv.control.ObsDisplayControl.doMakeDataInstance(ObsDisplayControl.java:795)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.initializeDataInstance(DisplayControlImpl.java:3153)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.setData(DisplayControlImpl.java:3135)
> at ucar.unidata.idv.control.ObsListControl.setData(ObsListControl.java:425)
> at ucar.unidata.idv.control.ObsListControl.init(ObsListControl.java:138)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.init(DisplayControlImpl.java:1402)
> at 
> ucar.unidata.idv.control.DisplayControlImpl.init(DisplayControlImpl.java:1085)
> at ucar.unidata.idv.ControlDescriptor.initControl(ControlDescriptor.java:986)
> at ucar.unidata.idv.ControlDescriptor$1.run(ControlDescriptor.java:911)
> at ucar.unidata.util.Misc$3.run(Misc.java:1090)
> 
> 
> 


Ticket Details
===================
Ticket ID: HCX-956016
Department: Support IDV
Priority: Normal
Status: Closed