# RequestError: Invalid object name

**URL:** <https://discourse.nodered.org/t/requesterror-invalid-object-name/75556>\
**Category:** General\
**Created:** [21 February 2023 23:13 UTC](https://discourse.nodered.org/t/requesterror-invalid-object-name/75556 "2023-02-21T23:13:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![sgoics](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@sgoics](https://discourse.nodered.org/u/sgoics)\
**Post date:** [21 February 2023 23:13 UTC](https://discourse.nodered.org/t/requesterror-invalid-object-name/75556/1 "2023-02-21T23:13:47Z")

</div>

Hi. New to node-red.  
It's been working great to monitor MSS tables that are updated on a schedule. But working with this specific Database is giving me issues. The error is "RequestError: Invalid object name 'WASP.dbo.WASP\_config\_WTC\_hist'."  
This works fine in MSS, not sure why node-red doesn't like this specific DB. At first I thought it was because I'm using a different server than I had been recently. But I tried some different DBs and do not get the error. Any ideas?  
V1.2.6

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/4/94748a666c28c715c31124aff9c19c2a8c7b8b99.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/9/798eea778d573e882272bc8383724b4bb6f920d2.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [21 February 2023 23:25 UTC](https://discourse.nodered.org/t/requesterror-invalid-object-name/75556/2 "2023-02-21T23:25:43Z")

</div>

That mssql node is pretty much abandoned (and had several bugs & unresolved issues).

The best node for mssql is currently [node-red-contrib-mssql-plus](https://flows.nodered.org/node/node-red-contrib-mssql-plus)

---

<div class="post-metadata">

**Author:** ![sgoics](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@sgoics](https://discourse.nodered.org/u/sgoics)\
**Post date:** [22 February 2023 14:50 UTC](https://discourse.nodered.org/t/requesterror-invalid-object-name/75556/3 "2023-02-22T14:50:02Z")

</div>

Dang ok. Yea my entire team is using this and it looks like I'll have to delete mssql to install the mssql plus. So I'll have to get some buyoffs before getting rid of it and have them update their flows. Any other reasons people can think of why there would be an issue accessing this particular DB?

---

<div class="post-metadata">

**Author:** ![sgoics](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@sgoics](https://discourse.nodered.org/u/sgoics)\
**Post date:** [24 February 2023 21:01 UTC](https://discourse.nodered.org/t/requesterror-invalid-object-name/75556/4 "2023-02-24T21:01:47Z")

</div>

Thanks for the direction Steve. I got the buy off from my team and they're converting over. Sounds like we already use it in our prod environment, but not dev. They tested in prod and it worked great. Thanks again!

---

<div class="post-metadata">

**Author:** ![sgoics](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@sgoics](https://discourse.nodered.org/u/sgoics)\
**Post date:** [27 February 2023 18:40 UTC](https://discourse.nodered.org/t/requesterror-invalid-object-name/75556/5 "2023-02-27T18:40:52Z")

</div>

Hi again,

Well the original issue is resolved. However, now when the flow fires I receive a connection locked message on the other flows. For a little background, I have multiple flows that run on a schedule, so they fire around the same time hitting the same server. After updating using mssql plus, these errors started to occur. Am I missing something in the node that should be enabled/disabled? Or can they not all run at the same time?  
Thanks!

 ![flowdoc3](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/3/735cbf4994524d2d2f31ebc0b020fac8d98f3fc4.png)

---

<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:** [28 April 2023 18:41 UTC](https://discourse.nodered.org/t/requesterror-invalid-object-name/75556/6 "2023-04-28T18:41:41Z")

</div>

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