[
https://issues.apache.org/jira/browse/NIFI-13819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Stieglitz updated NIFI-13819:
------------------------------------
Status: Patch Available (was: In Progress)
> Provide row number and sheet name if ExcelReader throws exception when it
> fails to convert a value
> --------------------------------------------------------------------------------------------------
>
> Key: NIFI-13819
> URL: https://issues.apache.org/jira/browse/NIFI-13819
> Project: Apache NiFi
> Issue Type: Improvement
> Reporter: Daniel Stieglitz
> Assignee: Daniel Stieglitz
> Priority: Minor
>
> 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
> {code:java}
> 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)
> {code}
> 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.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
