[
https://issues.apache.org/jira/browse/NIFI-8005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17656263#comment-17656263
]
Daniel Stieglitz commented on NIFI-8005:
----------------------------------------
[~sb_adv] Looking at the code the file does not disappear but rather exists in
the "original" relationship. There is actually a unit test
[here|https://github.com/apache/nifi/blob/60b08cc5695da73496710e062ef2a8ac889700db/nifi-nar-bundles/nifi-poi-bundle/nifi-poi-processors/src/test/java/org/apache/nifi/processors/poi/ConvertExcelToCSVProcessorTest.java#L508]
which is your exact case where the sheet name does not exist. Hence this is
not a bug but rather expected behavior. That said there is still room for
improvement. At a minimum it be should be stated in the documentation what
happens if the sheet name does not exist as it is not obvious as you have
reported. In addition I believe there should be a bulletin indicating the
requested sheet does not exist.
> ConvertExcelToCSVProcessor swallows flow file if it doesn't contain sheet
> with given name
> -----------------------------------------------------------------------------------------
>
> Key: NIFI-8005
> URL: https://issues.apache.org/jira/browse/NIFI-8005
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.12.1
> Reporter: Svyatoslav
> Priority: Critical
> Attachments: image-2020-11-14-21-49-32-932.png
>
>
> Input xlsx file contains sheets: sheet1, sheet2
> ConvertExcelToCSVProcessor configuration:
> !image-2020-11-14-21-49-32-932.png!
> Input file doesn't have sheet with name mysheet1. After being processed by
> ConvertExcelToCSVProcessor it disappears: it is neither in any output or
> input queues.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
