The latest articles on DEV Community by Alok Kumar (@alok_kumar_1ff6e706707864). https://dev.to/alok_kumar_1ff6e706707864 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1949332%2Fd3bf9dc2-17ab-4f37-ad23-9e2709e08b2e.png https://dev.to/alok_kumar_1ff6e706707864 en Alok Kumar Mon, 19 Aug 2024 11:39:42 +0000 https://dev.to/alok_kumar_1ff6e706707864/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi-23i4 https://dev.to/alok_kumar_1ff6e706707864/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi-23i4 <p>I have a requirement to read say name of users from a file(all in new lines) and insert to Database(oracle). I am using GetFile-&gt;SplitText-&gt;ExtractText-&gt;PutSql in NiFi. All works fine for less records(around 10 records). But when I try it for 50 or 100 plus records, the connection between ExtractText and PutSql, I am getting "A flowfile is currently penalized and data can not be processed at this time". Also all flowfiles remain in queue.</p> <p>Note in PutSQL I am using simple sql (insert into users_table(user_name) values ('user123'); It works properly for 10, 20 records but when I provide 100+ records then it gets stuck.</p> nifi