Hello, I am new to Nifi and I am creating a simple Flow that reads from an CSV file and saves to a database table. The flow is working depending on the input .csv for some of the testcases a line in CSV will cause a violation on the database while trying to insert the data.
I would like to know the whole insert command that was attempted against the database, all I have from logs is: 2019-02-21 17:07:09,624 WARN [Timer-Driven Process Thread-2] o.a.n.p.standard.PutDatabaseRecord PutDatabaseRecord[id=107c7d4e-0169-1000-e2cd-5182d88357c7] Failed to process StandardFlowFileRecord[uuid=ee2a63d7-5cca-4b6c-a77d-3c5a3111843c,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1550765225116-1, container=default, section=1], offset=0, length=12484923],offset=0,name=test.csv,size=12484923] due to java.sql.BatchUpdateException: ORA-00001: unique constraint (SYSTEM.SYS_C007013) violated If I could find the line on CSV that caused the error would be good to. Any tips on how to do that? Regards, Fred -- Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/
