PutSQL - BatchUpdateException: invalid arguments in call

2022-08-09 Thread Sergio M .
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

Re: PutSQL - BatchUpdateException: invalid arguments in call

2022-08-17 Thread Breno Cesar
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

Re: PutSQL - BatchUpdateException: invalid arguments in call

2022-08-17 Thread Matt Burgess
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