# MSSQL-PLUS - passing array to UDT parameter (TVP param in a stored procedure)

**URL:** <https://discourse.nodered.org/t/mssql-plus-passing-array-to-udt-parameter-tvp-param-in-a-stored-procedure/30049>\
**Category:** General\
**Created:** [14 July 2020 11:31 UTC](https://discourse.nodered.org/t/mssql-plus-passing-array-to-udt-parameter-tvp-param-in-a-stored-procedure/30049 "2020-07-14T11:31:11Z")\
**Posts on this page:** 1\
**Showing post:** 18

<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:** [23 July 2020 09:15 UTC](https://discourse.nodered.org/t/mssql-plus-passing-array-to-udt-parameter-tvp-param-in-a-stored-procedure/30049/18 "2020-07-23T09:15:23Z")

</div>

Not good. I assume it was working immediately before?

NOTE: dont worry, all is not lost (we can fix this)

First, please make a backup of your flow files from the .node-red folder (they will be called flowsxxxx.json)

On to your issue - please check this thread by @knolleary (there is an edge case he wishes to track down - you appear to have hit it)

> [@Windows 10 \[error\] Failed to start server: \[error\] TypeError: Cannot read property](https://discourse.nodered.org/t/windows-10-error-failed-to-start-server-error-typeerror-cannot-read-property/18600/8):
>
> Hi @dougcr4 this is a rare issue that we've never managed to get to the root cause of. If you are still hitting it, could I trouble you to add a bit of debug into the code to help us figure it out? Specifically, if you edit the file C:\Users\Dell\AppData\Roaming\npm\node\_modules\node-red\node\_modules@node-red\registry\lib\registry.js and look at line 186 you should see: set.types.forEach(function(t) { if (nodeTypeToId.hasOwnProperty(t)) { Please add the …

if you edit the file `C:\Users\vstoresft2\AppData\Roaming\npm\node_modules\node-red\node_modules@node-red\registry\lib\registry.js` and look at line 186 you should see:

```auto
                set.types.forEach(function(t) {
                    if (nodeTypeToId.hasOwnProperty(t)) {

```

Please add the following immediately before it:

```auto
                // START DEBUG
                if (!set.types) {
                    console.log("Module:",module.name);
                    console.log("Path:",module.path);
                    console.log("Set:",setName);
                }
                // END DEBUG
               

```

The next time you restart Node-RED you'll get a bit more information in the log about what node module its loading when it hits the error

* * *

I will follow up shortly on how we can get you running once more

---

_[View the full topic](https://discourse.nodered.org/t/mssql-plus-passing-array-to-udt-parameter-tvp-param-in-a-stored-procedure/30049)._