# Sql parameter x was not defined for stored procedure y

**URL:** <https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113>\
**Category:** Ignition\
**Created:** [March 11, 2022, 3:35pm UTC](https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113 "2022-03-11T15:35:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![michael.black](https://avatars.discourse-cdn.com/v4/letter/m/ee7513/32.png) [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\
**Post date:** [March 11, 2022, 3:35pm UTC](https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113/1 "2022-03-11T15:35:56Z")

</div>

I am running version 7.9.13 of Ignition. I have a MSSQL connection established to a Microsoft SQL DB. I have a Microsoft SQL Server JDBC Driver with jar file of sqljdbc4.jar. This computer is currently installed with java version 8 update 321 (build \_1.8.0\_321-b07).  
With this java version I did have to enable the TSL1.0 protocols in order to get the database connection to work.  
The project I am working on is a duplicate of a previous one where all of the transaction groups worked with this same database. The previous project is running on a computer with an earlier version of java.  
Anyways when Ignition tries to execute transaction groups to send data to the database I am now getting an error in the log files that the transaction group has a message of ‘Error forwarding data’. If I expand it is giving me an error message of 'com.microsoft.sqlserver.jdbc.SQLServerException: Parameter x was not defined for stored procedure dbo.y.  
Why is this same group working fine with the same db but this new one is not and I am getting this error? Could it be an issue with the wrong version of the JDBC driver?

---

<div class="post-metadata">

**Author:** ![michael.black](https://avatars.discourse-cdn.com/v4/letter/m/ee7513/32.png) [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\
**Post date:** [March 11, 2022, 4:49pm UTC](https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113/2 "2022-03-11T16:49:33Z")

</div>

Turned out it had to do with permissions on the DB side.

---

<div class="post-metadata">

**Author:** ![Sharvari\_R\_G](https://avatars.discourse-cdn.com/v4/letter/s/a88e57/32.png) [@Sharvari\_R\_G](https://forum.inductiveautomation.com/u/Sharvari_R_G)\
**Post date:** [April 13, 2022, 5:23am UTC](https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113/3 "2022-04-13T05:23:52Z")

</div>

I am able to execute stored procedure from DB but not from my spring boot application.  
“com.microsoft.sqlserver.jdbc.SQLServerException: Parameter out was not defined for stored procedure”  
Could you please let me know what permissions are required on the DB side?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 13, 2022, 9:58am UTC](https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113/4 "2022-04-13T09:58:23Z")

</div>

> [@Sharvari\_R\_G](#):
>
> from my spring boot application

What is this?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [April 13, 2022, 12:51pm UTC](https://forum.inductiveautomation.com/t/sql-parameter-x-was-not-defined-for-stored-procedure-y/57113/5 "2022-04-13T12:51:17Z")

</div>

> [@pturmel](#):
>
> What is this?

Sounds like a question meant for Stack Overflow.