f Frank
on

 

Would you kindly help me re the followin error I frequently get when running a validation against an ODM output:

java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters
 at org.apache.poi.hssf.usermodel.HSSFCell.setCellValue(HSSFCell.java:546)
 at org.apache.poi.hssf.usermodel.HSSFCell.setCellValue(HSSFCell.java:520)
 at org.opencdisc.validator.report.ExcelReporter.write(ExcelReporter.java:438)
 at org.opencdisc.validator.report.SchematronResultTransformer.endElement(SchematronResultTransformer.java:166)
 at net.sf.saxon.event.ContentHandlerProxy.endElement(ContentHandlerProxy.java:287)
 at net.sf.saxon.event.ProxyReceiver.endElement(ProxyReceiver.java:172)
 at net.sf.saxon.event.NamespaceReducer.endElement(NamespaceReducer.java:181)
 at net.sf.saxon.event.ComplexContentOutputter.endElement(ComplexContentOutputter.java:391)
 at net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:167)
 at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:305)
 at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:332)
 at net.sf.saxon.instruct.Template.expand(Template.java:98)
 at net.sf.saxon.instruct.Template.processLeavingTail(Template.java:82)
 at net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:297)
 at net.sf.saxon.instruct.ApplyTemplates$ApplyTemplatesPackage.processLeavingTail(ApplyTemplates.java:429)
 at net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:275)
 at net.sf.saxon.instruct.ApplyTemplates$ApplyTemplatesPackage.processLeavingTail(ApplyTemplates.java:429)
 at net.sf.saxon.instruct.ApplyTemplates.defaultAction(ApplyTemplates.java:332)
 at net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:291)
 at net.sf.saxon.instruct.ApplyTemplates.apply(ApplyTemplates.java:169)
 at net.sf.saxon.instruct.ApplyTemplates.processLeavingTail(ApplyTemplates.java:133)
 at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:332)
 at net.sf.saxon.instruct.Instruction.process(Instruction.java:91)
 at net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:164)
 at net.sf.saxon.instruct.Template.expand(Template.java:98)
 at net.sf.saxon.instruct.Template.processLeavingTail(Template.java:82)
 at net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:297)
 at net.sf.saxon.Controller.transformDocument(Controller.java:1513)
 at net.sf.saxon.Controller.transform(Controller.java:1346)
 at org.opencdisc.validator.DefaultValidator.runHierarchicalValidation(DefaultValidator.java:381)
 at org.opencdisc.validator.DefaultValidator.validate(DefaultValidator.java:268)
 at org.opencdisc.validator.gui.ValidatorClient$ProcessMonitor.run(ValidatorClient.java:1476)

Thanks a lot in advance!

Frank

Forums: Troubleshooting and Problems

t Tim
on April 28, 2010

Hi Frank,

 

I'm not sure what kind of behaviour that's expected validating an entire ODM file, as the define.xml validation only anticipates the define.xml elements. I think that it should be fine, but I'll be sure to test this for myself to see if there are any obvious problems. At any rate, this error is thrown because one of the messages produced by the validator is over 32,767 characters long, which is more than the Excel format allows per cell. If you switch your report format to CSV for whichever file causes this exception, you should see at least one very long line in the report, which will help clue us in to what exactly causes such a long message to be produced so that we can fix it.

 

Like I mentioned before, I'll also do my own testing, so if I figure out what the problem might be on my own I'll let you know, and then I'll make sure that it's fixed for the next release.

 

Regard,

Tim

Want a demo?

Let’s Talk.

We're eager to share and ready to listen.

Cookie Policy

Pinnacle 21 uses cookies to make our site easier for you to use. By continuing to use this website, you agree to our use of cookies. For more info visit our Privacy Policy.