Flowfile is currently penalized in Apache NiFI between ExtractText and PutSQL processors in NiFi

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->SplitText->ExtractText->PutSql in NiFi. All works fine for less records(around 10 records). But when I try it for …


This content originally appeared on DEV Community and was authored by Alok Kumar

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->SplitText->ExtractText->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.

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.


This content originally appeared on DEV Community and was authored by Alok Kumar


Print Share Comment Cite Upload Translate Updates
APA

Alok Kumar | Sciencx (2024-08-19T11:39:42+00:00) Flowfile is currently penalized in Apache NiFI between ExtractText and PutSQL processors in NiFi. Retrieved from https://www.scien.cx/2024/08/19/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi/

MLA
" » Flowfile is currently penalized in Apache NiFI between ExtractText and PutSQL processors in NiFi." Alok Kumar | Sciencx - Monday August 19, 2024, https://www.scien.cx/2024/08/19/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi/
HARVARD
Alok Kumar | Sciencx Monday August 19, 2024 » Flowfile is currently penalized in Apache NiFI between ExtractText and PutSQL processors in NiFi., viewed ,<https://www.scien.cx/2024/08/19/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi/>
VANCOUVER
Alok Kumar | Sciencx - » Flowfile is currently penalized in Apache NiFI between ExtractText and PutSQL processors in NiFi. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/08/19/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi/
CHICAGO
" » Flowfile is currently penalized in Apache NiFI between ExtractText and PutSQL processors in NiFi." Alok Kumar | Sciencx - Accessed . https://www.scien.cx/2024/08/19/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi/
IEEE
" » Flowfile is currently penalized in Apache NiFI between ExtractText and PutSQL processors in NiFi." Alok Kumar | Sciencx [Online]. Available: https://www.scien.cx/2024/08/19/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi/. [Accessed: ]
rf:citation
» Flowfile is currently penalized in Apache NiFI between ExtractText and PutSQL processors in NiFi | Alok Kumar | Sciencx | https://www.scien.cx/2024/08/19/flowfile-is-currently-penalized-in-apache-nifi-between-extracttext-and-putsql-processors-in-nifi/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts