[NIFI-9763] Correct Configure Details Insert SQL for Auditing

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Assignee: David Handermann
• Reporter: David Handermann
• Created: 04/Mar/22 20:33
• Updated: 08/Mar/22 01:26
• Resolved: 08/Mar/22 01:18

Description

The current 1.16.0-SNAPSHOT version logs a warning when attempting to record component property changes using the ProcessorAuditor:

WARN [NiFi Web Server-21] org.apache.nifi.audit.ProcessorAuditor Unable to record actions: org.apache.nifi.admin.dao.DataAccessException: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "INSERT INTO CONFIGURE_DETAILS (ACTION_ID, NAME, [*]VALUE, PREVIOUS_VALUE) VALUES (?, ?, ?, ?)"; expected "identifier"; SQL statement:
INSERT INTO CONFIGURE_DETAILS (ACTION_ID, NAME, VALUE, PREVIOUS_VALUE) VALUES (?, ?, ?, ?) [42001-210]

This warning is the result of a recent upgrade to H2 database version 2.1, which made VALUE a reserved word.

The insert SQL statement should be updated to escape the VALUE column reference so that property value changes can be persisted to the Flow Configuration History.

Issue Links

• is caused by: NIFI-9585 Upgrade H2 to 2.1.210
• links to: GitHub Pull Request #5838
• links to: GitHub Pull Request #5848