Exception while trying to generate geoshapes

[muloem]

Context

Data exports are failing in some instances. Investigating shows that the following exception is thrown when the export fails.

java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters
    at org.apache.poi.xssf.streaming.SXSSFCell.setCellValue(SXSSFCell.java:325)
    at org.waterforpeople.mapping.dataexport.GraphicalSurveySummaryExporter.createCell(GraphicalSurveySummaryExporter.java:2067)
    at org.waterforpeople.mapping.dataexport.GraphicalSurveySummaryExporter.createCell(GraphicalSurveySummaryExporter.java:2043)
    at org.waterforpeople.mapping.dataexport.GraphicalSurveySummaryExporter.writeAnswer(GraphicalSurveySummaryExporter.java:913)
    at org.waterforpeople.mapping.dataexport.GraphicalSurveySummaryExporter.writeInstanceDataSplit(GraphicalSurveySummaryExporter.java:665)
    at org.waterforpeople.mapping.dataexport.GraphicalSurveySummaryExporter.fetchAndWriteRawData(GraphicalSurveySummaryExporter.java:536)
    at org.waterforpeople.mapping.dataexport.GraphicalSurveySummaryExporter.export(GraphicalSurveySummaryExporter.java:248)

Problem or idea

Exception is thrown because of an attempt to export a geoshape that is too large to fit within the excel sheet.

Solution or next step

Decision is to:

• truncate the response and limit it to the maximum allowed in the cell.
• Also to validate the geoshapes on import so that any corrupted geoshapes (including the truncated ones) are not imported to overwrite existing ones.