https://community.cloudera.com/t5/Support-Questions/NiFi-LookupRecord-Processor-Bug/m-p/346371#M234857 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/93206">@jacektrocinski</a>&nbsp;,</P><P>&nbsp;</P><P>It would be better to report the bug creating a bug Jira in the Apache project:&nbsp;<A href="https://issues.apache.org/jira/projects/NIFI/summary" target="_blank">https://issues.apache.org/jira/projects/NIFI/summary</A></P><P>&nbsp;</P><P>Cheers,</P><P>André</P><P>&nbsp;</P> Mon, 27 Jun 2022 11:40:47 GMT araujo 2022-06-27T11:40:47Z https://community.cloudera.com/t5/Support-Questions/NiFi-LookupRecord-Processor-Bug/m-p/346358#M234855 <P>I believe I found a bug in the NiFi LookupRecord processor.</P><P><BR />When there is no match for a key in the DatabaseRecordLookupService it returns an error:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jacektrocinski_0-1656323583015.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/34689i23235965854C2D7D/image-size/medium?v=v2&amp;px=400" role="button" title="jacektrocinski_0-1656323583015.png" alt="jacektrocinski_0-1656323583015.png" /></span></P><P>&nbsp;</P><P>The lookup processor config:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jacektrocinski_0-1656324930530.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/34690i03D3A63AD902480E/image-size/medium?v=v2&amp;px=400" role="button" title="jacektrocinski_0-1656324930530.png" alt="jacektrocinski_0-1656324930530.png" /></span></P><P><BR />The input JSON has the following structure:</P><P>&nbsp;</P><LI-CODE lang="markup">[ { "id": 1, "name": "Bitcoin", "symbol": "BTC" }, { "id": 2, "name": "Apecoin", "symbol": "Ape" } ]</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 27 Jun 2022 10:16:08 GMT https://community.cloudera.com/t5/Support-Questions/NiFi-LookupRecord-Processor-Bug/m-p/346358#M234855 jacektrocinski 2022-06-27T10:16:08Z https://community.cloudera.com/t5/Support-Questions/NiFi-LookupRecord-Processor-Bug/m-p/346371#M234857 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/93206">@jacektrocinski</a>&nbsp;,</P><P>&nbsp;</P><P>It would be better to report the bug creating a bug Jira in the Apache project:&nbsp;<A href="https://issues.apache.org/jira/projects/NIFI/summary" target="_blank">https://issues.apache.org/jira/projects/NIFI/summary</A></P><P>&nbsp;</P><P>Cheers,</P><P>André</P><P>&nbsp;</P> Mon, 27 Jun 2022 11:40:47 GMT https://community.cloudera.com/t5/Support-Questions/NiFi-LookupRecord-Processor-Bug/m-p/346371#M234857 araujo 2022-06-27T11:40:47Z https://community.cloudera.com/t5/Support-Questions/NiFi-LookupRecord-Processor-Bug/m-p/346381#M234859 <P>Thanks, I have filed a JIRA bug:&nbsp;<A href="https://issues.apache.org/jira/browse/NIFI-10171" target="_blank">https://issues.apache.org/jira/browse/NIFI-10171</A></P> Mon, 27 Jun 2022 13:35:21 GMT https://community.cloudera.com/t5/Support-Questions/NiFi-LookupRecord-Processor-Bug/m-p/346381#M234859 jacektrocinski 2022-06-27T13:35:21Z