Hi Community,
We are facing an error with the PutSQL processor while inserting a batch of 20
flowfiles per transaction. Each flowfile contains a record to insert.
Quite often, we get an error that it couldn't insert a record into the
database, so the flowfile exits on Retry, but when it retries
Hi Sergio,
I'm not a nifi dev , but for my experience with mysql , it seems that you
have some problem writing multiple operations in single transaction in the
database.
Looking in the mysql documentation i didn't find any configuration that
limit the number of operations by transactions, so we hav
Sergio,
Your email says the flowfiles each contain a record to insert, but
PutSQL takes a full SQL statement such as INSERT INTO tableName VALUES
('hello', 'world', 1). If you have a record of data rather than a SQL
statement, you can use PutDatabaseRecord for that instead. If you do
have SQL stat