Log Queries being executed by PutDatabaseRecord

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Log Queries being executed by PutDatabaseRecord

fredaffini
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/
Reply | Threaded
Open this post in threaded view
|

Re: Log Queries being executed by PutDatabaseRecord

Mike Thomsen
You should be able to enable debug logging on the JDBC driver itself.

On Thu, Feb 21, 2019 at 11:35 AM fredaffini <[hidden email]>
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/
>