I am trying to generate a large Excel file with about 22000 rows that is failing on the following error. (It already failed on 44000 rows so I split the data into two chunks.) Is there a way to resolve this other than breaking down my data into smaller chunks?
Java heap space
java.lang.OutOfMemoryError: Java heap space
at org.apache.poi.util.IOUtils.safelyAllocate(IOUtils.java:571)
at org.apache.poi.poifs.nio.ByteArrayBackedDataSource.extend(ByteArrayBackedDataSource.java:85)
at org.apache.poi.poifs.nio.ByteArrayBackedDataSource.write(ByteArrayBackedDataSource.java:62)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.createBlockIfNeeded(POIFSFileSystem.java:448)
at org.apache.poi.poifs.filesystem.POIFSStream\\\$StreamBlockByteBuffer.createBlockIfNeeded(POIFSStream.java:223)
at org.apache.poi.poifs.filesystem.POIFSStream\\\$StreamBlockByteBuffer.write(POIFSStream.java:245)
at org.apache.poi.util.IOUtils.copy(IOUtils.java:422)
at org.apache.poi.util.IOUtils.copy(IOUtils.java:399)
at org.apache.poi.poifs.filesystem.POIFSDocument.store(POIFSDocument.java:145)
at org.apache.poi.poifs.filesystem.POIFSDocument.
at org.apache.poi.poifs.filesystem.DirectoryNode.createDocument(DirectoryNode.java:352)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.createDocument(POIFSFileSystem.java:627)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1386)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1374)
at com.scitegic.excel.XlsxFileUtils.saveWorkbookToFile(XlsxFileUtils.java:202)
at com.scitegic.excel.HSSFExcelWriter.onFinalize(HSSFExcelWriter.java:46)
at com.scitegic.excel.ExcelWriterComponent.onFinalize(ExcelWriterComponent.java:188)
at com.scitegic.pilot.Pilot.callOnFinalize(Pilot.java:454)
CComponentJavaPlugin::onFinalize: Pipeline Pilot exception rethrown
-> 'Excel Writer' ('Write StuctCompareCDDtoSCI1to22k.xls'); Location: 29 - error during Finalization phase
CProtocolBaseImpl::ShutdownStartNodeForNewData: Pipeline Pilot exception rethrown
CProtocolBaseImpl::ShutdownStartNodeForNewData: Pipeline Pilot exception rethrown
CProtocolBaseImpl::ShutdownStartNodeForNewData: Pipeline Pilot exception rethrown
CProtocolBaseImpl::ShutdownStartNodeForNewData: Pipeline Pilot exception rethrown
CProtocolBaseImpl::ShutdownStartNodeForNewData: Pipeline Pilot exception rethrown
CProtocolBaseImpl::ShutdownStartNodeForNewData: Pipeline Pilot exception rethrown
CProtocolBaseImpl::ShutdownStartNodeForNewData: Pipeline Pilot exception rethrown
CProtocolBaseImpl::ShutdownFinishedStartNodes: Pipeline Pilot exception rethrown
CProtocolStd::onProcess: Pipeline Pilot exception rethrown
CProtocol::onProcess: Pipeline Pilot exception rethrown
CComponentRunner::CallProtocolOnProcess: exception caught, calling onFinalize before rethrow
Protocol CDDExtractionByOffset2, user schaphekar: Pipeline Pilot exception caught
Protocol CDDExtractionByOffset2, user schaphekar: Protocol failed: Pipeline Pilot error
Pipeline Pilot Server version 24.1.100.1165
Server OS: Windows
