Error with PutDatabaseRecord UPSERT on Oracle w/NiFi 1.18
I'm hoping someone might have a suggestion here. A PutDatabaseRecord processor which was working properly under 1.15 started generating java.sql.BatchUpdateException: ORA-00936: missing expression on a 1.18 cluster.
I'm using the Oracle12+ database type and the incoming flowfile format is Avro - so there should be no Schema inference happening.
It's strange, since that error usually indicates a structural problem with the SQL itself. So, I'm concerned that there is a defect in the 1.18 version of PutDatabaseRecord. But, maybe there is something I can change about the source data or in the properties of the processor which will workaround this issue?
If anyone has seen something like this or has some suggestions I could try, I would appreciate it. Thanks.
