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

2017-09-27 Thread Koji Kawamura
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 database due to a > fail

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

2017-09-26 Thread Koji Kawamura
] > 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 ReplaceText configuration, s

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

2017-09-26 Thread Aruna Sankaralingam
d 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 > > > Subject: Re: [E

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

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

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

2017-09-25 Thread Aruna Sankaralingam
: 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 insert statement, don't split the Replacement

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

2017-09-25 Thread karthi keyan
mac-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. C

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

2017-09-25 Thread Aruna Sankaralingam
ankaralingam [mailto:aruna.sankaralin...@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

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-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