# RequestError: Must declare the scalar variable \[MSSQL-PLUS\]

**URL:** <https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508>\
**Category:** General\
**Created:** [10 November 2021 14:03 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508 "2021-11-10T14:03:13Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![idlvpfk](https://avatars.discourse-cdn.com/v4/letter/i/3be4f8/32.png) [@idlvpfk](https://discourse.nodered.org/u/idlvpfk)\
**Post date:** [10 November 2021 14:03 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/1 "2021-11-10T14:03:13Z")

</div>

Hello,

In sandbox env. suddenly im facing MSSQL-PLUS node notifcation(error):  
"RequestError: Must declare the scalar variable "@Company"."  
MSSQL node:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/f/8f1c026ad568c89946df53c9cc4c1ada0db57a64.png)

Strange thing, that is was not changed/modified.

Can somebody help me out?

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [10 November 2021 14:20 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/2 "2021-11-10T14:20:14Z")

</div>

Did you pass the value in your message payload? Maybe it's not set or `undefined` so the MSSQL lib would complain it's missing.

---

<div class="post-metadata">

**Author:** ![idlvpfk](https://avatars.discourse-cdn.com/v4/letter/i/3be4f8/32.png) [@idlvpfk](https://discourse.nodered.org/u/idlvpfk)\
**Post date:** [10 November 2021 14:30 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/3 "2021-11-10T14:30:47Z")

</div>

Hi Kuema,

Its not long flow

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/8/5866ebbb41bc3a948ba8f297f4d68564ae72986c.png)  
As i mentioned before, it wasn't changed! Here s screenshot from split to SQL  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/5/d52ba2514f2faf35d0b04708835df456e2f2fd8b.png)

Error in debug:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/a/6af52d703c5f1d823a0e7be10f043eb1ebb83d90.png)

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [10 November 2021 14:33 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/4 "2021-11-10T14:33:53Z")

</div>

What's the output of the debug node attached to your function node? Does the payload contain `Company`? I'd check that first.

---

<div class="post-metadata">

**Author:** ![idlvpfk](https://avatars.discourse-cdn.com/v4/letter/i/3be4f8/32.png) [@idlvpfk](https://discourse.nodered.org/u/idlvpfk)\
**Post date:** [10 November 2021 14:36 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/5 "2021-11-10T14:36:32Z")

</div>

Yes, name is hidden, but it looks like this:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/0/30388c7aaedf38b0b0df663eb251f98e3ecdaa26.png)

---

<div class="post-metadata">

**Author:** ![idlvpfk](https://avatars.discourse-cdn.com/v4/letter/i/3be4f8/32.png) [@idlvpfk](https://discourse.nodered.org/u/idlvpfk)\
**Post date:** [10 November 2021 14:40 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/6 "2021-11-10T14:40:56Z")

</div>

So, i remembered something!  
I restarted virtual machine (centos7) , now im looking at palletes and i can see warning sign, I guess i need to uninstall one pallete!  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/1/b1c028ccdc733c45b1a71e3a072a6eca1f8df8cc.png)

all are "in use"  
`i can just npm uninstall node-red-contrib-mssql` ?

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [10 November 2021 14:42 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/7 "2021-11-10T14:42:00Z")

</div>

Ah! That's it! Good spot! Those two nodes use the same id.

You can only install one of them.

Yes... just uninstall the other one and you'll be fine. You have to restart Node-RED after that.

---

<div class="post-metadata">

**Author:** ![idlvpfk](https://avatars.discourse-cdn.com/v4/letter/i/3be4f8/32.png) [@idlvpfk](https://discourse.nodered.org/u/idlvpfk)\
**Post date:** [10 November 2021 14:55 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/8 "2021-11-10T14:55:26Z")

</div>

> [@idlvpfk](#):
>
> npm uninstall node-red-contrib-mssql

Ehhh, did that...  
Still getting same error... RequestError: Must declare the scalar variable "@Company".

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [10 November 2021 15:01 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/9 "2021-11-10T15:01:24Z")

</div>

Which MSSQL node did you use first?

The MSSQL-PLUS node has a lot of settings regarding parameters.

Anyway, I would check the node's settings, as they might not be compatible with each other if you used the other SQL node before.

I don't have a MSSQL setup at home, so I can't check right now.

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [10 November 2021 15:09 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/10 "2021-11-10T15:09:33Z")

</div>

I just checked anyway... 🤓

You have to explicitly set where your parameters come from. So try to set "Parameters" to `msg.payload`. I think it uses `msg.queryParams` by default.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/9/49c875307c915df2804215920e453d02b4510af0.png)

---

<div class="post-metadata">

**Author:** ![idlvpfk](https://avatars.discourse-cdn.com/v4/letter/i/3be4f8/32.png) [@idlvpfk](https://discourse.nodered.org/u/idlvpfk)\
**Post date:** [10 November 2021 15:18 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/11 "2021-11-10T15:18:48Z")

</div>

Ehhh, still getting same error even configuring as you recommended.

---

<div class="post-metadata">

**Author:** ![idlvpfk](https://avatars.discourse-cdn.com/v4/letter/i/3be4f8/32.png) [@idlvpfk](https://discourse.nodered.org/u/idlvpfk)\
**Post date:** [10 November 2021 15:41 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/12 "2021-11-10T15:41:15Z")

</div>

Kuema, you was right!!! MSSQL-PLUS parameters are wayy different!  
Now im re-doing everything and I got first MSSQL column!

Thanks for support @kuema , and have a nice life!

BTW @Steve-Mcl, still using your solution for my problem, it works excellent!

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [10 November 2021 15:46 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/13 "2021-11-10T15:46:34Z")

</div>

No problem. There weren't many options left other than configuration issues due to the switch between two different nodes.

Glad I could help and have fun coding! 🤓

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [24 November 2021 15:46 UTC](https://discourse.nodered.org/t/requesterror-must-declare-the-scalar-variable-mssql-plus/53508/14 "2021-11-24T15:46:50Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.