Use the Download button right next to View, then open it in a text editor. From: Aruna Sankaralingam [mailto: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<mailto: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] 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>