[NIFI-6438] PutSQL complaining about missing database.name even when it is set

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.2
• Fix Version/s: 1.9.2
• Environment: Linux
• Assignee: Unassigned
• Reporter: Behrouz
• Created: 12/Jul/19 18:39
• Updated: 17/Jul/19 02:21
• Resolved: 17/Jul/19 02:20

Description

I am going to use PutSQL with DBCPConnectionPoolLookup, but sometimes PutSQL doesn't process the incoming flow and show this error:

Failed to process session due to Attributes must contain an attribute name 'database.name': org.apache.nifi.processor.exception.ProcessException: Attributes must contain an attribute name 'database.name'

I set the 'database.name' correctly but it doesn't work.
I use several PutSQL in the way of fileflow, some of them work but a few doesn't work.
This error happened when I send several (more than 60) flowFile to the PutSQL processor.

Somebody else has reported this issue:
http://apache-nifi.1125220.n5.nabble.com/DBCPConnectionPool-Not-looking-up-td25170.html

Issue Links

• duplicates: NIFI-5970 PutSQL with batch size > 1 + DBCPConnectionPoolLookup results in missing database.name