Support Questions
Find answers, ask questions, and share your expertise

Nifi: Failed to update database due to a failed batch update, java.sql.BatchUpdateException: ORA-01031: insufficient privileges

New Contributor

Facing the below privileges issue while nifi put_sql trying to insert/update the data into oracle tables.

Note: tables have full read/write permission.

Thank you for your help.

 

ERROR [2021-09-28 06:56:36,112] [traceId/spanId] [Timer-Driven Process Thread-1] o.a.n.p.s.PutSQL PutSQL[id=557a26e6-9cd2-eerr-899v-445577c256ab] Failed to update database due to a failed batch update, java.sql.BatchUpdateException: ORA-01031: insufficient privileges

0 REPLIES 0
; ;