RE: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-24 Thread Peter Wicks (pwicks)
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

RE: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-25 Thread Peter Wicks (pwicks)
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

Re: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-25 Thread 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 t

Re: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-25 Thread karthi keyan
t; *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 fl

Re: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-25 Thread karthi keyan
aralin...@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

RE: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-25 Thread Aruna Sankaralingam
actual values from the CSV file? From: karthi keyan [mailto:karthi93.san...@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 inser

Re: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-25 Thread Koji Kawamura
> Thanks > > Aruna > > > On Sep 25, 2017, at 4:33 AM, Peter Wicks (pwicks) 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] > Sent: Monday, S

RE: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-26 Thread Aruna Sankaralingam
eason for the values to be blank instead of actual > values from the CSV file? > > > > From: karthi keyan [mailto:karthi93.san...@gmail.com] > Sent: Monday, September 25, 2017 7:15 AM > To: users@nifi.apache.org<mailto:users@nifi.apache.org>; Aruna Sankaralingam

Re: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-26 Thread Koji Kawamura
okaruma...@gmail.com] > Sent: Monday, September 25, 2017 8:19 PM > To: users@nifi.apache.org > Cc: karthi keyan > Subject: Re: [EXT] New to Nifi - Failed to update database due to a failed > batch update > > > > Hi Aruna, > > > > The placeholders in your ReplaceT

Re: [EXT] New to Nifi - Failed to update database due to a failed batch update

2017-09-27 Thread Koji Kawamura
s > well. How do I find out what is wrong? > > > > > > *From:* Koji Kawamura [mailto:ijokaruma...@gmail.com] > *Sent:* Tuesday, September 26, 2017 10:22 PM > > *To:* users@nifi.apache.org > *Cc:* karthi keyan > *Subject:* Re: [EXT] New to Nifi - Failed to update databas