Error with Lucee 5.3.5.92 on Commandbox 5

[phipps73]

When trying to create a spreadsheet I am seeing the following error:

Could not initialize class org.apache.poi.ooxml.util.DocumentHelper when running the following:

loc.spreadsheet = New spreadsheetLib.Spreadsheet(); loc.workbook = loc.spreadsheet.workbookFromQuery( data=loc.qReportData, xmlFormat=true );

Is there a jar missing in Lucee 5.3.5.92 or something in Commandbox?

[cfsimplicity]

Hi Dave. I have reported problems running the library on Lucee 5.3.5.x and it's likely this is what you're seeing.

As I put in that ticket's comments though, the issues appear to go away with a fix deployed in 5.3.6.33.

The strange thing is that having just spun up another 5.3.5.92 Commandbox (5) server, I'm no longer seeing any issues with that version! The tests all pass.

Sorry, but I'm not sure what to make of it at the moment...

[phipps73]

Thanks, I'll try some different versions of Lucee. I'm limited to what I can use at the moment. In the meantime I have dropped down to just using a csv file but will need to come back to an excel format at some point. At this stage I am seeing it when running Lucee on Commandbox. Not sure about when I deploy to the beanstalk.

[cfsimplicity]

In production we're currently using Lucee 5.3.4.85 (on Tomcat) which has proved very stable despite being a SNAPSHOT. I've not had any problems running the library on it.