[
https://issues.apache.org/jira/browse/NIFI-10029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17537750#comment-17537750
]
Sajad Hamreh commented on NIFI-10029:
-------------------------------------
Same Issue for SQL server 2019.
I think is related to these changes:
[NIFI-9607] PutDatabaseRecord doesn't honor Update Keys when Quote Identifiers
is true - ASF JIRA (apache.org)
[NIFI-9607: Honor Update Keys when Quoting Identifiers in PutDatabaseRecord by
mattyb149 · Pull Request #5701 · apache/nifi ·
GitHub|https://github.com/apache/nifi/pull/5701/commits]
> Must declare the scalar variable @P7UpdateKey Error
> ---------------------------------------------------
>
> Key: NIFI-10029
> URL: https://issues.apache.org/jira/browse/NIFI-10029
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.16.0
> Reporter: MohammadReza Khedri
> Priority: Major
> Labels: Nifi
>
> When I wanted to *update* the database with *PutDatabaseRecord* in *Apache
> nifi 1.16.0* I got the below error:
> {{{}Routing to failure.: Must declare the scalar variable
> "@P7UpdateKey".{}}}{{{}{}}}
> {{}}
> Note: this error occurred when updating data in the *SQL Server*
> But there is no problem when *inserted* into the database.
> I think there was such a problem when I updated to version {*}1.16.0{*}. But
> I'm not sure about that.
> Production environment working with version 1.15.3 fine.
> [https://stackoverflow.com/questions/72171106/apache-nifi-must-declare-the-scalar-variable-p7updatekey-error|https://stackoverflow.com/questions/72171106/apache-nifi-must-declare-the-scalar-variable-p7updatekey-error]
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
