Description
While testing NIFI-13726 it was noticed when using the ExcelReader configured with the "Use Starting Row" strategy that the file failed but the message was
org.apache.nifi.processor.exception.ProcessException: Could not parse incoming data .... Caused by: org.apache.nifi.serialization.MalformedRecordException: Read next Record from Excel XLSX failed at org.apache.nifi.excel.ExcelRecordReader.nextRecord(ExcelRecordReader.java:86) at org.apache.nifi.serialization.RecordReader.nextRecord(RecordReader.java:50) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) .... Caused by: java.lang.NumberFormatException: For input string: "" at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67) at java.base/java.lang.Integer.parseInt(Integer.java:672) at java.base/java.lang.Integer.parseInt(Integer.java:778) at org.apache.nifi.serialization.record.util.DataTypeUtils.toInteger(DataTypeUtils.java:1468) at org.apache.nifi.serialization.record.util.DataTypeUtils.convertType(DataTypeUtils.java:211) at org.apache.nifi.serialization.record.util.DataTypeUtils.convertType(DataTypeUtils.java:174)
which does not point to which row the ExcelReader failed on. It would be helpful to include in the exception message which row the reader failed on.
Attachments
Issue Links
- Discovered while testing
-
NIFI-13726 Excel specifications and limits are not respected while splitting
- Resolved
- links to