nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aruna Sankaralingam <Aruna.Sankaralin...@Cormac-Corp.com>
Subject RE: [EXT] New to Nifi - Failed to update database due to a failed batch update
Date Mon, 25 Sep 2017 15:47:43 GMT
I updated the insert statement to be in a single line. Again it failed. I checked the flow
file.

INSERT INTO ADR_SUB_NIFI (enrlmt_id, city_name, zip_cd, state_cd) VALUES ('', '', '', '')

What could be the reason for the values to be blank instead of actual values from the CSV
file?

From: karthi keyan [mailto:karthi93.sankar@gmail.com]
Sent: Monday, September 25, 2017 7:15 AM
To: users@nifi.apache.org; Aruna Sankaralingam
Subject: Re: [EXT] New to Nifi - Failed to update database due to a failed batch update

Aruna,

seems failure in your insert statement, don't split the Replacement value(query) in the replacetext
processor into multiple lines and try to be in a single line?

-Karthik

On Mon, Sep 25, 2017 at 4:20 PM, karthi keyan <karthi93.sankar@gmail.com<mailto:karthi93.sankar@gmail.com>>
wrote:
Aruna,

You can download the flow file to see whether your query passed correctly and try execute
the same with you datasoruce.

-Karthik

On Mon, Sep 25, 2017 at 4:04 PM, Aruna Sankaralingam <Aruna.Sankaralingam@cormac-corp.com<mailto:Aruna.Sankaralingam@cormac-corp.com>>
wrote:
I clicked on that as well but nothing seemed to happen.

Thanks
Aruna

On Sep 25, 2017, at 4:33 AM, Peter Wicks (pwicks) <pwicks@micron.com<mailto:pwicks@micron.com>>
wrote:
Use the Download button right next to View, then open it in a text editor.

From: Aruna Sankaralingam [mailto:Aruna.Sankaralingam@Cormac-Corp.com]
Sent: Monday, September 25, 2017 9:54 AM
To: users@nifi.apache.org<mailto:users@nifi.apache.org>
Subject: Re: [EXT] New to Nifi - Failed to update database due to a failed batch update

Hi, thank you for getting back. Could you please let me know how I can see the contents of
the flow file ? The view option doesn't seem to work for me. Please see my last screenshot
in my first email.

Thanks
Aruna

On Sep 24, 2017, at 8:52 PM, Peter Wicks (pwicks) <pwicks@micron.com<mailto:pwicks@micron.com>>
wrote:
Hi Aruna,

Since you are using ReplaceText, you can view the contents of the FlowFile and check that
you can copy/paste the SQL and execute it by hand in Postgres.

If all that works try setting the batch size on PutSQL to 1 record. This will help check if
it’s all records that are having trouble, or just a few bad records.

--Peter

From: Aruna Sankaralingam [mailto:Aruna.Sankaralingam@Cormac-Corp.com]
Sent: Saturday, September 23, 2017 2:57 AM
To: users@nifi.apache.org<mailto:users@nifi.apache.org>
Subject: [EXT] New to Nifi - Failed to update database due to a failed batch update

Hi,

I am new to Nifi. I am trying to load a CSV file into S3 bucket and then load into postgres
database. Please see screenshots below. This is what I have done. I am successful till “Replace
Text”. But I am not sure if the replace text is creating the insert query properly. When
I start the PutSQL, it fails with this error “Failed to update database due to a failed
batch update. There were a total of 30 FlowFiles that failed, 0 that succeeded, and 0 that
were not execute and will be routed to retry”

I tried to see if I can find something in the failure flow file but when I click on View or
Download, nothing is happening. I would really appreciate any kind of guidance to make this
work.

<image001.jpg>


<image002.jpg>

<image003.jpg>



Mime
View raw message