CODEWITHSUNDEEP
apache-nifi
Glasnhost
Glasnhost

Reputation: 1135

Nifi putDatabaseRecord error: no value for PrimaryKey?

I have a putDatabaseRecord Processor that receives a JSON array with field names and values.

Update and insert fail, I can't understand the reason why. The FlowFile in the Provenance Event looks like:

[ {"ID" : 1,"code":1}]

Update fails with

Record does not have a value for the PrimaryKey column 'ID'

Which is false because I can see the column and the value in the JSON FlowFile.

Insert fails with:

Record does not have a value for the Required column 'code'

but again, it's false!

I don't know which other useful information could I put here... Maybe the processor configuration:

Processor configuration I'd like some help troubleshooting this, any idea welcome.

It's my first attempt at using Nifi.

Upvotes: 1

Views: 2615

Answers (1)

Ajeesh
Ajeesh

Reputation: 1646

I had similar issue, I had Update Keys value as [ID] instead of just ID

Upvotes: 1

Related Questions