nifi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fredaffini <frederico.aff...@gmail.com>
Subject Log Queries being executed by PutDatabaseRecord
Date Thu, 21 Feb 2019 16:28:15 GMT
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/

Mime
View raw message