nifi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fredaffini <>
Subject Log Queries being executed by PutDatabaseRecord
Date Thu, 21 Feb 2019 16:28:15 GMT

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]
PutDatabaseRecord[id=107c7d4e-0169-1000-e2cd-5182d88357c7] Failed to process
[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?


Sent from:

View raw message