Support Questions
Find answers, ask questions, and share your expertise

PutDatabaseRecord NIFI ERROR with Postgresql Identity column

PutDatabaseRecord NIFI ERROR with Postgresql Identity column

Contributor

Hi Folks!

I have NiFi 1.7.1 version.

And I made a table in postgresql 10 db with identity column (like a sequence in old versions). But I faced with an error like:

109280-2putdbrecproc-error.png

This is a config of the PutDatabaseRecord (buttom):

109249-1putdbrecproc-conf.png

And next rowid identity column (buttom):

109188-3db-identity.png

I can fix the issue by set Unmatched Column Behaivior to Ignore or Warn, but this way is not acceptable for me for many different reasons. Is anybody know how fix this issue?

I could create the table by old method with sequence like:

109216-3db-seq.png

and that would be ok. But I want to work with the identity column but not with sequence.

Is any suggestions?

Thanks!