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.san...@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.sankaralin...@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) <pwi...@micron.com> >> wrote: >> >> Use the Download button right next to View, then open it in a text editor. >> >> >> >> *From:* Aruna Sankaralingam [mailto:aruna.sankaralin...@cormac-corp.com >> <aruna.sankaralin...@cormac-corp.com>] >> *Sent:* Monday, September 25, 2017 9:54 AM >> *To:* 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) <pwi...@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.sankaralin...@cormac-corp.com >> <aruna.sankaralin...@cormac-corp.com>] >> *Sent:* Saturday, September 23, 2017 2:57 AM >> *To:* 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> >> >> >> >> >