[
https://issues.apache.org/jira/browse/NIFI-10029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17537809#comment-17537809
]
Matt Burgess commented on NIFI-10029:
-------------------------------------
Can you share your config, or a sample flow, or your table definition? I tried
with the following table definition:
create table test1 (
id INT PRIMARY KEY IDENTITY (1, 1),
first_name VARCHAR (50) NOT NULL,
last_name VARCHAR (50) NOT NULL
);
I created another table without the IDENTITY(1,1) part. I inserted the same row
into both tables (leaving out the "id" field from the first table since it's an
identity definition), then updated "first_name" on both successfully. I was
using Azure SQLServer with driver mssql-jdbc-10.2.1.jre8.jar.
> 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)
