You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@nifi.apache.org by fredaffini <fr...@gmail.com> on 2019/02/21 16:28:15 UTC
Log Queries being executed by PutDatabaseRecord
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/
Re: Log Queries being executed by PutDatabaseRecord
Posted by Mike Thomsen <mi...@gmail.com>.
You should be able to enable debug logging on the JDBC driver itself.
On Thu, Feb 21, 2019 at 11:35 AM fredaffini <fr...@gmail.com>
wrote:
> 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/
>